2022
Table of Contents |
---|
Seting up AccountingBook comprises of two parts
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 heirarchies hierarchies in GL Account or Item list.
Info | ||
---|---|---|
| ||
Only when you want to import data with Hierarchy. |
...
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.
...
Similarly, Items can also be uploaded into the AccountingBook in the Items Object. The procedure to add a single item is explained in the Chapter Items for your reference.
Once the GL Accounts are loaded into the AccountingBook, the default accounts needs to be defined to get the correctness in the entries. To do so follow the below steps
Prepare your file
Make sure the Type field matches to the Picklist Value of "Account Type" is AccountingBook. The values are:
Info | ||
---|---|---|
| ||
Income |
Import data
In case there are hierarchy involved, you can use Apex Data Loader to import the date. See Importing GL Account using Data Loader for more details.
The steps for importing hierarchical data is as follows -
Prepare file
Discount
Group
Sales Tax Item
Sales Tax Group
Other Charge
Expense
Non-Inventory
Income Account
Import data
Item List
Click on Admin/Get Started object
Select the appropriate accounts from the drop down dropdown menu
From the dropdown menu select the Default Revenue Account
From the dropdown menu select the Default Cash GL Account
From the dropdown menu select the Default Bank GL Account
From the dropdown menu select the Default CC Account
From the dropdown menu select the Default Revenue Account for Accounts Payable
Once you have Setup the defaults, click on the Save GL Defaults button.
...
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. |
...
...
Info |
---|
What does remote site setting do? |
| ||
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. |
Goto Setup> under Security Controls Tab> Click Remote Site Setting.
...
In the new page save the remote site settings by clicking Save button
Info | ||
---|---|---|
| ||
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. |
Once the Remote site is added in the settings, the page layout needs to be retrieved to . To do this, follow the below steps
The module is a Visualforce component and the component can be re-configured or updated by clicking the "Retrieve Page Layout" button on Admin Setup. This retrieve all the Page layout and re-configures the Visualforce component.
On Clicking the button Retrieve Page Layouts the following page pops up and takes you back to the same page
Retreive 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 feilds fields from the page layout.
Enable Left side AccountingBook Links
...
...
...
...
Congratulations, You have completed AccountingBook Setup !!!
Note: If you have any difficulty in creating new records, follow these steps:
API access must be enabled for your user(s) in Ebsta to connect to your Salesforce org.
Your Salesforce administrator controls your profile and permission sets.
Enable API Access in Salesforce by Profile
1. If you are the Salesforce administrator, go to Setup.
2. Go to Manage Users and click Profiles.
3. Click Edit against the specific Profile.
4. Scroll down to Administrative Permissions and check the API Enabled box.
5. Click Save.
Do not change any AccountingBook related documents- In Document Object, you can see AccountingBook Folder. Do not change name of any AccountingBook Document.