Hello everyone,
I have an AX installation using FIFO. I've performed an inventory close successfully for a past period (Dec 2016). Now I've identified that my inventory value for a specific item is incorrect.
When I go to .../Inventory management/Periodic/Closing and Adjustment I select my closing record and click on Adjustment > On-Hand. I select the item and the line is created for the adjustment. The odd thing is that the Posted Quantity and Posted Value is not in sync (by far) with my Inventory Value (in every report AX offers) and Inventory onhand quantities (by check the onhand form). So I cannot adjust the onhand value because I will impact 85.000 units instead of my 5.000 physical units.
When analyzing the possible reason for this I've identified that:
- My On-hand inventory is 5.000 units (correct)
- The Posted Quantity presented is 85.000 units (incorrect)
And:
- On InventSettlement, all receipts are 100% settled with all issues (in terms of quantities)
- I have inventory transactions totaling 85.000 units in InventSettlement but with qtysettled = “” , SettleModel=Adjustment and SettleType = Complete adjustment
- I have inventory transactions totaling 80.000 units that do not have a record in InventSettlement
- I don't have any financial or physical transactions for this item since the last inventory close (removing the assumption that a user could meanwhile have closed transactions after my last IC).
So I'm thinking that if I had these last transactions in InventSettlement and I could reverse the current settlements, the complete set of open transactions would in theory settle between each other leaving open my correct 5.000 on-hand inventory. Which is the value I would expect to see when adjusting the on-hand value.
In your opinion what could be the cause for this and what's the recommended approach to resolve this?
Thank you!
*This post is locked for comments
I have the same question (0)
