We have an issue where an invoice was entered with several lines and for some reason would not post....so user deleted to try again...although cannot attach the items as they show allocated?
I need to remove the allocation...reconcile and check links have no worked (test database)
Any suggestions....what tables should I be looking at?
tami
*This post is locked for comments
As long as you are working on "Test Environment". You could go through the following steps in order;
Hope this helps,
It is improperly allocated...how do I fix it?
It is not allocated to any document?
It shows all quantity types, from which the "Item Inquiry" retrieves data.
that table shows the items in stock and allocated?
Item inquiry shows items allocated...but no document associated with the allocation?
It seems you have tried the inventory reconcile solely, right ? If yes, please ensure to apply the reconcile in order: Sales then Inventory
One question though, when you go to the "Item Inquiry", and click on the value beside "Allocated", any corresponding documents in the "Item Allocation Inquiry" ?
The allocation is stored under a calculated field in IV00102 (ATYALLOC), this is the same number the shows on the "Item Inquiry" window. Although, on the reconcile, Dynamics GP will recalculates the allocated quantity and update this field accordingly.
Your feedback is highly appreciated.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156