In your live company, run the Data Validation Report. Are you getting any validation errors on this Work Ticket prior to using DFDM on this work ticket? If yes, then resolve the Data Validation errors in the live company. If no, then in your test company, note the data validation errors you are getting and check the Sage Knowledgebase for instructions on how to resolve the specific validation errors. The solution may have you use DFDM to resolve anyway.

Hey ksmcwhir _

Thanks for the assistance!

I did run the Data Validation Report in the live company and there are some errors, but from another product, not the SO or WT in question. The only time I see any errors (109 and 404) are after I have used DFDM to delete the WT and its steps in the backup company. That produces errors in the Data Validation Report, I presume, because there are still transactions that are active that no longer have a SO or WT to reference.

For those orphaned transactions, I just deleted them using DFDM from the JT_Transaction table. After doing that and running the Data Validation Report again, all errors related to the offending WT are gone. Does that sound like a cogent plan for fixing my dilemma? I checked the Sage Knoweldgebase, but I didn't find a clear means of troubleshooting my specific problem. What I did was part what I've learned from some Sage "sages," and my own (hopefully) decent logic.

Data Validation Error 109 solution is to Check the record type in JT_Transaction. If only “ST” type records exists, then remove the records from JT_Transaction. (this is what you did)

Data Validation Error 404 occurs because A record exists in JT_Transaction without a corresponding SO_SalesOrderDetail line.  Generally, you Manually re-create the SO_SalesOrderDetail line for the existing JT_Transaction record.  But, in your case the Sales Order was linked to a different WT so I think you are OK deleting the JT_Transaction record.

FYI, the Operations Management Technical Reference Guide that provides Data Validation Error solutions can be downloaded from the JobOps knowledgebase (https://portal.jobops.com/download2021) under the Downloads tab, Version 2021 download, Technical Reference Guide.

Data Validation Error 109 solution is to check the record type in JT_Transaction. If only “ST” type records
exists, then remove the records from JT_Transaction.

Data Validation Error 404 occurs because a record exists in JT_Transaction without a corresponding
SO_SalesOrderDetail line.  Normally, you would recreate the SO_SalesOrderDetail line but in your case I think deleting the JT_Transaction records are OK. 

FYI, the Operations Management Technical Reference Guide can be downloaded from the JobOps portal under the version 2021 download at portal.jobops.com/download2021

ksmcwhir 

Wow! Thank you for that exceptional explanation! I like recreating the SO_SalesOrderDetail line for SO that only have the one WT. That  tackles the issue in a non-destructive manner.

And thanks for the link to the JobOps knowledgebase! That will come in very handy!

Have a wonderful day!

Glad the information will be useful!  My User error for the duplicate prior response! Oops!