Cost Roll Up

Epicor ERP 10
1

I’m working through my first cost rollup and have a couple of questions.

  • Do the cost changes post immediately when the “Post” process is done, or do you have to post them through the Capture COGS/WIP process?
  • Does the Costing Workbench “Group” remain after posting, and how do you get rid of it? Is it OK to delete it or can it be used in the future for the next cost roll up?

Thanks!

2
  1. When you submit the Post process, that creates all of the ADJ-CST transactions to set the new costs for the parts, and Stock Status, Part Tracker, etc. will reflect the updated cost. The costs are updated immediately, but the changes won’t hit the GL until you capture COS/WIP.
  2. We leave all of our groups as they were after posting and they’re still available. I believe you can use a previous group as a basis for a new rollup, but we’ve never tried using that before.
3

Thanks! That explains it.

4

Another costing question. We use standard costing and I did my year end roll up. The purchased parts all seemed to roll correctly. The increase per the old vs new stock status report looks reasonable. My question is why didn’t my wip values change at all? Is it because our jobs are make to order and the BOMs for the jobs don’t roll?

Thanks in advance!

5

WIP uses the cost of transactions at the time they occur. As in, whenever you issue material, apply labor, or receive subcontract parts, Epicor uses the cost of that labor or material or subcontract PO at the time of the transaction. When you ship the finished parts or receive them to inventory, they will use the new standard costs which will leave you with a manufacturing variance when you close the job.

Note that this uses the actual, physical time the transactions occur. If I were to enter a cost adjustment today (12/29) with a date of 12/1, the costs in WIP will still reflect the old costs up until I submit my cost adjustment.

1 Like
6

Thanks - that explains a lot, including some labor costs that weren’t making sense.

7

@tsmith is totally correct.
you can MANUALLY adjust the WIP value if you like but it is difficult to know how much to change it to. Reason is because the WIP is only partially complete… some material may not be issued, and some labor not charged. but if you want to adjust the cost of the job, use the job adjustment program. This could be used to account for any costs that you KNOW are wrong (for example, you have a large Billet that had a huge value change, and you want to account for that in WIP.)
BUT if you simply leave it alone, once you receive the WIP to Stock, any variance will get captured and cleared at that time.