AccountingBook

2022

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 8 Next »

 

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. Importing GL Account using Data Loader
  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 

Update Configurable Page Layouts

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.

The module is a Visualforce component and the component can be re-configured or updated by clicking the "Retreive 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 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.

QuickLinks to Accounting Functionality

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