Calculation equation to derive Part average cost which should match with Stock status report

Epicor ERP 10
1

Dear All,

I am trying to get part average cost on the basis of each transaction which I want to reconcile with stock status average cost report, but I could not be able to understand why, I could not be able to match it.

I tried to get this through this equation but that is not being matched.
Sum(PartTran.ExtCost) OVER (PARTITION BY PartTran.PartNum , PartTran.WareHouseCode ORDER BY PartTran.TranNum)

It would be good if anyone help on this is…

2

Epicor uses a weighted average to calculate average cost.

(Prev. Quantity x Prev.Unit Cost) + (Quantity Received x Receipt Unit Cost) / New Quantity On Hand

1 Like
3

Thank you @hackaphreaka for your valuable reply , I want this in Parttran format . This would be good if you can help me

1 Like