Ansicht
Dokumentation

RFDOPR10 - Customer Open Item Analysis by Balance of Overdue Items

RFDOPR10 - Customer Open Item Analysis by Balance of Overdue Items

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.
SAP E-Book

Use

The program allows the selection and the analysis of customer open items whose overdue items exceed an amount you predefine.

If you do not want a selection with regard to the balance of the overdue items, you should check whether you can use the program for customer assessment with an OI sorted list (RFDOPR00) instead of this program. The program mentioned last offers almost the same options concerning the days overdue analysis, but is more favorable in terms of run time.

Requirements

The system records a customer's payment history only if you select Rec.pmnt hist. in the company code area of the customer master record.

Note

The evaluation is used to determine as precisely as possible the customers who should be subject to more intensive credit monitoring because of considerable outstanding debts.

The following criteria are available for this:

  • The current data from the master record data base such as open item balance and special G/L balances
  • The actual payment history also updated in the master record database.

The payments from the last five periods in which payments took place are used for the analysis.

Using the payment volume, it can be determined whether the customer generally makes use of the full payment target and renounces a cash discount deduction (cash discount payer).

By weighting the average number of days in arrears from the last 5 periods in which payments were made according to the payment amounts from those periods and dividing this by the total payment amount from the 5 periods, a value for the "average days in arrears" is arrived at.

In addition to analyzing payment history, this program evaluates customer open items. It structures the items it selects using a time schedule that you can define as you like, and displays them according to business area.

The predefined examination criterion is:

Days overdue of the due items

  • Analysis type = ovd
  • Calculation: Days in arrears = key date - due date for net payment

Example: Analysis of open items

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

Items:

-------

  • Document date 01.04.YYYY
  • Baseline date for payment 05.04.YYYY
  • Term of payment 1 8 days / 5%
  • Term of payment 2 14 days / 2%
  • Net term of payment 21 days /
  • Key date: 14.05.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.

Days overdue (ovd)

(key date - due date for net payment)

14.05.YY - 26.04.YY = 18 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:

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

Item is open but not yet due

Explanation for column 6:

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

Item has been overdue for 41 days or more.

Note

In the case of the analysis type ovd, the time axis points to the past (analysis of the overdue items).

For the summarization level "0", only the overdue open items are output.

Unless you want the customer master record information to be issued without overdue items, you can suppress the output by excluding the initial value (0) as a single value from the selection with the select option for the balance of overdue items.






Addresses (Business Address Services)   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 4738 Date: 20240520 Time: 123006     sap01-206 ( 63 ms )