Updating multiple subsidiaries tagged on Chart of Accounts records can be a time-consuming task, especially when dealing with numerous accounts. However, by utilizing a CSV file and the import feature, you can streamline this process and save valuable time. Here's a step-by-step guide to help you update multiple subsidiaries efficiently:
Step 1: Check Subsidiary Internal IDs
- Before proceeding, ensure you have the correct Internal IDs for the subsidiaries.
- Navigate to Home > Set Preference > General.
- Enable the 'Show Internal IDs' option to display the IDs alongside the subsidiary names.
- Navigate to Setup > Company > Subsidiaries to verify the Internal IDs.
Step 2: Create a CSV File
- Create a new CSV File
- Set up two columns in the spreadsheet: 'Account' and 'Subsidiary'.
- In the 'Account' column, enter the Internal ID of each account you want to update.
- In the 'Subsidiary' column, list the Internal IDs of the subsidiaries associated with each account. If an account has multiple subsidiaries, use the pipe character "|" to separate the IDs (e.g., 12345|67890).
Step 3: Import the CSV File
- Navigate to Setup > Import/Export > Import CSV Records.
- Set the Import Type to 'Accounting' and the Record Type to 'Chart of Accounts'.
- Click on 'Choose File' and select the CSV file you created on Step 1. Then, click Next.
- Select 'Update' as the Data Handling option to update the existing records.
- Under Advanced Options, ensure you choose the correct custom form if applicable, and click Next.
Step 4: Map the Fields
- Map the columns in your CSV file to the corresponding fields in the Chart of Accounts.
- Map the 'Account' column to 'Account : Internal ID'.
- Map the 'Subsidiary' column to 'Account : Subsidiaries (Req)'.
- Click on the pencil icon next to 'Account' and 'Subsidiary' to open the Reference Type options.
- Select 'Internal ID' as the Reference Type for both fields.
- Click 'Next' to proceed.
Step 5: Save and Run the Import
- Enter a name for the Import Map to easily identify it in the future.
- Click 'Save & Run' to initiate the import process.
By following these steps, you can efficiently update multiple subsidiaries tagged on Chart of Accounts records, ensuring accurate and consistent data across your accounting system. Remember to double-check the Internal IDs and map the fields correctly for a seamless import experience.