Importing Data
Data import can be done either by using Data Loader or Import Wizard. For most situations, Import Wizard works in case you don't have hierarchies in GL Account or Item list.
Info |
---|
title | When to use Data Loader |
---|
|
Only when you want to import data with Hierarchy. |
Data Import using Import Wizard
GL Account
Prepare your file
- Create a CSV file with the following fields
- Account Name
- Account Number
- Type
- Balance
- Description
- Fill each columns with the related data
Make sure the Type field matches to the Picklist Value of "Account Type" is AccountingBook. The values are:
Info |
---|
|
Income Expense Equity Cost of Goods Sold Other Income Other Expense Bank Fixed Asset Accounts Receivable Accounts Payable Other Current Asset Other Current Liability |
...
- Add all Parent GL Accounts
- Export all GL Accounts with Parent Salesforce Ids
- 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
- Use data loader to upload all records, make sure you have added the ParentAccountId to point to the Parent GL Account field
- Repeat for each level of GL Accounts
Items (Products)
Prepare file
- Create a CSV file with fields in Item Custom Object
- Name
- Type as
- Service
- Inventory
- Payment
Discount
Group
Sales Tax Item
Sales Tax Group
Other Charge
Expense
Non-Inventory
Income Account
- Sales Price
- Sales Tax (Note remove any % sign in this field)
- Chart of Account (GL Account associated with the above Sales Tax) ** Required if this item is Sales Tax
- Purchase Price
- Vendor (Preferred Vendor) ** Required if its purchased through another vendor
- COGS Account ** Required if ts purchased through another vendor
- Asset Account ** Required if its Inventory Item
...
- Go to Setup -> Data Management (Left nav) -> Import Custom Object -> Start Import Wizard
- Follow steps to map your CSV fields to the GL Account Fields
- Import all data
Data Import using Data Loader (use when Hierarchy import is needed)
Item List
Configuration
Click on Admin/Get Started object
...
Info |
---|
|
If the Account Name/s are not reflected in the dropdown list, the reason might be that the spelling of the Account is incorrect. While importing the GL Accounts through the Data Loader if the defaults accounts are spelled correctly then those accounts are to be automatically reflected in the dropdown menu, else you need to manually rename the Account names. |
Remote Site Security Setting
Info |
---|
title | What is "Remote Site Settings" ? |
---|
|
Remote Site Settings allows permissions to Salesforce Apex (code) to call to other Web Services or Web Applications. In this case we are allowing AccountingBook to call Salesforce internally using Web Services to enable some of the dynamic functionalities to work. |
...
- Add that in Remote Security setting with name – "Instance"
- Copy the first part of the URL address to the Remote Site URL. Refer the underlined URL in the picture
- Click on Save button, it looks as below once saved
Update Dynamics Page Layouts for Enhanced Data Entry Screens
Info |
---|
title | Page Layout for Enhanced Entry Screens |
---|
|
One of the most requested features that we have in is a much better data entry screen for Receivable, Payable and Journal Entries. The data entry for standard force.com requires a lot of clicks and so we have created a module that makes it simpler for users to enter these documents. |
...
Retrieve page layout updates page layouts for edit screens for Receivables and Payables objects to organize all the controls(Field) in one layout. Which enables to either add or remove the fields from the page layout.
QuickLinks to Accounting Functionality
Enable Left side AccountingBook Links
...