You’re offline. This is a read only version of the page.
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
Running Inventory Reconcile worked!
Thank you, Jeff!
John
Hi John,
Thanks for the update! Please let me know if the reconcile works as the orphaned apply records is a general assumption.
Best Regards,
Jeff
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?
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
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 (