I am running AX2009SP1.
All items used “Weight ave date” costing method, Not allow physical negative, allow financial negative.
In several month the inventory closing keeps saying problem in item settlement, and result may not be correct.
When I run stock value by item dimension report, I can find item that
Zero Qty but Positive value
Zero Qty but Negative value
I pick 1 item (having zero qty but Positive value) and check the inventory transactions. All transactions are either Purchased or Sold. (Financially completed)
If I add up the Quantity, it is zero.
If I add up the cost amount, it is Positive value.
I find some transactions are still Open value (Not 100% settled). Settled Quantity is less than Quantity.
So any reason for this item settlement problem?
And any solution to Fix my existing data?
Thanks in advance.