Skip to Content

Due Date Analysis in Report Painter

Hi:

I have a query regarding Report painter FKI1 to FKI6 for Vendor aging analysis. Aging reports build from report enable user to analyze all vendors invoices which are overdue by N of days you specify for every column e.g all invoices overdue btw 0-30, 30-60 and so on but client is requiring an aging report for AP & AR which shows how old an invoice is, our baseline date is document date for all payment terms. e.g we have four columns in report 0-30,30-60,60-90 and >120. If an invoice was created with a document date 25.12.2014 which though not due should appear in 0-30 days. I need to know if its possible within report painter to have such or i will have to go for ABAP.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 28, 2014 at 07:24 PM

    Hello Atif,

      Your requirement can be fulfilled by report painter


    1- build a form with structure one axis with key figure

    2- create required N days columns

    3- use characteristic (Due date analysis with value =1) for analysis of line items due.

    4- use characteristic (Days for net due date ) with value from/ to N days.

    5- define a report with desired characteristics ( vendor, document number ....)

    Regarding to you example

    define column 0-30 as a sum formula of the following 2 columns

    a column "0-30 due" with characteristics

    (Due date analysis with value = 1) and

    (Days for net due date with value from 0 to 30)

    define another one "not due" with characteristics

    (Due date analysis with value = 2) and

    (Days for net due date with value from 0 to 99999)

    for more information you can check the following standard reports delivered by SAP:

    AP/ FKI0 >> report 0SAPDUEAN-01 Due Date Analysis for Open Items

    AR/ FDI0 >> report 0SAPDUEAN-01 Due Date Analysis for Open Items

    Regards,

    Ibrahim

    Add comment
    10|10000 characters needed characters exceeded