Field COST in CustomerOrderLines. Where does it comes from?

Add on:
Because in this case we have no ShipmentLines the whole process of fetching detailed costs fails and the contribution margin is way to high because of missing costs.

Hi Link,

I think, that makes totally sense.

This value is an average of all items available at the moment.

I checked it:
As you can see, the values in the DataWareHouse match perfectly with the inventory value (for one piece)
 

More details:
Inventory_Part_Unit_Cost_API.Get_Inventory_Value_By_Method(CONTRACT,PART_NO,CONFIGURATION_ID,LOT_BATCH_NO,SERIAL_NO)

This API fetch the value:

It comes down to:
 

I can remember that we tried to get cost data from this source.

But the problem is: The moment the Lotbatch is finished, the inventory value - for this lot - will disapear. That was the reason we switched to ITH.

Thanks Link for helping me get things sorted out.

CU

Michael

@Michael Kaiser unit cost calculation in IFS is quite complex and it depends on the Inventory Part COst Level setup.

For ex, if Cost Per Part is used → just one entry in INVENTORY_PART_UNIT_COST_TAB

                                                       → entry in INVENTORY_PART_UNIT_COST_TAB will never be deleted, but the value will be updated every time the cost controllers run cost calculation (Copy Costs to Cost Set 1)

If Cost per Lot Batch → each lot batch once it’s produced via Shop Order will have it’s own cost (depending on the materials used / work center cost of the Shop order)

                                     → when there’s no more qty_onhand from that lot-batch ( for ex after the OESHIP transaction of the last pieces of the lot-batch) the lot-batch entry in INVENTORY_PART_UNIT_COST_TAB is deleted

Due to this complexity, it’s advisable to use the cost from the Invetory_Transaction_History_Tab for each individual transaction.