Skip to Content
avatar image
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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    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.

    Hope this answer your question.

    Thanks

    Arshad

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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

    Add comment
    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

      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