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.