Implementation

Prev Next

Mary and Candace now want to know how to set up Sales Accounting Entries so that they are generated correctly for each invoice issued.


We advise you to read:

The information in this article is provided as an example, and should be customized to your business needs.

The relationship of the Sales ledger entries with other objects

Frisbii's Conceptual Data Model (CDM) allows you to determine the links and relationships between the objects in the application.
Here is an extract to help you understand the rest of the article:

Setting up the pre-requisites for the ledger entries

In order to meet the conditions for generating ledger entries, it is necessary to make settings on the following objects:

Steps

A - Activate the entries on the Corporate Name

  1. Go to the Corporate names tab

  2. Check the box Enable Book Entries

Beware: if this box is not ticked, no accounting entries will be generated

  1. If you are using the Accounting data: check the box Detect accounting data (applicable when only one record corresponds to the Account / Company name pair).

  1. Click on Save

B - Create the Chart of Accounts

  1. Click on the Application Launcher

  2. Type Plans in the search bar

  3. Click on Charts of Accounts

  4. Click on the New button

  5. Give a Name to the Chart of accounts.

  6. Click on Save.

  7. Go back to the Corporate names tab.

  8. Fill in the Chart of Accounts field (select the name of your chart of accounts).

C - Create Accounting Accounts

  1. Click on the Application Launcher

  2. Type Account in the search bar

  3. Click on Accounting Accounts

  4. Click on the New button


    5. Select your Chart of Accounts
    6. Enter the desired Account Number

Reminder (for France only):

  • The customer accounting account "411".

  • The sales tax (VAT) account "445".

  • The general sales account "70" (e.g. 706 for the sale of services, such as subscriptions).

  1. Put a wording that will allow you to easily recognize the accounting account concerned

  2. Click on Save or on Save and New to fill in other accounting accounts

D - Create sub-ledger accounts

  1. Go to the Accounting account

  2. Go to the related list of Sub-Ledger accounts

  1. Click on the New button

  2. Fill in the information

  • Sub-account number

  • Accounting account (automatically filled in)

  • Currency

  • Account

  • Wording

  1. Click on Save or Save and New, if you want to create them for other accounting accounts.


E - Fill in the fields on the account

1. Go to the Account tab.

2. Open a record for which you want to set up the entries.

3. Fill in the fields Auxiliary account and VAT account (optional).


  1. Click on Save

F - Adding the Accounting Data

Note: If you do not use the Accounting Data, this part does not concern you.

1. Click on the Accounting Data object from the Application Launcher.

2. Click on New.

3. Fill in the information:

  • Record name

  • Account

  • Company name

  • VAT account

  • ! Sub-Ledger account: Important for the generation of entries

  • VAT by default

  • Follow the Accounting data module for more information: Accounting data - Main fields

4. Click on Save or Save and New.

Beware: Once the accounting data has been set up, you have to fill it in on the invoices for which you want to generate the entries.

G - Adding a product

1. Click on the Product object from the Application launcher.

2. Click on the New button.

3. Fill in the needed information:

  • Product accounting account

  • Sales tax (VAT) account

Beware: Check the Active box, to take your product into account. 

4. Click on Save.

H - Product Configurations

Note: If you don't use the Product Configurations, this part does not concern you.


1. Click on the Product Configurations object from the Application Launcher

2. Click on the New button.

3. Give your record a Name.

4. Add a Currency (if the multi-currency option is enabled in your org).

5. Click on Save.

I - Product Rules

Note: If you don't use the Product Rules, this part does not concern you.

1. Click on the Product Rules object from the Application Launcher.

2. Click on the New button.

3. Fill in the needed information:

  • Product accounting account

  • Sales tax (VAT) account

4. Click on Save.


Testing the Generation of Sales Entries

Linda explained to Mary and Candace the necessary settings before generating the entries. Now they can finally open an invoice and verify that the entries have been fully generated! Here are the procedures to test that the ledger entries are properly implemented.

Steps

J - Invoice

  1. Go to the Invoices tab

  2. Open a record

  3. Check that there is : The Accounting Data (if you use it)

K - Invoice lines (from your invoice)

  1. Go to the related list Invoice line items

  2. Open a record

  3. Check that there is :

  • The VAT Account (on the invoice lines concerned by VAT)

  • The product account

In order to test:

  1. Go back to the invoice

  2. Set the status to Issued

Once your invoice goes to the Issued stage, on the related list of your invoice you can see the Ledger Entries associated with this invoice :

Reminder of anomalies

Didn't the sales accounting entries generate?

Recheck these items:

The anomalies blocking the generation of accounting entries are:

  • The absence of Accounting Data on the Invoice,

  • The absence of an Auxiliary Account on the accounting data,

  • The absence of a Product Account on an invoice line,

  • The absence of a VAT Account (on an invoice line concerned by VAT),

  • The management of accounting entries is disabled on the corporate name.