Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleHow 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). 

**If you inactivate a cash account it will make all underlying accounts, approp, budget, and revenues inactive too. 


Expand
titleCan I mass add accounts?

Yes. 

The Mass Add Feature allows you to copy all Appropriation, Expenditure and Revenue Accounts in a Cash Account, to a new Special Cost Center within that same Fund.  

1. Go to Core/Accounts and view the Cash account you want to copy.

​2. ​​Click on “Mass Add”


3. ​A box will pop up where you can enter your new SCC for ​the​ particular fund​ and click on Submit.​

​4 ​​. Once you submitted you will get a message showing all the accounts that were created.​

  

...