Hi,
We were trying to verify the customised Stock Status report with a defaultStock Report and have realised that the unit cost of a few items are different. We have used the PartCost table for the unit cost in the customised Stock Report. For example, the Part cost of an item is 21.84107 in PartCost table but in the Stock Status report it is 36.23. This is causing a lot of difference in the report. Can you please help us understand where does the Stock Report take the UnitCost from?
You confirmed that in the database? Also, Is your part cost calculation taking into account the 5 costing fields? Can’t remember them all off the top of my head. MatCost, Burden, SubCon, and then two others
Yes, we are using FIFO. Our UnitCost is Calculated as below:
FIFOAvgBurdenCost + FIFOAvgLaborCost + FIFOAvgMaterialCost + FIFOAvgMtlBurCost + FIFOAvgSubContCost
Okay good. Have you checked part transaction history tracker to look for any rogue transactions throwing it off? I’ve found acouple other threads on the forum of people having problems. Might have to IlSpy the report dll to try and see what that field is doing behind the scenes
IlSpy is a tool you can use to decompile DLLs. It’s free to download. I think there is a report dll in the client folder you might be able to un pack and see how your field is calculated
Thank you.
I downloaded the software. There are many report dll files in the folder. Can you please mention which one should I inspect? Is it the CrystalDecisions.ReportSource.dll ?
FIFO uses weighted average to calculate the avg cost of the part
the cost you see in Part Tracker or PartCost table is the cost as it is NOW
the cost you see in Stock Status report was the cost at the TIME OF TRANSACTION
when you consume/use/sale/etc. the part, Epicor will use the FIFO layers in the same order as they were added (hence FIFO - first in first out)
all of the above will lead to differences between Stock Status and Part Cost/Tracker if you manufacture/buy the part at different prices and those FIFO layers with different prices are used when you sale/consume the part