Cost of Sales

I am new to Epicor and I need some help from the expert. :slight_smile:

I’m trying to make a BAQ that gives me the cost of sales of the part on the date it was invoiced. I need to have it CostOfSales = OrderQTY * StdTotalCost (But the StdTotalCost should be the StdTotalCost when the order was invoiced, because this StdTotalCost keeps changing every now and then we make a roll up)

Thank you so much!

You will find the cost fields on the invoicedtl table along with the sale price.
Add the 5 std cost fixed together * shipped qty.
Cost is capture on the invoice for the transaction.

1 Like

Thank you, I just did that and just validating my outputs now and it seems correct. :slight_smile:

Thanks for your help.