Editing the Chart of Accounts

Allocation - Editing the Chart of Accounts

The Chart of Accounts lets you custom map a GL Number to a transaction based on the criteria you establish in Allocation Setup, if you use GL Main Account custom mapping. In Allocation Setup, you have the option of choosing any or all of the following four criteria fields in priority order:

MCC
Customer code
Employee ID
Cost center

Once you've decided to use custom mapping in Allocation setup, you must then edit the Chart of Accounts to manually assign Main GL Numbers to the fields you've selected. If you are setting up Allocation for the first time, iTracer takes you directly to the Edit Chart of Accounts function. If you are changing your Allocation setup, you must manually select Edit Chart of Accounts from the Allocation Function drop down box.

The Edit Chart of Accounts function contains all fields you've selected in the Allocation setup. Use the Field drop down box to edit a specific setup criteria field.

When editing the Chart of Accounts for the first time, all Main GL Number fields are blank. You can assign Main GL Numbers to any or all of the criteria fields in the Chart of Accounts. Just type the Main GL Number in the GL Main Number box and click Update to save your entries.

If you use the same Main GL Number for a range of consecutive values, you can update the Chart of Accounts using a range.

Select Update Chart of Accounts using a range from the Function drop down box.

Select the Field that you want to update. Only those fields that you selected in your Allocation setup, where you chose custom mapping, are available. Enter the beginning Field value in the From box and the ending Field value in the To box. Type the Main GL Number for the range of values entered in the GL Main Number box. Click Submit.

All Field values will be assigned that Main GL Number if no other value had already been assigned to that Field value.

After you've finished editing the Chart of Accounts, be sure to select Assign Main G/L Number to Transactions from the Allocation Function drop down menu. This ensures that your edits are applied to the transactions in the interface extract file.