Page History

...

Data Import using Import Wizard

1. GL Account
2. Item List

Data Import using Data Loader (use when Hierarchy import is needed)

1. Importing GL Account using Data Loader
   1. Item List

    

   After adding your GL Accounts (Chart of Accounts), you might want to add hierarchy or the parent-child relationship to the accounts. For that you will need to export the GL Accounts data to the CSV file and identify the SalesForce ID. The second step is to identify the SalesForce IDs of the Parent accounts to map those to the Child accounts. Insert Parent Account IDs next to the Child Account Names in the CSV file by V-lookup operation. Once you have the IDs of the Parent Accounts in CSV, you can perform the update operations on GL Accounts and map those respective parent accounts using Data Loader.

   1. 1. Add all Parent GL Accounts
      2. Export all GL Accounts with Parent Salesforce Ids.
      3. Update your CSV import files and add a column "ParentAccountId". Update the ParentAccountId field with the related Ids. In Excel, you can use VLOOKUP to relate parent accounts.
      4. Use data loader to upsert all records, make sure you have added the ParentAccountId to point to the Parent GL Account field.
      5. Repeat for each level of GL Accounts
   2. Item List

    

    

   
   Once the GL Accounts are imported into the SandBox or the SalesForce, you are supposed to add the default accounts to the GL Default Setup. To do this, in the home page click on the Admin/Get Started object. (Note: Importing of GL Accounts are also explained in the Chapter GL Accounts).

   ...