Sage 100

Did you run the OM-Reports-Data Validation report? And do those WT's appear with an error 102 & 105? If so you can try this MOVEWT Utility.

go to File Run command. Type in SYZCON then select OK. In the command prompt type: RUN "..\JT\MOVEWT

This utility is run for a single work ticket when the sales order for the work ticket is no longer in the open files and work ticket records are "orphaned" in the open files. The utility will move all Sage Operations Management/JobOps data records for a given work ticket from the open files to the history files provided a valid invoice in history can be located that references the sales order and work ticket number. If there are multiple invoices for the sales order and work ticket, the utility will look to match up to the most recent invoice

Did you run the OM-Reports-Data Validation report? And do those WT's appear with an error 102 & 105? If so you can try this MOVEWT Utility.

go to File Run command. Type in SYZCON then select OK. In the command prompt type: RUN "..\JT\MOVEWT

This utility is run for a single work ticket when the sales order for the work ticket is no longer in the open files and work ticket records are "orphaned" in the open files. The utility will move all Sage Operations Management/JobOps data records for a given work ticket from the open files to the history files provided a valid invoice in history can be located that references the sales order and work ticket number. If there are multiple invoices for the sales order and work ticket, the utility will look to match up to the most recent invoice

Rats, @Lisa Dion - not what I was hoping for.  I've never worked with this client before, but I can see that there are a BUNCH of old WT and clicking on the first 5 all gave me the same error.

The one that they had contacted me about was a more recent order, and the sales order had somehow lost line 1 (which had the WT item) and looked like there were no lines if you opened it in SO Entry.  If you went into the SO_SalesOrderDetail lines 2-28 were there, but for some reason without line 1 none of them would display.  Rebuilding files didn't help.

So you couldn't delete that SO normally because it said there was a WT attached, but you couldn't delete the WT because "The SO is in use".  They said this happens every now and then.

In this case, there is no invoice for the SO.  Do you know what the utility would do in that situation? (Assuming anyone has the patience to start running it for the many stranded WTs)

Did you run the OM-Reports-Data Validation report? And do those WT's appear with an error 102 & 105? If so you can try this MOVEWT Utility.

go to File Run command. Type in SYZCON then select OK. In the command prompt type: RUN "..\JT\MOVEWT

This utility is run for a single work ticket when the sales order for the work ticket is no longer in the open files and work ticket records are "orphaned" in the open files. The utility will move all Sage Operations Management/JobOps data records for a given work ticket from the open files to the history files provided a valid invoice in history can be located that references the sales order and work ticket number. If there are multiple invoices for the sales order and work ticket, the utility will look to match up to the most recent invoice

The attached PDF is for v2021 but it providesc guidance for the MOVEWT utility and for resolving data validation errors.

Rats, @Lisa Dion - not what I was hoping for.  I've never worked with this client before, but I can see that there are a BUNCH of old WT and clicking on the first 5 all gave me the same error.

The one that they had contacted me about was a more recent order, and the sales order had somehow lost line 1 (which had the WT item) and looked like there were no lines if you opened it in SO Entry.  If you went into the SO_SalesOrderDetail lines 2-28 were there, but for some reason without line 1 none of them would display.  Rebuilding files didn't help.

So you couldn't delete that SO normally because it said there was a WT attached, but you couldn't delete the WT because "The SO is in use".  They said this happens every now and then.

In this case, there is no invoice for the SO.  Do you know what the utility would do in that situation? (Assuming anyone has the patience to start running it for the many stranded WTs)

Did you run the OM-Reports-Data Validation report? And do those WT's appear with an error 102 & 105? If so you can try this MOVEWT Utility.

go to File Run command. Type in SYZCON then select OK. In the command prompt type: RUN "..\JT\MOVEWT

This utility is run for a single work ticket when the sales order for the work ticket is no longer in the open files and work ticket records are "orphaned" in the open files. The utility will move all Sage Operations Management/JobOps data records for a given work ticket from the open files to the history files provided a valid invoice in history can be located that references the sales order and work ticket number. If there are multiple invoices for the sales order and work ticket, the utility will look to match up to the most recent invoice

Thank you - I'll add it to my weekend light reading!

The attached PDF is for v2021 but it providesc guidance for the MOVEWT utility and for resolving data validation errors.

Rats, @Lisa Dion - not what I was hoping for.  I've never worked with this client before, but I can see that there are a BUNCH of old WT and clicking on the first 5 all gave me the same error.

The one that they had contacted me about was a more recent order, and the sales order had somehow lost line 1 (which had the WT item) and looked like there were no lines if you opened it in SO Entry.  If you went into the SO_SalesOrderDetail lines 2-28 were there, but for some reason without line 1 none of them would display.  Rebuilding files didn't help.

So you couldn't delete that SO normally because it said there was a WT attached, but you couldn't delete the WT because "The SO is in use".  They said this happens every now and then.

In this case, there is no invoice for the SO.  Do you know what the utility would do in that situation? (Assuming anyone has the patience to start running it for the many stranded WTs)

Did you run the OM-Reports-Data Validation report? And do those WT's appear with an error 102 & 105? If so you can try this MOVEWT Utility.

go to File Run command. Type in SYZCON then select OK. In the command prompt type: RUN "..\JT\MOVEWT

This utility is run for a single work ticket when the sales order for the work ticket is no longer in the open files and work ticket records are "orphaned" in the open files. The utility will move all Sage Operations Management/JobOps data records for a given work ticket from the open files to the history files provided a valid invoice in history can be located that references the sales order and work ticket number. If there are multiple invoices for the sales order and work ticket, the utility will look to match up to the most recent invoice