You’re offline. This is a read only version of the page.
I just entered inventory adjustments (variance adjustments in GP) for end of year inventory counts. I have a few questions concerning some of the results.
1. In many items I have quantities allocated when I should not have any, and my quantities available do not match what I entered in the variance adjustment. Having said this I have verified open orders and they are not enough to explain why my allocated quantities are so far off what they should be and why my quantities available are so far off.
How can I just force the allocated quantities and quantities on hand to match exactly what I have. I have already reconciled the inventory items.
*This post is locked for comments
Hi Lyn
I figured out what the problem was. The allocated amounts came from variance transactions that were created but never posted. So eliminating the variance transactions eliminated the errors and reset the values to what they should be. Thank You
Hi Lyn
I performed a reconcile. It did not make a single adjustment for sales docs and made a few minor adjustments regarding tax amounts for purchasing. I however still have items with allocated amounts with no sales orders or purchase orders associated with them. So once again how do I reset these amounts to zero.
I recommend you reconcile Sales Order Processing, Purchase Order Process, and then Inventory, in that order. You will need all users to exit from sales transaction entry windows, prior to reconciling.
SOP: Go to Microsoft Dynamics GP >> Tools >> Utilities >> Sales >> Reconcile-Remove Sales Documents.
POP: Go to Microsoft Dynamics GP >> Tools >> Utilities >> Purchasing >> Reconcile Purchasing Documents.
IV: Go to Microsoft Dynamics GP >> Tools >> Utilities >> Inventory >> Reconcile.
Transactions in SOP & POP affect inventory allocations & quantities in inventory, so if merely running the inventory reconcile did not correct the issue, you may need to run the additional utilities.
Here is a link, for more information: support.microsoft.com/.../864622
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (