Notifications
Announcements
No record found.
Hi:
A serialized inventoried item has 0 quantity on hand and 0 quantity available, yet, it has serial numbers in inventory.
How do you remove the serial numbers, when you can't adjust them out due to 0 quantity?
Thanks!
John
Hi John,
If you haven't already, please insure you run Tools | Utilities | Inventory | Reconcile on the item(s) in question to see if the serial number items will be removed and/or the quantity value will change if the serial number records are valid accordingly.
If the quantity remains the same and there are still records with serial numbers intact in Dynamics GP there is a good chance you have orphaned allocation records in the db that will need to be removed so the serial numbers will no longer be available.
Best Regards,
Jeff Grant
Microsoft Dynamics GP Support
Hi There, Jeff:
In fact, I'm awaiting word from the client on my suggestion to run Inventory Reconcile.
If doing so does not resolve the issue, what sort of tables shall I run scripting against to remove those orphaned allocation records?
Thanks for the update! Please let me know if the reconcile works as the orphaned apply records is a general assumption.
Jeff
Running Inventory Reconcile worked!
Thank you, Jeff!
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 663 Most Valuable Professional
André Arnaud de Cal... 540 Super User 2025 Season 2
Sohaib Cheema 348 User Group Leader
