Admin/Get Started

Adding GL Accounts in the GL Accounts Object

Once the AccountingBook is installed the first thing is to get AccountingBook  working. To do AccountingBook working we need to add GL Accounts and the Items. Let us know how the GL Accounts is loaded in the AccountingBook

When you need to create a huge number of accounts in the AccountingBook what do you do?
Consider an instance for creating about a 1000+ accounts. Creating all those 1000+ accounts in the AccountingBook may consume a lot of time. To overcome this issue we have a package called Data Loader. Data Loader as a package which is easy to use graphical tool that helps you to get your data into Salesforce objects. The Data Loader can also be used to extract data from database objects. Data Loader supports Comma Separated Values files (CSV files).

...

1. If you need to load 50,000 to 5,000,000 records? Data Loader is supported for loads of up to 5 million records
2. You need to load into an object that is not yet supported by the import wizards
3. You want to schedule regular data loads, such as nightly imports
4. You want to export your data for backup purposes

...

1. The rows listed are the SalesForce mapped Lables
2. The rows are the CSV files' columns

You are supposed to match the SalesForce rows and the CSV files' columns by dragging the SalesForce items to the CSV files' items. To help you to map these fields the packages has an option of Auto-Match Fields to columns button. The only thing you need to do is to click on the button. Most of them will be auto matched and the remaining you need to manually drag the items to match them.

...

...

Setup

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.

...