Announcements
I ran an Inventory Report and it shows some items are allocated with -2.
How is this possible and how can this be fixed?
*This post is locked for comments
Try first running the 'Reconcile Inventory' tool:
Microsoft Dynamics GP > Tools > Utilities > Inventory > Reconcile
When GP works as designed, a negative allocated quantity shouldn't occur.
If this doesn't help you might need to run other reconcile tools.
Running the "Reconcile Inventory" tool will do what exactly? Will this affect anything else besides the allocated inventory?
Is it possible that GP is not working as designed, since we do have a negative quantity allocated?
I wouldn't worry much about it, I have seen this happening many many times.
There are several reasons why this issue could occur: transactions imported incorrectly, third-party products affecting posting, posting interruption, etc.
You can select an Item or a range of Items before running this tools.
Running the Reconcile will look at the Purchasing records, the Sales records and Inventory records and will attempt to determine the correct value for the Allocation field.
This situation happens pretty regularly with GP when Sales Orders are started, held for a while and then either forgotten as ORDERS or deleted days later. During which time changes in the Purchase data for an item will change the values on hand and that is where the fun starts.
The Negative Allocation often is just a 'temporary state' as you know you can not allocate a negative amount.
Follow the suggestion from Jorge, run the Reconile on the inventory - you can restrict ( I believe ) to a single item - it should remove the Negative Allocation.
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Dan Liebl 2
Shravan Attelli 1
