We are using "Weighted avg. date" as the Inventory model with
Include physical value = YES
Financial negative inventory = YES
We did the Inventory Closing up to 30-Nov-2016. We found a strange value in the Cost amount column on 25-Jan-15 (highlighted in RED).
For the particular line with Qty as 10,666.00 the Physical cost is only
whereas the Cost amount is too high
I would like to know the reason why cost amount is too high. Because of this reason the Item cost price is totally wrong.
Please find attached Excel sheet.
Expect the best, plan for the worst and prepare to be surprised