Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Setup

Seting up AccountingBook comprises of two parts

  1. Import Data
    1. GL Account
    2. Item List
  2. Configure the application

 

Importing Data

Data import can be done either using Data Loader or Import Wizard. For most situations, Import Wizard works in case you don't have heirarchies in GL Account or Item list.

When to use Data Loader

Only when you want to import data with Hierarchy.

Data Import using Import Wizard

  1. GL Account
  2. Item List

Data Import using Data Loader

  1. GL Account
  2. 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.


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).


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

Configuration

Click on Admin/Get Started object 




Select the appropriate accounts from the drop down menu


 

  1. From the dropdown menu select the Default Revenue Account
  2. From the dropdown menu select the Default Cash GL Account
  3. From the dropdown menu select the Default Bank GL Account
  4. From the dropdown menu select the Default CC Account
  5. 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.

 

Common Issues Found

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

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.

 

Goto Setup> under Security Controls Tab> Click Remote Site Setting.



In the new page click on the New Remote Site button


In the new page save the remote site settings by clicking Save button


  1. Add that in Remote Security setting with name – "Instance"
  2. Copy the first part of the URL address to the Remote Site URL. Refer the underlined URL in the picture
  3. Click on Save button, it looks as below once saved


 

Once the Remote site is added in the settings, the page needs to be retrieved to do this follow the below steps

Click on the Admin/Get Started object, scroll down to Retrieve Page Layouts related detail and click on the button Retrieve Page Layouts 

 

 

On Clicking the button Retrieve Page Layouts the following page pops up and takes you back to the same page 

 

Retreive 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 from the page layout.

 

Enable Left side AccountingBook Links


  1. Goto Setup menu
  2. Click on Customize
  3. Click on Home
  4. Click on Home Page Layouts, a new page gets open

  1. Click on the Edit link to open a new page

  1. Tick the check box and close the page, this will create a short cut in the AccountingBook home page the links will take you to the statement of accounts. Refer picture below, each one is the link which will open up as described



Congratulations, You have completed AccountingBook Setup !!!

 

 

  • No labels