Former Member

### How the Arrears in days be calculated for customer ?

HI SDN:

As title above,when using report S_ALR_87012178. how the Arrears in days generate ?

SAP help tell us a formula as follows:

An invoice for 1,000 is paid in 10 days. Another invoice for 3,000 is paid in 6 days.

The average arrears are calculated as follows:

(10 * 1000 + 6 * 3000) / (1000 + 3000) = 7 days.

Acorrding to the result of S_ALR_87012178 it cannot work out the arrears in days thru the formula.

Best regards

Yu Chaoqun

20090107

10|10000 characters needed characters exceeded

• Former Member
Feb 13, 2009 at 08:28 PM

Hi Guys;

It is very simple.

Days in arrear = Date of Invoice + Payment terms - Run Date

An invoice is created on 1st Dec 2008 and payment terms is 30 days.

If you are executing it on 13 Feb 2009 the Days in arears shall be 45 days

45 = 1st Dec 2008 + 30 days - 13 Feb 2009 (i.e from invoice date)

45 = 30 - 75

75 = 1st Dec 2008 to 13 Feb 2009

75 = Dec 31 days + Jan 31 days + Feb 13 days.

Thanks

10|10000 characters needed characters exceeded
• Former Member
Jan 07, 2009 at 05:22 AM

Hi,

System will not show cleared amounts (Not due) in this report. Only documents which are unpaid display in this report.

For arrears calculation no formulas required.

check the baseline data in payment terms. E.g posting date / document date.

How system calculates the arrears is,

First system will check the baseline date of document e.g posting date then we are running report today. system calculates the arrears the days between posting date of document and today's date.

E.g Invoice document posted on 12/10/2008 and report generating date is 01/07/2009 (today).

days in arrears 28 .

Regards,

Chandra

10|10000 characters needed characters exceeded
• Former Member Former Member

hi:

Program (screen) RFDOPR10

1

input:

Customer account 1510000

Fiscal year 2008

Open items at key date 2009/01/07

run

result:

CHINA

Sls/pur.data (amnts in LC) Payment data

Annual purchases : Payment terms : 0001

Authorized deducs : Vendor clearing :

Unauthorized deducs: Type : Cash discount taken where possible

Intrst : Arrears in days : 187

Accum.clearing : Last payment period:112008

2.

Program (screen) RFDOPR10

input:

Customer account 1510000

Fiscal year 2008

Open items at key date 2009/01/09

run

Company code L000 Accounting clerk Customer 1510000

CHINA

Sls/pur.data (amnts in LC) Payment data

Annual purchases : Payment terms : 0001

Authorized deducs : Vendor clearing :

Unauthorized deducs: Type : Cash discount taken where possible

Intrst : Arrears in days : 187

Accum.clearing : Last payment period:112008