Hey all, at the end of my rope here as we are being audited and cannot explain a material cost for a part transaction. I have combed through the several articles on average costing, and I still cannot piece together why our system is acting the way it is. I am looking at all part transactions for a part ordered by TranNum, and trying to calculate what the Average should have been at a moment in time.
This is what I have found from other articles of how it seems the Material average is a calculated at the time of change:
I pulled in all transactions from the beginning of time and started to work up from the first transaction working towards the most recent calculating the running total, and the average at the certain point in time. Not too far in I cannot figure out how Epicor calculated the average. What am I missing?
Thank you all for your help.