Job Operation Detail - Delete via DMT

Kinetic ERP
1

We have DMT version 11.2.200.16 some things have changed with being able to delete extra operation details. I figured out ECO / PartOpDtl. Can’t figure out JobOpDtl.

ECO: PartOper / PartOpDtl - SUCCESS

  • Make sure to include the EcoOpDtl#RowMod with value “D” for Delete.
  • Make sure to include the EcoOpDtl#IsPartOpDtl with value TRUE
  • Run the import in DELETE mode.

Jobs: JobOper / JopOpDtl - FAIL

  • Included JobOpDtl#RowMod = “D”; JobOpDtl#IsJobOpDtl, error JobOpDtl invalid field
  • Included JobOpDtl#RowMod = “D”; JobOpDtl#IsPartOpDtl, error PartOpDtl invalid field
  • Included JobOpDtl#RowMod = “D”, ran as update - no change
  • Included JobOpDtl#RowMod = “D”, ran as delete - delete entire op if there wasn’t material attached to cause an error.

I am running these in test and only for 1 method / job to get it working before I fix live.

Has anyone been able to successfully delete a 2nd job operation detail with Kinetic DMTs recently?

Appreciate any direction - have several thousands of records to fix. At least the methods are fixed in live so I shouldn’t get any more jobs that need fixing.

Thanks!
Jenn

2

Jenn did you ever figure out how to delete the JobOpDtl record? I’m having the same requirements and have been unsuccessful so far.

3

Sorry - my memory is failing. I don’t remember if we did get it fixed…