Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

How do I mass inactivate accounts?

You will want to go to the Utilities menu and select "Mass Load".  You will have to load different spreadsheets (cash, expenditure and revenue are the options) as they can NOT be combined on one.  In order to create the spreadsheet to use to load into Mass Load, start at the Account grid and filter for the accounts you want to make inactive, make sure all account dimensions are on your grid and you have the active column on your grid as well and then click on the report button and choosing the output format Excel-fieldnames. This will create a spreadsheet with the appropriate headers for the Mass Load program to work.  Remove all columns except the account dimensions and active status. You will then add/remove accounts as needed, change the active column to be false and save it as a CSV file. Once the CSV file is created/saved you will go to Utilities/Mass Load, upload your spreadsheet and choose the importable entity (cash, expenditure, revenue). 

  • No labels