I’m trying to delete a group of Jobs and many of them have have demand links. Instead of going into Job Entry and deleting a few hundred links on a few hundred jobs, can this be done via DMT? If so, can you point me in the right direction?
Demand Links are stored in the JobProd table… if there has been no activity (labor or materials issued) you should be able to delete them in either the DMT or the application UI.
But how do you delete the demand link using DMT?
There are three checkboxes in the middle bar of the DMT program: Delete, Add New, and Update.
Create a query to find all the demand links you want to delete, use that as the data in your DMT, and just select the Delete checkbox.
THat can be done for just the links without messing with the rest of the job?
Yup. Just like you can remove the demand link through the UI without affecting the rest of the job…
I amused to adding in the fewest fields and then using the delete on the DMT. For this one, I had to add in ordernum, lines, and all the demand fields to delete. But, it did do the trick! Thank you!
For future readers of this thread, it should be noted that if there are any transactions on the job (material issues and/or labor transactions), and you need to CHANGE the demand links, you should always ADD the new demand links to the job before you DELETE the old ones. Never allow the Job Production quantity to equal or go below 0 (zero), as there could be unexpected results.