Jobs: Purge (delete) Jobs no longer in Use

Hi LinCon 

Thank you for your comments and providing the workaround that you have used to delete your unwanted jobs.

If I can just add something to that process. You can improve the deletion time by going into the Job, so you have the Edit Job window open then right clicking on some grey space and selecting Delete Job. This may improve the process for those clients that are using the Edit>>Delete Job option.

I managed to do it by following the following steps ... make sure you back up your MYOB file FIRST in case this slips for you. Also, make sure everybody else is logged out:

Step 1: create a new header job call "tobedeleted"

Step 2: create a dummy detail job "deletetest" under header "tobe deleted"

Step 3: export jobs, match all columns

Step 4: using excel, open your exported file, switch on filter, then filter to isolate all the jobs you would like to delete.

Step 5: change the header job for all these jobs you want to delete to "tobedeleted"

Step 6: mark all these jobs to inactive, and 100% complete.

Step 6: save the file as a tab delimited file

Step 7: go back to MYOB, import jobs, make sure you select "update existing record" in the duplicate records section.

Step 8: Select the file you edited and match all. (Should match identically since you are using the same format as the exported file)

Step 9: complete the import

Step 10: go into your lists, jobs and you should see all the jobs you wanted to delete sitting under the header "tobedeleted"

Step 11: Delete the header job "tobedeleted"

Step 12: it will warn you a few times, select ok all the way through and now you have deleted the detail jobs under that header.

Sorry for long descript, this should have you smiling again.

I noted that the last update still hasn't dealt with batch deleting of jobs. We have tried the above suggestion of exporting the data to excel, deleting the jobs and then importing the data again but this didn't work. When the data was re-imported, MYOB used all the numbers in a four digit format where as our numbering system uses 5 digit format with the first digit being a zero. The end result was we finished with twice the number of jobs as when we started!!

Surely it can't be that hard to have a check box in the jobs list to allow the user to delete or make inactive multiple files in one go. Even to have the ability to use the shift / ctrl buttons in conjunction with teh mouse to highlight multiple jobs at the same time such as used in all other windows based programs. Then right click and go delete