DMT Load issues with JobProd - with Resolution

Kinetic ERP
1

I just worked through an issue that wasn’t clearly documented correctly anywhere. Several legacy posts sent me down the wrong path - and I’ve just figured this out. I wanted to post the resolution of this, hoping to save others from similar frustruation.

We’re working through a go-live rehearsal, and I’m loading open jobs. We’re planning to use existing job numbers from our legacy system - so I’m loading JobHead, JobProd, JobOper, and JobMatl records. Note: In this example, all jobs are being loaded as Make to Stock.

  1. Load JobHead - with the following columns:
    Company
    Plant
    JobNum
    PartNum
    FirmJob (Constant = 1)

NOTE: IMPORTANT: DO NOT UPDATE JobPart with any quantities at this time Step 2 will peform the initial update of JobPart

  1. Load JobProd - with the following columns (IN THIS ORDER)
    Company
    Plant
    JobNum
    PartNum
    WarehouseCode
    MakeToType (Constant = STOCK) (NOT “S”, “J”, or “O”) Documentation is not clear on this.
    MakeToStockQty

  2. Update JobPart with the following fields
    Company
    Plant
    JobNum
    PartNum
    PartQty
    StockQty
    QtyCompleted
    WIPQty (PartQty - QtyCompleted)

I’ll update this post with any further issues I run across on this topic.

2

Note that JobAsmbl (Sp) table assigns sequentially. If you have multiple subassemblies, not a problem unless one was deleted, then the dataload will change your subassembly sequence - causing issues with JobMtl and JobOper.
To work around this, I looked for gaps and inserted dummy jobAsmbl records to maintain the sequence numbers when they are loaded.

Good luck it is possible to bring in jobs with DMT, I did it with 3,000 jobs and subassembly counts up to 100.

3

Hi Bruce,
Wondering if you were able to load a list of jobs that contained some make to stock, some make to order and some make to job. So far, the only success I have is loading them in separate loads. Round 1 is make to stock only, round 2 is make to order only and finally make to job.