Inserting Current Operations and Materials (BOM) via REST API

c-zuniga

I’ve been able to insert Items successfully via REST (SLItems) (CostType/CostMethod Standard/Standard) (no revision/not revision tracked) (type material/source manufactured) (production type job) (attributes/costing/vendor contracts added beforehand (does the order matter here?)) . Now I’m working on inserting Jobs, Operations, Materials, and Resource Groups. From what I can tell, the right IDOs to hit are:

SLJobs – create the job header

SLJobRoutes – add operations to the job

SLJobmatls – add material lines (BOM for that job)

SLJrtResourceGroups – assign resources to each operation

Workflow / Order of Insertion

1. Create the Job (SLJobs)
   1. Required: Job, JobType, Suffix (for current BOM), Whse, OrdType.
   2. {"Job": " 11135","JobType": "S", "Suffix": 0,"Whse": "MAIN","OrdType": "I", "Item": "INK-RED"}
   3. Note: I use "?" to find the newest generated Job, but I have even tried manual selection from the Jobs table using
      1. Filter: "Job NOT LIKE '%[^0-9 ]%' AND Job LIKE '%[0-9]%' AND Type='S'"
      2. OrderBy: "Job DESC"
2. Insert Job Operation(s) (SLJobRoutes)
   1. Required: Job, Suffix, OperNum, Wc.
   2. {"Job": " 11135","Suffix": 0,"OperNum": 10,"Wc": "RM80"}
3. Attach Resource Group(s) (SLJrtResourceGroups)
   1. Required for each operation to define capacity/resources.
   2. Must reference the same Job, Suffix, OperNum.
   3. {"Job": " 11135","Suffix": 0,"OperNum": 10,"ResourceGroup": "LABOR1"}
4. Insert Job Materials (BOM) (SLJobmatls)
   1. Required: Job, Suffix, OperNum, Sequence, Item, QtyPer, UM, MatlType.
   2. {"Job": " 11135","Suffix": 0,"OperNum": 10,"Sequence": 10,"Item": "INK-RED","QtyPer": 0.25,"UM": "LT", "MatlType": "M"}

After doing all these steps, when I open Current Operations in the client, there is no operation inserted — it looks like the WC/operation isn’t found. This is despite recieving 200/OK responses from the API.

Is there another field/link I need to populate in SLJobRoutes or SLJrtResourceGroups so that the operation shows up properly in Current Operations?

Follow up edit/personal notes:
Does ItwhJob/ItwhSuffix on SLItemWhses need to be updated?
Or could there be a mismatch on ScheduleDriver with WcSchedDriver/JshSchedDrv?
JshSetuprgid/JshSetuprule on SLJobRoutes

c-zuniga

SOLUTION:
I was forgetting to update ItwhJob/ItwhSuffix on SLItemWhses to the newly inserted Job.