Part Cost - Lot Costing

Morning all,

I’m looking for some advice on the best practice to get the unit cost of a part at the point of shipment. I’m still a bit novice when it comes to finance and costing, so apologies in advance if this is a basic question.

Our setup is lot costing rather than standard costing, so the StdPartCost fields are empty. We already have the cost of goods from the InvcDtl table in our BAQ. Is there an way to get the actual unit cost at point of shipment? Could this be pullled from the OrderDtl table instead, or from another transaction/table that captures the lot cost used at shipment time?

I really appreciate the guidance. Thanks in advance!

PartTran.

1 Like

Thank you! Is it for a specific transaction type? Like STK-SHP

There is a help article that lists all the transaction types - you are probably better off looking at that to make sure you look all the relevant transactions. There are shipments form stock, direct shipments, kit shipments, etc.

2 Likes

Thank you for your help. Would this be the ExtCost? I started with SUM(PartTran.ExtCost) / NULLIF(SUM(PartTran.TranQty),0)

but the results aren’t close to the unit cost in OrderDtl tables

1 Like