2022
Log into SalesForce, go to AppExchange Object and type AccountingBook in the search tab and Enter. A new page gets opened
Click on the AccountingBook icon that takes you to a new page where you find the Overview of AccountingBook. You also find different tabs like Details, Overview, Reviews and Provider information in this page.
Once you click on Get It Now button a new page gets opened and you have two options to get AccountingBook installed in your organization.
On clicking on Get it Now a new page opens, which helps you to start with the installation process.
On clicking on the Confirm and Install button a SalesForce login page or a Sandbox login page is opened. Enter SalesForce or Sandbox credentials to start with the installation process.
The installation will run you through the three step process, check each and every step carefully before proceeding to the next; else the installation may need to be uninstalled and should be done all once again. Press on Next button to proceed to the new page
On the second page you will be able to grant access to the users via three categories. Select the appropriate radio button and click on Next
The package is now ready to be installed. Click Install to continue. You will get a message "Your request is in progress. You will be notified by email when it completes" as installation is in progress
You will get a mail from SalesForce.com in your mail box one the package is successfully installed in your Salesforce or Sandbox and you are able to use AccountingBook before customizing few objects.
Now, the AccountingBook package is ready for your use.
This section allows you to read and share your views on AcountingBook.
Provider tab give you the contact details of the Avanika LLC and the list of other products available.
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).
When to Use Data Loader?
If the Accounts are maintained by your organization are in the hierarchy method, to put it in other words if the accounts are in the parent-child relationship in a large number we need to use data loader to upload those accounts to the AccountingBook.
If you are setting up AccountingBook instance in sandbox or in SalesForce you need to have CSV files of the required data to be imported to the AccountingBook. Open Data Loader package and click on the Insert button.
On clicking the Insert button a new window opens
To proceed further you need to enter the credentials of your Sandbox or SalesForce in which the AccountingBook is installed.
The next step is to select the object to which the data needs to be imported.
As we are setting up the AccountingBook the first thing we need to setup is GL Accounts or the Chart of Accounts, select GL Accounts from the SalesForce object from the given list. Browse the CSV file of Chart of Accounts which needs to be uploaded to the AccountingBook.
Once you have selected the CSV file to import click on Next.
The App shows the number of records it is about to import into the AccountingBook and you are suppose to click on OK button.
Either you can Choose an Exiting Map if there are any saved maps or you should click on the Create or Edit a Map button
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.
Once auto mapping and dragging is done click on OK button.
Now Data Loader will add data to the SalesForce, for that you need to click on the Next button.
The last step is to finish the activity by clicking on the Finish button.
Click on OK button to conclude the operation of importing data to the GL Accounts of the AccountingBooks package. But this will only add the accounts to the GL Accounts.
To add hierarchy or the parent-child relationship to the accounts you 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)
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
Click on Admin/Get Started object
Select the appropriate accounts from the drop down menu
Once you have Setup the defaults, click on the Save GL Defaults button.
Note: 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. |
To edit the Account Type, if it is incorrectly spelt click on the Setup Link in the Home Page.
In the new page click on the Packages tab
A new page is opened where you need to click on GL Account Tab as shown below
On clicking the GL Account Tab a new window gets opened where you need to click on Account Type tab in the Custom field & Relationships section
In the new page scroll down to Picklist Values. Click on the Edit link to change the Accounts in the Values column.
Let us take an example of Accounts Receivable value and see how it goes.
You have learnt how to create default accounts and edit the account type now.
What does remote site setting do? |
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
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.
This completes AccountingBook Setup