Hi,
Does inventory reconcile automatically corrects cost layer if it is incorrect? For a non tracked item, cost layer IV10201 is oversold with respect to IV10200. If I would run a reconcile, would it correct the layer? or I would have to manually make adjustments in order to do so.
*This post is locked for comments
Thanks.....issue resolved after successful run of HITB reset tool
Hello Steven
Any update on your inquiry ?
Pleas keep us posted in case you need any further assistance
Hello Steven
For the HITB reset tool , take a look at HITB Essentials Series – HITB Reset Tool Deployment
Thanks very much for such brief information and providing related articles. It was the case of overridden quantity. HITB is also inaccurate. I believe that HITB reset tool would help me out in such case.
Wow, excellent detailing of the whole process. Thanks.
Initially, I believe this is a case in which quantities are being overridden. This means, the system allows to enter "out" transactions even if there is no balance to cover the quantity out. This could occurs form Sales or Inventory module. If this is the reason, and it is not an accepted scenario in your company, make sure to prevent override quantity from the setup level.
As for the inventory reconciliation, such override records are created perfectly in your inventory module, Dynamics GP creates a "dummy" cost layer in IV10200 for the associated override document in IV10201 with a zero quantity received. This means, you may find records in IV10200 which have 0 Quantity Received and an actual quantity under the field quantity sold. This record is flagged in the HITB table (SEE30303) with a value of 1 under the field "IsOverride".
Inventory reconciliation calculates the sum of all sold transactions from IV1021 and make sure that they are equal to the summary quantity sold value in IV10200 according to a specific receipt sequence relationship. You may want to take a look at the following articles as related to inventory reconciliation flow and override documents.
Your feedback is highly appreciated,
Reconciling an item won't affect it's cost. It would only correct the quantity information (qty allocated, qty on hand, qty marked as sold, etc.), if necessary.
You have to pass cost adjustments manually by using "Adjust Costs" utility.
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (