top of page
Search

Set up general journal templates

Financial transactions are usually documented in the general ledger using specific business documents such as purchase invoices and sales orders. However, you can also manage business activities like purchasing, paying, or reimbursing employee expenses by posting journal lines in various journals within Business Central. Before using journals, it's necessary to set up journal templates and journal batches.

Every journal type is configured with a specific journal template. These templates establish the fundamental structure of the journal, allowing users to define default details for all batches generated using the template.


Set up general journal templates

To set up a new general journal template in Business Central, follow these steps:

  1. Select the Search for Page icon in the top-right corner of the page, enter general journal templates, and then select the related link.

  2. Create a new line by entering information in the following fields:

    • Name and Description - Provides a unique identifier and short description for the template.

    • Type - Determines the structure and functions of the journal page. The available options in this field are:

      • General

      • Sales

      • Purchases

      • Cash Receipts

      • Payments

      • Assets

      • Intercompany

      • Projects

      • Payroll accrual

      • Deposits

      • Sales tax

      • Bank deposits

    • Recurring - Determines if the journal is to be used to make recurring entries. Each journal type can be used for recurring purposes.

      Journal lines are typically removed from the journal after they are posted. However, recurring journals keep the journal lines for reposting during the next period. Therefore, the No. Series field must be blank because it will always be replaced with the posting number series. (Entries can never be posted by using the same document number.)

      The process of setting up and using a recurring journal will be discussed later in this learning path.

    • Bal. Account Type and Bal. Account No. - Identifies the default balancing account for all journal lines in all batches that are created under this template.

    • No. Series and Posting No. Series - Identifies the default number series (No. Series) that is used to assign document numbers to journal lines in journal batches that are created by using this template.

      Identifies the document number (Posting No. Series) that you can use to assign to ledger entries that are posted from journal batches that are created by using this template.

The table below outlines the potential setup combinations for No. Series and Posting No. Series.

Expand table

No. Series

Posting No. Series

Result

Blank

Blank

Document numbers must be manually entered in the journal lines and the same manual number will be assigned to all ledger entries after you have posted the journal batch. This is used, for example, with temporary journal postings that are not important to track.

Filled in

Blank

Document numbers are filled in automatically in the journal lines and the same number will be assigned to all ledger entries after you have posted the journal batch.

Blank

Filled in

Document numbers must be manually entered in the journal lines. When the journal batch is posted, document numbers from the indicated number series will be assigned to all ledger entries.

Filled in

Filled in

The fields are filled in with a different number series. Document numbers are filled in automatically in the journal lines. When the journal batch is posted, the document number will be replaced by the next number from the posting number series and assigned to all ledger entries. This is used, for example, with important journal postings that must be traceable.

Some additional fields include:

  • Source Code - Identifies the point of origin for an entry and forms the basis for the audit trail. This field is filled in automatically when you select the Type of the General Journal template, according to the default source codes set up in the Source Code Setup page.

  • Reason Code - Describes why an entry was made and can be used for the audit trail. Reason codes also provide opportunities for problem patterns analysis.

  • Force Doc. Balance - Specifies whether entries that are posted in this general journal template must balance by document number and document type. If this field isn't selected, the program balances the journal by date only.

  • Copy VAT/Tax Setup to Jnl. Lines - When this option is selected, it directs the program to automatically fill in the general posting type, general posting groups, and VAT posting groups on the journal lines of the selected journal template with the defaults from the accounts and balancing accounts.

    When the option is selected or cleared, a message appears asking if the journal batches must be updated. Select Yes or No as applicable.

  • Increment Batch Name - Specifies if batch names that are using this template are automatically incremented. For example: after you've posted BATCH01, the following batch is automatically named BATCH02.

  • Allow VAT/Tax difference - When this option is selected, it determines if the manual adjustment of VAT amounts in journals is allowed.

    When the option is selected or cleared, a message appears asking if the journal batches must be updated. Select Yes or No as applicable.

  • Copy to Posted Jnl. Lines - Specifies whether the journal lines to be copied to posted journal lines of the selected journal template. When you enable this field, when posting the journal lines from this template, the program copies the lines to the Posted General Journal page. From there, you can copy the lines back to the journal, which can be useful when you want to correct entries.


 
 
 

Comments


bottom of page