Forum Discussion

dbkbuild's avatar
dbkbuild
5 years ago

Bulk Updating Jobs List

Hi all, 

 

I'm trying to work out a way to bulk update our Jobs List. Basically, I'd like to update multiple jobs to inactive in one fell swoop!

 

Thanks in advance. 

  • JediMasterAndy's avatar
    JediMasterAndy
    5 years ago

    Export the jobs (File>Import/Export)


    Edit the IsActive (or similar) column in excel to mark as then inactive, then reimport over the top updating existing records.  Dont tick anything else on the import screen other than the job number and the IsActive field, that should do it..

  • JediMasterAndy's avatar
    JediMasterAndy
    MYOB Staff
    5 years ago

    Export the jobs (File>Import/Export)


    Edit the IsActive (or similar) column in excel to mark as then inactive, then reimport over the top updating existing records.  Dont tick anything else on the import screen other than the job number and the IsActive field, that should do it..

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.