Incorrect Unit Cost in Sales Order

Hello ​@MarkD ,

Maybe you can check the Historical Valuation report/Inventory Transaction Details.

Thanks

Thanks, ​@YasasWithanage76 - not there either. I’ve checked all other relevant report that makes sense, but can’t find that cost. Anything else I can check?

Hello ​@MarkD May be that 0.4568 is coming from an old PO Receipt layer created before the Sales Order shipment.

You can check in Inventory Allocation Details.

Hi ​@MarkD, what is the FIFO Default Cost setting defined as for the Warehouse on the Sales Order?  The Unit Cost could be the Avg Cost of what was in the Warehouse at the time of SO creation.  The true Cost won’t be calculated until the Inventory Issue is created. 

Thanks ​@jhalling52 - It is ‘Average’. So is there a way to identify the cost if the item at that time in any of the reports? I know it was averaged at that time, but should I think it should be recorded in inventory transaction history at least.