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.

Are you trying to find the cost from the oldest cost layer at the time the Sales Order was created?  The Inventory Transaction Inquiry will only show the cost from Inventory Issues.  Depending on your end goal, I would look at the Cost on the Shipment/Issue as this is the cost that will impact Inventory valuation and the GL.  The Cost on the Sales Order and Issue can be different.

Hi ​@jhalling52 - Yes, I understand the true cost will be on the issue when you ship the SO. But there is a report that we are looking at based on SO cost.

What I am trying to know is, where does the cost in SO coming from? Given the item has FIFO valuation method and FIFO Default Cost warehouse setting is Average.