Pay-by Business Partner Statistics (tfcmg3501m000)

Use this session to list business-partner statistics by credit analyst.

This data is taken into account:

  • invoices
  • credit notes
  • trade notes
  • payment differences created using the Write Off Payment Differences (tfacr2240m000) session
  • advance receipts (unrelated to trade note)
  • unallocated receipts (unrelated to trade note)
  • assignments linked to invoices

To view all business-partner statistics, from the appropriate menu, select Pay-by Business Partner Statistics.

To view the invoice-to business partner details, double-click a line to start the Invoice-to Business Partner (tccom4112s000) details session.

Note: To ensure that the statistics shown in this session are up-to-date, first run the Update Pay-by Business Partner Statistics (tfcmg3200m000) session.
Note: No date or period is stored. As a result, there is no history data to assess a business partner’s performance.

Field Information

Credit Analyst

Select the credit analyst.

Business Partner

The invoice-to business partner code.

Average Days for Payment

To calculate the average days for payment, the application uses this formula:

A = receipt amount * (receipt date - doc date)
Sum of A for all receipts / sum of receipt amounts
Average Days Outstanding

To calculate the average days outstanding, the application uses this formula:

A = (sum of outstanding amounts * number of days between invoice date and end of period) / total outstanding amount
  • Where... -
  • end of period = - last date when Update Pay-by Business Partner Statistics (tfcmg3200m000) was run
Average Days Overdue

To calculate the average days overdue, the application uses this formula:

A = sum (receipt amount * days overdue) / sum of receipt amounts