Ansicht
Dokumentation

RFKOPR00 - Vendor Appraisal with OI Sorted List

BAL Application Log Documentation   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Use

Vendor Payment History with OI Sorted List

Note

This evaluation is used for determining, as accurately as possible, the current payment status for vendors requiring special attention.

As criteria for this valuation, you can use current data from the master database such as the following:

• Current account balance

• Special general ledger balance

In addition to the payment status analysis, the program carries out an analysis of the vendor open items for the report. Items you select are structured according to the user-defined time pattern, and output according to business area.

Using a control statement, you can select one or more criteria for the analysis:

Due date list of open items by due date for net payment

• (analysis type = net)

• (due date for net payment - key date)

Due date forecast using the first cash discount days

• (Analysis type = Dsc)

• (Baseline date for pmnt + cash disc.days 1 - key date)

Due date list of open items by document date

• (Analysis type = Old)

• (key date - document date)

Days overdue of the due items

• (Analysis type = Ovr)

• Key date - due date for net payment

Example:Open items analysis

====================

Items:

-------

• Document date 01.04.YYYY

• Baseline date for payment 05.04.YYYY

• Term of payment 1 8 days / 5%

• -2 14 days / 2 percent,

• -net 21 days net

• Key date: 15.04.YY

Due date for net payment of the item:

(baseline date for payment + net days)

Sorted list:

==========

(*) indicates the sorted list totals column in which the sample item above is entered for the different evaluation types.

A) Due date for net payment (net) =

(due date for net payment - key date)

26.04. - 15.04. : 11 days

--------------------------------------------------------

! 1 ! 2 ! 3 ! 4 ! 5 ! 6 ! --------------------------------------------------------

! ! from 1 I from 11 I from 21 I from 31 I from 41 I

I to 0 I to 10 I to 20 I to 30 I to 40 ! !

-------------------------------------------------------- (*)

Explanation for column 1:

------------------------

Items overdue

Explanation for column 6:

------------------------

Items due in 41 or more days.

B) Cash discount 1 - due date

(Baseline date for payment + cash discount days 1 - key date)

05.04. + 8 - 15.04. = -2 days

---------------------------------------------------------

! 1 ! 2 ! 3 ! 4 ! 5 ! 6 ! ---------------------------------------------------------

! ! from 1 I from 11 I from 21 I from 31 I from 41 I

I to 0 I to 10 I to 20 I to 30 I to 40 ! !

---------------------------------------------------------

(*)

Explanation for column 1:

------------------------

Items overdue with cash discount 1.

Explanation for column 6:

------------------------

Items due in 41 days or more with cash discount 1.

C) Lists sorted by age (age)

(key date - document date)

15.04. - 01.04. = 14 days

---------------------------------------------------------

! 1 ! 2 ! 3 ! 4 ! 5 ! 6 ! ---------------------------------------------------------

! ! from 1 I from 11 I from 21 I from 31 I from 41 I

I to 0 I to 10 I to 20 I to 30 I to 40 ! !

---------------------------------------------------------

(*)

Explanation for column 1:

------------------------

Items with document dates after the key date

Explanation for column 6:

------------------------

Items that are 41 or more days old.

D) Days overdue (Ovr)

(key date - due date for net payment)

15.04. - 26.04 = -11 days

---------------------------------------------------------

! 1 ! 2 ! 3 ! 4 ! 5 ! 6 ! ---------------------------------------------------------

! ! from 1 I from 11 I from 21 I from 31 I from 41 I

I to 0 I to 10 I to 20 I to 30 I to 40 ! !

---------------------------------------------------------

(*)

Explanation for column 1:

------------------------

Items are open but not yet due.

Explanation for column 6:

------------------------

Items are 41 or more days overdue.

General Note:

====================

The time axis in the analysis types Net and Dsc represents future transactions (forecast of incoming payments).

The time axis in the analysis types Old and Ovr shows past transactions (analysis of overdue items).

Logical database: VD (vendor database)

ROGBILLS - Synchronize billing plans   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 6695 Date: 20240601 Time: 055527     sap01-206 ( 58 ms )