Regarding Customer ageing report logic in R/3.

[spandana_babu]

Dear

Experts

i have requirement to develop customer ageing report logic for input 30,60,90,180,360

i don' t have any idea hw can i take these values in input& hw can i caluclate the values

i searched in sdn, i did n't get any suitable answer..

Regards

Spandana

[Former Member]

Hi,

you can use the SAP standard Report S_ALR_87012168 - Due Date Analysis for Open Items

alternatively you can do a ABAP development using a data from the table "BSID". you can ask the developer to pick the data from that table by grouping 0-30, 31-60, 61-90 etc. the rages should be in dates and start counting the number of days from the current date (Open item Key Date) u2013date input by the user, usually the current date.if the date range is 0-30 then deduct 30 days from the input date, if it is 30-60 then deduct 30days from the 31st date. you can group the customer account based on this logic.

regards

GP

[former_member182098]

Hello,

Go to transaction code FDI4

Select Form Type RFFRRD20 Line item analysis

Give your form name and description

Structure (Two axis) - as defaulted

Click on Create

You will have lead column

Delete the rows 2, 3 and 4

Double click on column 1

Enter the customer numbers from 1 to 999999

First column double click (A)

Slelect following values

Due date analysis 1

Days for net due date 0 to 30

Give the short name, medium name and long text for the column.

Repeat this step in next columns like 31 to 60, 61 to 90, 91 to 120 and 121 to 99999 days etc in other columns and select due date analysis 1. (B,C,D,E)

Create one more column by way of formula. To create a new column you need to double click on blue line. Put formula add all five columns you have created above. (F = ABCDE)

You prepare one more column with

Due date analysis 2 (G)

Now you prepare one more column add (F+G) = This will be total open items = over due and not due.

Now go to FDI1 and prepare a report - assign the form created in FDI4 to the report.

Characteristics you need to select are

Account Type (Select Account Type as D for customers)

Currency

Customer

Document Type

Special G/L Ind

Company Code

Change the output types and options according to your requirement.

Refer FDI2 and FDI3 for other standard reports created.

Refer FDI5 and FDI6 for other standard forms created.

Save your report and execute.

Regards,

Ravi

[Former Member]

Hi Ravi,

Thanks for given complet detail for Customer aging report. I have maintain through FDI4 and also maintain FDI2. When i extract the aging report through FDI3 system is showing total amount. we need customer wise report( customer code/name wise report.) I follow your step which you have mentioned in your early reply. Please advice where i did mistake at the time develop the report.

Regards,

Pankaj

[Former Member]

Hi,

You can use t.code FDI3 for customer aging report and develop with the help of ABAP. It is best t.code and mostly company extract the aging report through it.

Regards,

Pankaj

[Keshi1]

Hi

Use SAP standard report S_ALR_87012168 - Due Date Analysis for Open Items

Kesh