DMT Inventory - Work Orders

Kinetic ERP
1

Good afternoon,

We are in the process on migrating from JD Ewards to Epicor Kinetic and has been a nightmare been able to DMT Inventory and Open Work orders between the two systems. Does anyone can assist and put a light on tunnel on what steps to do it right? Thank you

2

OOoooh Boy. You ready?

DMT’s Inventory is pretty straight forward. You’ll do this with the Quantity Adjustment DMT.

What is your costing method? For us, we were FIFO. So this was a 2-step process. We had to do a Qty Adjustment DMT first, then a Cost Adjustment DMT against the FIFO Layers created in the first DMT.

Qty Adjustment DMT: Fields were Company, PartNum, WareHseCode, BinNum, AdjustQuantity, ReasonCode, Plant… also LotNum if you’re using those.

Our Cost Adjustment DMT included:
Company, PartNum, ReasonCode, FIFODate, FIFOMaterialCost, FIFOMtlBurCost (if you want to apply material burden), FIFOSeq, Plant.

~~ * ~~

DMTing WIP is a BIG ONE! There’s a lot that has to be in place in the right order. Below was the order of DMT’s we did for WIP (I won’t detail each).

  1. Sales Order Head
  2. Sales Order Detail
  3. Job Head (NonStock) - setting Engineered & Released flags to false
  4. Job Prod (NonStock) - Links the Sales Order and Corresponding Job
  5. Job Assembly (NonStock)
  6. Job Materials (NonStock)
  7. Job Operations (NonStock) - This is all the required job operations.
  8. Job Operations (NonStock - Cutover) - This appended a “cut-over” operation to each job assembly 0 where we later applied all our existing WIP cost at cut-over.
  9. Job Head (NonStock) - running this one again, but this time with Engineering & released flags set to True.
  10. Job Labor Adjustment - This applied existing WIP cost from our legacy system onto the job in Epicor (we totaled all cost and just ported it over as a one time labor cost instead of trying to split it into each individual cost bucket).

We then ran all of those same DMTs AGAIN… but for Stock Jobs (because they weren’t tied to Sales Orders, and some of the DMT fields were different).

4 Likes
3

If you can…try to get a clean cutoff on your manufacturing so you’ve got less DMTing to do. I know it sounds idealistic but we were able to do it. Our manufacturing’s pretty simple…1-2 ops, 5-6 components, job runtimes usually in hours and not days…make-to-order and make-to-stock. We ran out all active jobs out on the old system and then started creating/releasing new jobs on Kinetic.

4 Likes
4

@dcamlin Thank you . We are using Standard cost

5

David,

If we are using standard cost, We have already DMT BOM… I’m assuming is Quantity Adjustment DMT and Roll up Cost for the inventory parts… and follow the steps for the WIP?

6

Yeah wow I cannot imagine the WIP portion. I was here for the cutover 8 years ago, but as I recall, we just didn’t move WIP. We finished out the WIP in the old system and they must have had a blast merging the books that first month.

1 Like