280
I have an item that has ITMTRKOP set as 2 so serial numbers can be entered. However there is one item in inventory without a serial number. When I try to go into Serials and enter one I cannot, nor can I do an item transfer entry to add a serial number.
How can I add the serial number, either through the GUI or using SQL?
Any help greatly appreciated.
Thanks,
Scott Emick
SQL DBA
*This post is locked for comments
Hi Scott,
Beat Bucher is asking you to run Reconcile (Tools - Utilities - Inventory - Reconcile).
You can specify a range by item number, so this process shouldn't take long.
And, as Mr. Bucher correctly points out, this will create an auto generated serial number.
After it's created, then you can do an inventory decrease adjustment to get the auto-generated serial number out of inventory. Then do an increase adjustment where you'll specify the correct serial number.
Thanks,
Justin
Thanks these are serial numbers on cisco switches received from the manufacturer and I don't really want to run check links for 1 serial to add.
Hi Scott,
I know this is probably not the answer you're looking for... but if you run an Inventory reconcile, GP should add the missing Serial Number, though it will be auto-generated I think.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (