Forum Discussion

Haydes's avatar
MYOB Product Team
6 years ago

How to bulk delete old jobs

If you have a large amount of old job codes that you no longer need that's causing a large list being more difficult to scroll through or even making the software a little bit slower, you can follow the steps below on how to delete all the older jobs in Bulk.


This method has been tested with AccountRight 20xx.x, AccountRight Classic (v19) and AccountEdge.


In short: We can create a new Header Job called "DELETE" and move all your old jobs as a Sub-Job of your new Header Job. This way when we delete the Header Job it will bulk-delete all the Sub-Jobs, being all your old jobs. You can export your jobs to bulk-move all your older jobs under the new Header to make it faster.


Before importing, always take a backup to be able to go back if there were any problems along the way.


1. Go to: Lists > Jobs

2. Click New and create a new Header Job called "DELETE"

3. Click OK then go to: File > Import & Export assistant

4. Choose Export Data

5. Export Jobs

6. Just click Next when asked what format you want (We want Tabs to make life easier)

7. Add all Fields to export:

8. Click Export and save the JOBS.TXT file somewhere on your computer (Like the Desktop)

9. Once exported, close the Import & Export Assistant in AccountRight and go to where you exported it

10. Open the file in Excel (Support note: Opening an export file in Excel)

11. In Excel just add the DELETE Job Number to the "Sub-job of" field on the Jobs you want to delete:

12. Save the file and close Excel.

13. Go back into AccountRight and go to: File > Import & Export assistant

14. Choose: Import Data

15. Specify Jobs to be imported and browse for the JOBS.TXT file we just saved.

16. We want to UPDATE information when importing:

17. Click Next and just click Auto-match to match your Import data to Database information

18. Click Next, take a backup & then import.

19. Once the import is complete, close the Import & Export Assistant.

20. Go to: Lists > Jobs

21. You'll find the jobs have now moved to the "DELETE" header:

22. Open the DELETE Header Job, Right Click and choose "Delete Job", this will throw this message:


Clicking OK will delete the Header & all Sub-Jobs that you wanted to delete in 1 go, this will achieve the result you want.


In order for an in-product feature for this, I recommend voting on this Idea specifically: Purge (delete) Jobs no longer in Use