Importing Associations Between Your GL Accounts and Referential Accounts

Instead of manually associating each GL account to a referential account, you can import the associations from a spreadsheet. You must set up the spreadsheet with columns for each of the fields on the Multiple Add Referential Accounts by Account form in the order in which the fields appear on the form. The fields are:

1. Business Unit

2. Object Account

3. Subsidiary

4. Chart of Account Responsible

   The system validates the value for this field against the values in the Chart of accounts Responsible (76B/RA) UDC table when you import the values, so the value in your spreadsheet must exist in the UDC table.

5. Referential Account