How to bulk delete old jobs

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Haydes
MYOB Product Team
6,317 Posts
MYOB Product Team
Australia
MYOB Product Team

6,317Posts

1,108Kudos

903Solutions

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"

temp.png

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:

temp.png

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:

temp.png

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:

temp.png

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

temp.png

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:

temp.png

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

temp.png

 

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


Cheers,
Hayden
MYOB Product Team

Currently Working On:
Supplier Feeds | E-invoicing
In Tray
Previously Worked On:
MYOB Capture App | MYOB Invoices app
MYOB Support (2015-2019)


Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post