Managing Journal Lines

  • 09/09/2021
  • 6 minutes to read

Bank account statement lines must be matched and applied with ledger entries to be reconciled. The journal ledger entries can be created in a general journal, a cash receipt journal, a payment journal, and in an employee payment journal. The employee payment journal is based on a standard payment journal created by Payment Management to separate the vendor ledger entries from the employee ledger entries.

To manage journal lines on import

You can choose how Statement Intelligence should manage and create journal lines in the bank account reconciliation when importing bank account statements for the customer-, vendor- and employee payments.

  1. Use the Search for page or report icon to search for Statement Intelligence Setup and select the related link. This will open the Payment Management Setup page.

  2. On the Statement Intelligence Setup page, navigate to the FastTab General.

  3. Select how to manage journal lines when importing bank account statements. This can be defined for the following setups:

    • Handle Cash Receipt Journal Lines
    • Handle Payment Journal Lines
    • Handle Employee Payment Journal Lines

For each of the above setups, you can choose between the following settings:

SettingDescription
Create SuggestionJournal lines are automatically generated as reconciliation suggestions if open ledger entries can be identified based on customer-, vendor-, or employee number, payment ID, or document no. as search parameters. If reconciliation rules have been defined, these will also be used to generate potential reconciliation suggestions.
NoneJournal entries will not be created. Instead, you can access the No. of Reconciliation Suggestions on the imported bank statement line and create the journal line suggestions from there.
Create Lines on ImportWhen importing a bank account statement, ledger entries will automatically be created, matching all the imported bank account statement lines 1:1. You must then manually validate and delete journal lines that are not created correctly.
Create Lines ManuallyThis setting is very similar to the setting Create Suggestion; however, the journal line suggestions are not created automatically in the journals. Instead, it would be best to manually create the journal ledger entries using the action Create journal lines.

To handle updating the payment journal line status

To handle the updating the status of journal lines:

  1. Use the Search for page or report icon and search for Banks, then select the related link.

  2. Select the bank, and on the bank card, navigate to the FastTab Advanced.

  3. Go to the Update Payment Journal Lines Status field, and from the drop-down box, select Automatic or Manual.

    Note

    If you select to update the payment journal line status automatically, it will run the Job queue (codeunit 6216327 CPM update Pmt.Jnl.Line Status) on the selected time interval and update the status accordingly.

To manage journal numbers

You can specify if journal document numbers in journals used for the bank account reconciliation must be renumbered automatically before posting the journal lines.

To manage the renumbering of journal document numbers:

  1. Use the Search for page or report icon and search for Statement Intelligence Setup, then select the related link. This will open the Payment Management Setup page.
  2. On the Statement Intelligence Setup page, navigate to the FastTab General.
  3. Go to the Renumber Journal Document Nos. field, and activate the selection if document numbers in journals used for bank account reconciliation must be renumbered automatically before posting.

To include the statement number in the journal line description

You can specify if the bank account statement number must be included in the description of journal lines that Statement Intelligence creates.

To include the statement number in the journal line description:

  1. Use the Search for page or report icon and search for Statement Intelligence Setup, then select the related link. This will open the Payment Management Setup page.
  2. Navigate to the FastTab General, and enable the Include Statement No. in the Journal Description setting if you want to include the bank account reconciliation in the description of journal lines created by Statement Intelligence.

To handle empty Ending No field

You can specify how to handle empty Ending No. fields in sales and purchase documents. You can throw an error or skip matching based on No. Series.

To handle empty Ending No. field:

  1. Use the Search for page or report icon and search for Statement Intelligence Setup, then select the related link. This will open the Payment Management Setup page.
  2. On the Statement Intelligence Setup page, navigate to the FastTab General.
  3. In the Handle No. Series empty Ending No. field section, go to the Sales Documents field and select how you want to handle an empty Ending No field. The options are:
    • Throw error
    • Ignore No. Series matching
    • Guess empty Ending No
  4. Do the same for the Purchase Documents field.