I’m a new user to EPICOR and am trying to get my company ready to go on to Standard Costing (currently system uses average costing). I’m trying to figure out a way to run a periodic (or via date range) report showing all the costed (earned) hours but haven’t found something I feel confident in yet. Does anyone know if there’s an out of the box solution or if you have to create a BAQ? I can validate that our system is costing jobs and applying labor all at average currently on the GL side, just looking for some operational reporting so I can use that for my basis in creating standards but want to ensure I’m grabbing the right hour figure. All I’ve found is the Resource Group Efficiency Report - is that the correct report? Also, all of our hours should be based on Labor Hours (Machine hours shouldn’t be costed as we are using our labor hours as base) and we shouldn’t have setup time included in the costing per unit (so would assume also not in the aggregate). Appreciate any help!!!
@TruCosting Welcome. make a baq with LaborDtl which has earned hours. Read in the schema on earned hours for setup and you may want to exclude setup labor.
Add that to a dashboard with from thru date and a summary and you should have what you need.
Hi Robert and welcome !
As Greg mentioned you need to do a BAQ on Labordtl to get your numbers. Be advised that your actual costs are based on hours worked x Employee hourly rate (the one you set on the employee record on the second tab).
If you want to do the calculations by your own to validate the averages vs the standard you just got yourself in trouble - this is a lot of work to be done to get the right numbers. Imagine a manufactured part which has a subassembly as material and this one has another subassembly as material plus labor of all types at all levels - this is very complicated to calculate (not impossible).
Luckily Epicor does this for you - it calculates averages and last automatically so all you have to do it to look in part tracker and see if your standard is significantly different than your average. If it is, then your standard needs an update.
