Forum Discussion

Drawlinson's avatar
Drawlinson
Experienced Cover User
7 years ago

Bulk Editing Jobs Active/Inactive

Hello Community, I am looking at the Jobs List in AccountEdge NE v17 and need to make about 2000 jobs inactive (trying to tidy up) at the moment i can only do this one job at a time, so its going to ...
  • Mike_James's avatar
    Mike_James
    7 years ago

    Hi Drawlinson, you should be able to do this by exporting the jobs list to a file, open it in Excel, add a "Y" to the "InactiveJob" field as required, save as a new text file then import the file back to AccountEdge with the option to update the list. 

     

    As with all imports, make a backup before you begin.

     

    When exporting, choose Match all to select all fields. When importing select only the job number and the IsInactive column.

     

    Go to File, Export data, and follow the options there to begin.

Mike_James's avatar
Mike_James
Ultimate Cover User

Hi Drawlinson, you should be able to do this by exporting the jobs list to a file, open it in Excel, add a "Y" to the "InactiveJob" field as required, save as a new text file then import the file back to AccountEdge with the option to update the list. 

 

As with all imports, make a backup before you begin.

 

When exporting, choose Match all to select all fields. When importing select only the job number and the IsInactive column.

 

Go to File, Export data, and follow the options there to begin.

Drawlinson's avatar
Drawlinson
Experienced Cover User
7 years ago

Thanks Heaps for the quick reply Mike simply done and worked perfectly :-)

 

Cheers

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.