Set up Attribute Value

General Information

• Attributes can be used in reporting and are assigned to accounts
• You can define up to 15 Attributes
  Attribute #1 is System Reserved for the account type

• General Ledger > Maintenance > Attributes
• Select the appropriate ID Type
• Select the Attribute from the drop down list
• Enter the Attribute Position Name (what you want to call the Attribute)
• Check the box if it is Required on the account
• Scroll to the bottom and click in the first box next to the  “*”, when you start typing, a new line will be inserted.
  • Enter the attribute Value and Description and select Active status
• Click Apply if you have more to enter or OK when finished

When adding an account, the attribute values will be available in the drop down list.

Associating an Attribute to a Dimension

• General Ledger > Maintenance > Dimensions
• Select the appropriate ID Type
• Select the Dimension value, “1-Fund”
• Click on the Edit Attribute Association button and the box will open
• Select the Attribute (1-15) that will be associated with the dimension value
  • Remember that you defined if it is required when you defined dimension
  • Note that any Attributes that are already association with a dimension value will be checked but grayed out with the dimension value in parenthesis on the right of the line.
• Click OK when finished
• Click Apply if you have more to enter or OK when finished

If you selected the attribute when you set up the dimension, then when you set up the account, the attributes will automatically be populated.

If an attribute is not required, it can either be added to the dimension or to the account.

Manual Division Backup

• It is recommended that you perform this task from the server.  In any case, you will need administrative rights on the server to perform the task.

• Log onto FundWare, Div 00
• System Administration > Division Maintenance
• Highlight the division that you want to backup
• Click the Backup button
• Message box will come up when it is finished successfully.  Click on OK.
  • The time it takes for the backup to complete will depend on the size of the database.

• Close Div 00

The backup is placed in the FundWare/Data/Backup folder.

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.