Ansicht
Dokumentation

GB_PPPR - UK Payment Practice and Performance Report

Vendor Master (General Section) General Data in Customer Master
This documentation is copyright by SAP AG.

Purpose

This report generates data that you can use to determine or calculate the figures to be reported.

This document describes how to determine or calculate the following figures for reporting:

Proportion of invoices paid beyond agreed terms (by percentage)

Average time (by number) taken to pay Invoices from the date of issue

Proportion of invoices paid within the following periods, where day 1 is the date of invoice (by percentage)

Amount of interest paid (by number)

Amount of interest liable to pay (by number)

Important: You must calculate percentages and average days manually.

Integration

Prerequisites

Features

Note: You should create your own variants for selection screens and also variants for ALV output.

Selection

Proportion of invoices paid beyond agreed terms (by percentage)

To generate the data to be used in the calculation of Proportion of invoices paid beyond agreed terms (by percentage), make the following selections.

In Vendor selection, add a filter for invoices by Document Type, for example KR (Vendor Invoice), or use any other filter to get qualifying contracts.

In Document selection, select Cleared Items and in Selection Date specify the clearing date from/to reflecting the reporting period (6 months = invoices paid within the reporting period). The clearing date of the invoice is the payment date.

In Date Type Selection, select Net Due Date. Leave Segments (days) blank.

In Transaction Type Selection, select Normal items (and optionally Special GL transactions).

In ALV Layout, use a layout as described in the Output section.

Average time (by number) taken to pay Invoices from the date of issue

To generate the data to be used in the calculation of Average time (by number) taken to pay Invoices from the date of issue, make the following selections.

In Vendor selection, add a filter for invoices by Document Type or use any other filter to get qualifying contracts.

In Document selection, select Cleared Items and in Selection Date specify the clearing date from/to reflecting the reporting period (6 months = invoices paid within the reporting period). The clearing date of the invoice =the payment date.

In Date Type Selection, select Receipt date. In + Specified Number of daysyou can specify the number of days to be added to the entry date to determine the actual date of receipt (the default value is 1, to add 1 day).

In Days added to Clearing dateyou can specify the number of days to be added to the date of the payment program run. This reflects the time delay for when the payment reaches vendor’s bank account.

Leave Segments (days) blank.

In Transaction Type Selection, select Normal items (and optionally Special GL transactions).

In ALV Layout, use a layout as described in the Output section.

Proportion of invoices paid within the following periods, where day 1 is the date of invoice (by percentage)

To generate the data to be used in the calculation of Proportion of invoices paid within the following periods, where day 1 is the date of invoice (by percentage), make the following selections.

Important: You must calculate the percentages manually.

In Vendor selection, add a filter for invoices by Document Type or use any other filter to get qualifying contracts.

In Document selection, select Cleared Items and in Selection Date specify the clearing date from/to reflecting the reporting period (6 months = invoices paid within the reporting period).

In Date Type Selection, select Receipt date. In + Specified Number of daysyou can specify the number of days to be added to the entry date to determine the actual date of receipt (the default value is 1, to add 1 day).

In Days added to Clearing dateyou can specify the number of days to be added to the date of the payment program run. This reflects the time delay for when the payment reaches vendor’s bank account.

In Segments (days), enter 30 in the second box and 60 in the box field:

In Transaction Type Selection, select Normal items (and optionally Special GL transactions).

In ALV Layout, use a layout as described in the Output section.

Amount of interest paid (by number)

To generate the data to determine the Amount of interest paid (by number), make the following selections.

In Vendor selection, add a filter for invoices by Document Type or use any other filter to get qualifying contracts. Use a special document type (or types) for penalty invoices.

In Document selection, select Cleared Items and in Selection Date specify the clearing date from/to reflecting the reporting period (6 months = invoices paid within the reporting period).

In Date Type Selection, select Posting Date. Leave Segments (days) blank.

In Days added to Clearing dateyou can specify the number of days to be added to the date of the payment program run. This reflects the time delay for when the payment reaches vendor’s bank account.

In Transaction Type Selection, select Normal items (and optionally Special GL transactions).

In ALV Layout, use a layout as described in the Output section.

Amount of interest liable to pay (by number)

To generate the data to determine the Amount of interest liable to pay (by number), make the following selections.

In Vendor selection, add a filter for invoices by Document Type or use any other filter to get qualifying contracts. Use a special document type (or types) for penalty invoices, for example document type KA.

In Document selection, select Open Items and in Selection Date specify the date reflecting end day of the reporting periods.

In Date Type Selection, select Posting Date. Leave Segments (days) blank.

In Transaction Type Selection, select Normal items (and optionally Special GL transactions).

In ALV Layout, use a layout as described in the Output section.

Standard Variants

Output

When you execute the report, the Analyze Entry Data list is displayed:The output shows a list of the invoices determined by the entries made in the selection screen.

For Proportion of invoices paid beyond agreed terms (by percentage), Average time (by number) taken to pay Invoices from the date of issue, Amount of interest paid (by number) and Amount of interest liable to pay (by number), the following fields are relevant for the ALV report:

Amount in LCurr

Days

Total Docs

Overdue Docs

Select these fields and save this as an ALV variant (for example, /VARIANT_1).

For Proportion of invoices paid within the following periods, where day 1 is the date of invoice (by percentage), the following fields are relevant for the ALV report:

Amount in LCurr

Days

Total Docs

DOCS 0-30

DOCS 30-60

DOCS > 60

Select these fields and save this as an ALV variant (for example, /VARIANT_2).

Activities

You calculate Proportion of invoices paid beyond agreed terms (by percentage) as follows:

Overdue Docs * 100 / Total Docs

You calculate Average time (by number) taken to pay Invoices from the date of issue as follows:

Days / Total Docs

You calculate Proportion of invoices paid within the following periods, where day 1 is the date of invoice (by percentage) as follows:

DOCS 0-30 * 100 / Total Docs

DOCS 30-60 * 100 / Total Docs

DOCS >60 * 100 / Total Docs

You determine Amount of interest paid (by number) as follows:

Paid interest = Amount in LCurr

You determine Amount of interest liable to pay (by number) as follows:

Unpaid interest = Amount in LCurr

Example

Proportion of invoices paid beyond agreed terms (by percentage)

The total number in the Total Docs column is 4.

The total number of invoices paid beyond agreed terms in the Overdue Docs column is 3.

Overdue Docs * 100 / Total Docs

3 * 100 / 4 = 300 / 4 = 75 %

Average time (by number) taken to pay Invoices from the date of issue

The total number of days taken to pay invoices in the Days column is 124.

The total number in the Total Docs column is 4.

Days / Total Docs

124 / 4 = 31 days

Proportion of invoices paid within the following periods, where day 1 is the date of invoice (by percentage)

The total number of invoices shown in the Total Docs column is 5.

The total number of invoices paid between 1 to 30 days shown in the DOCS 0-30 column is 3.

The total number of invoices paid between 30 to 60 days shown in the DOCS 30-60 column is 1.

The total number of invoices paid after 60 days shown in the DOCS > 60 column is 1.

1 – 30 X% = DOCS 0-30*100/Total Docs = 3*100/5 = 300/5 = 60%

30 – 60 X% = DOCS 30-60*100/Total Docs = 1*100/5 = 100/5 = 20%

>60 X% = DOCS >60*100/Total Docs = 1*100/5 = 100/5 = 20%