How the Arrears in days be calculated for customer ?

[Former Member]

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

[Former Member]

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.

Hope this answer your question.

Thanks

Arshad

[Former Member]

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

[Former Member]

Hi :

Tks for your kindly information.

And according to your remarks:"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 .

"

and the system generate 28 that's the result of compareing the invoice date with today.

so we can presume that when you run the report S_ALR_87012178 tomorrow you can get 29 as arrears.

Actually we get 28 is the same result as we got one week ago in our R3 4.7 system.

You can find this via checking the arrears field(VZS01) in table KNB4 which report S_ALR_87012178

used to display arrears.

and I'm also wondering about the following case. for eg. if an invoice date goes to be 2009/01/07 and the

posting date of FM goes to be 2009/01/07 That's exactly not taking arrears day to count in ?And how to control this?

Regards

Yu Chaoqun

JAN,07,2009

Edited by: yu Cynthia on Jan 7, 2009 6:43 AM

Edited by: yu Cynthia on Jan 7, 2009 6:48 AM

Edited by: yu Cynthia on Jan 7, 2009 7:00 AM

Edited by: yu Cynthia on Jan 7, 2009 7:06 AM

[Former Member]

Hi,

Do one simple thing.

Today it is showing arrears in days 28.

Line Items Company Code A001 Accounting Clerk Customer 0000020026 Key Date 01/07/09

A001 28 RV 0090000499 001 12102008 12102008 12102008 12102008 01 330.00 USD

A001 28 RV 0090000500 001 12102008 12102008 12102008 12102008 01 770.00 USD

Total 21 to 40 days 1,100.00

Now goto report overview screen, change the opens items key date to 01/09/2009 and execute.

Line Items Company Code A001 Accounting Clerk Customer 0000020026 Key Date 01/09/09

A001 30 RV 0090000499 001 12102008 12102008 12102008 12102008 01 330.00 USD

A001 30 RV 0090000500 001 12102008 12102008 12102008 12102008 01 770.00 USD

Total 21 to 40 days 1,100.00

Now as on 01/09/2009 days in arrears 30 .

Regards,

Chandra

[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

Address Commitmts (LC Amounts)

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