cancel
Showing results for 
Search instead for 
Did you mean: 

Due Date Analysis in Report Painter

atif_farooq
Active Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

ibrahim-gad
Participant
0 Kudos

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

atif_farooq
Active Contributor
0 Kudos

Dear Ibrahim:

I have already developed above report but that does not suffice client requirement because report painter tool is offering us analysis of days based on when is invoice becoming due , my client requires analysis from the date when invoice was created, i think its not possible to do such in report painter.

Thanks

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Atif

You will have to look at ABAP report only

Regards

Sanil

former_member206852
Contributor
0 Kudos

Dear Atif

Where are you capturing the invoice creation date, document date (1) or posting date (2)?

If you are referring to system date (3), then that also can be handled.

Entire crux of your due date analysis is linked to your baseline date which in turn is directly derived from your payment term. Define your payment as per the client requirement.

Hope you are able to proceed now?

Regards

ibrahim-gad
Participant
0 Kudos

Hi Atef,

Well, you want to use document date for aging report regardless due date

go for ABAP as Sanil suggested

Regards,

Ibrahim