web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Trying to add serial n...
Microsoft Dynamics GP (Archived)

Trying to add serial number to existing inventory item

(0) ShareShare
ReportReport
Posted on by Scott Emick 282

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

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Trying to add serial number to existing inventory item

    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.

  • Scott Emick Profile Picture
    Scott Emick 282 on at
    RE: Trying to add serial number to existing inventory item

    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.  

  • Verified answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Trying to add serial number to existing inventory item

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans