Table of Contents

Report on Payment Delays

Creating a New Payment Delay Report

To create a new delegation:

  1. Select the search icon Search in the upper right corner of the Business Central system, then type List of Payment Delay Reports and click the link.
  2. Create a new document by clicking the +New button on the action bar.
  3. The system will automatically create a new document and open it for further editing.
  4. Fill in the fields in the General section in order:
    • Document No. - manually enter the document/report number.
    • Description - enter the report description.
    • Start Date - should be the starting date of the year for which the report is generated, e.g., 01.01.20xx.
    • End Date - should be the ending date of the year for which the report is generated, e.g., 31.12.20xx.
    • Customer Posting Group - a filter used to select entries from the customer ledger with a specific customer posting group. Specific groups can be indicated or unwanted ones excluded.
    • Vendor Posting Group - a filter used to select entries from the vendor ledger with a specific vendor posting group. Specific groups can be indicated or unwanted ones excluded.
    • Payment Method Code - a filter used to select entries from the customer/vendor ledger with a specific payment method. Specific groups can be indicated or unwanted ones excluded.
    • Prepayment Account – Sales - the account number from the general ledger (or filter) to which prepayment invoices for sales are issued and posted. Used to search for and include prepayment invoices in the report.
    • Prepayment Account – Purchases - the account number from the general ledger (or filter) to which prepayment invoices for purchases are issued and posted. Used to search for and include prepayment invoices in the report.
    • Cust. Start Due Dater - a date used to select entries from the customer ledger with a payment due date later than or equal to the specified date. Leaving it blank means the system will not impose an additional filter on the payment due date.
    • Vend. Start Due Date - a date used to select entries from the vendor ledger with a payment due date later than or equal to the specified date. Leaving it blank means the system will not impose an additional filter on the payment due date.

The user has 10 fields available to specify the aging of payment delays. When creating a new document, the system will automatically propose and assign aging in specified ranges, in accordance with current ministry requirements.

Generating Payment Practice Report Data

After filling in the required data and filters in the document header, data should be generated by selecting the Generate option on the ribbon. This process may take a while depending on the number of entries in the customer and vendor ledgers for the specified period.

Once the data generation is complete, a list of documents along with their information will appear in the Payment Practice Report Lines section. This list contains data from the auxiliary ledgers of vendors and customers as well as from detailed entries and presents the following data:

  • unpaid documents from previous years,
  • documents from previous years paid in the year for which the report is being created,
  • documents from the year of the report that have not yet been paid,
  • documents from the year of the report paid in the year of the report.

In cases where an entry has been fully settled, information about the settlement date is specified. There is also information about the number of documents with which a given entry has been settled, as well as the settlement amount.

In the context of the selected record, the user has the option to navigate to three windows:

  • Show Settlement - an information window about the details of the settlement of a given document along with the settlement date, amount, and in the overdue column, the number of days of payment delay is presented.
  • Ledger Entries - the entries from the customer/vendor ledger for the selected record will be displayed.
  • Detailed Ledger Entries - the detailed entries from the customer/vendor ledger related to the selected record will be displayed.

The user has the option to exclude selected records from the report by checking the Exclude option next to the selected record. The excluded document will not be included in the final summary of the report.

Generating the Final Summary of the Report

To generate the final summary of the report on the report card, select the Show Matrix option. Based on the lines of the payment practice report and information about their settlement, the system will generate a matrix of the payment practice report and a summary of the report, taking into account the aging set in the report header.