Update Subsidiaries Selected in the GL Accounts via CSV Import

User updates the Subsidiaries selected in the GL Accounts via CSV Import.

1. Create a CSV file with just 2 columns:

Account: Internal ID of the Account
Subsidiary: Internal IDs of Subsidiaries
Notes: If all subsidiaries need to be selected, use internal ID of the parent and add Include Children column and enter Yes.

If multiple subsidiary, please use a pipe ‘|’ to separate the Internal IDs, i.e. 13|15|9. No spaces in between pipes and numbers.

2. Navigate to Setup > Import/Export > Import CSV Records
3. Import Type: Select Accounting
4. Record Type: Select Chart of Accounts
5. Click Select to upload the file
6. Click Next
7. Data Handling: Select Update
8. Click Advanced Options
9. Custom Form: Select applicable Custom Form
10. Click Next
11. Field Mapping: Account | Account : Internal ID
    Subsidiary | Account : Subsidiaries (Req)
    Include Children | Account : Include Children
12. Click the pencil icon beside Subsidiary
13. Choose Reference Type: Select Internal ID
14. Click Done
15. Click Next
16. Import Map Name: Enter desired Name
17. Click Save & Run