Account Utilities

General Ledger > Accounts > Account Utilities

• You can also link to this function from the Chart of Accounts screen.

1 – Duplicate Accounts

• Allows you to create a new set of accounts using an existing set of accounts as the source (or “model”).  You can select the source accounts using an account mask, status, or attributes (included or excluded).
• All new dimension values must be set up before using the Duplicate function.

 The example below will duplicate all the accounts in Fund 01, Dept 01-00 that are active to a new Dept 05-00.  The account mask must be in the same position for the Source and Create account mask.

• General Ledger > Accounts > Account Utilities
• Source
  • Account Mask – use X’s for wild card.  This is the highest level of filter to create your source group of accounts.  The Source is what you are duplicating from.  Enter the ID and account numbers you want to duplicate and then you can tab to fill in the X’s.
  • Status – set to the status you want to copy from (most likely Active or Descriptive but you can leave it blank)
  • Include – if you only want to copy accounts with a certain attribute, you can add them here.  (i.e. 1 – you might select AS for just Asset Accounts)
  • Exclude – if you don’t want to copy accounts with a certain attribute, you can add them here.  (i.e. 1 – you might enter FB if you want to add all the accounts except Fund Balance accounts)
• Create
  • Account Mask – the Account Mask that you enter in this text box defines the new accounts (created as a result of the account duplication).  Any wild cards (X’s) must occupy the same position as the Source Account.  Enter the ID and account numbers you want to duplicate and then you can tab to fill in the X’s.
  • Duplicate Data Items on new accounts – select this check box if you want the new accounts to have the same data items and values as the source account group.  If you are not using Data Items on accounts, it is not applicable.
  • Set Status – if you select a Status, that status will be applied to all the new accounts regardless of the status of each source account.  If you do not select a status, each account will retain the status of its individual source account.
  • Set Attributes – any entry here will override the attribute setting of the source accounts. 
    • Tip:  to set an attribute as “blank”, select “**” from the drop down list in the appropriate text box.
  • Required ID Type(s) – if you are using more than one ID type, enter one or more ID types that must be entered when a transaction is posted to the new account.  Leave blank if it doesn’t apply.
  • One of Required ID Type(s) – this field lets you list one or more ID types to require depending on the data to be entered when using the account in a transaction task.  Leave blank if it doesn’t apply.
  • Print Options – select the appropriate one

• Click OK or Apply (will leave the screen open so you can make changes for the next duplication).

• The report CSIDUPS.L## will be generated.