Business Partner Statistics

The customer receipt performance details are imported from the Accounts Receivable module using the Update Pay-by Business Partner Statistics (tfcmg3200m000) session and the supplier payment details are imported from the Accounts Payable module using the Update Pay-to Business Partner Statistics (tfcmg3202m000) session.

The following statistics is updated for a business partner:

  • Outstanding amounts

    The sum of all the unpaid amounts that refer to invoices and credit notes or debit notes.

  • Average days outstanding

    The sum of the outstanding amounts each one multiplied by the number of days between the invoice date and the end date of a period, divided by the total outstanding amount.

  • Amount received or paid

    The total amount actually received or paid during a certain period. The amount does not include any anticipated amounts.

  • Average receipt period

    The sum of all the amounts received or paid, each one multiplied by the number of days between the invoice date and the receipt date or payment date, divided by the total amount received or paid in a certain period.

  • Average number of days overdue

    The sum of all the amounts received or paid, each one multiplied by the number of days between the due date and the receipt date or payment date, divided by the total amount received or paid in a certain period.

  • Payment differences

    A difference between the invoice amount and the payment amount. If the payment difference falls within the user-defined margins, it can be accepted and written off automatically.

  • Tolerated discount amount

    The tolerated discount amount is determined for all outstanding amounts of a certain business partner. LN determines the first, the second, or the third cash discount that must be deducted according to the payment terms that apply to the transaction. This amount will be maintained per period, per business partner.

  • Actual discount amount

    The sum of all the discounts actually deducted during a certain period.

  • Deductable late payment surcharges

    The percentage that is charged over the goods amount or over rendered services that the recipient of the invoice must pay if the bill is not paid within a specified period.

  • Actual late payment surcharges

    The actual late payment surcharges.