on 03-16-2009 5:51 AM
Hi All,
In SAP, Agewise Outstanding Report for Vendors report coming with Vendor Master Details along with Address details in the report S_ALR_87012085 - Vendor Payment History with OI Sorted List which is not really required. Hence we need to remove all un necessary details. We need only a signle line report for each vendor like below.
Vendor Code Vendor Name Due - 30 days Due - 60 days Due 90 Days Due 120 days and more than above
The selection of period option is already available in std SAP. We have to change the output report only. This is rquired for Audit purpose.
Please help me in the above issue.
Regards
Vinu
Hello,
Please create a form using FKI4 - refer forms FKI5 and FKI6 for reference.
Assign this form to report in FKI1 - refer standard forms in FKI2 and FKI3 for reference.
Regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
Thanks for the reply.
They dont want drilled report. They want all the line items in one report.
for example.
Report Input
Vendor Code 1 9999999
Company Code 1000
Due Date Sorted List 00 30 60 90 120
Report Output
Vendor Code Vendor Name 01-30 31-60 61-90 91-120 121-9999
1111 AAA xx xx xx xx xxx
2222 BBB xx xx xx xxx
3333 CCC xx xx xx xxx
So how I can do it in FKI1.
Thanks & Regards
Vinu
Hello,
The following example I have given is for customers.
The only difference is in transaction codes. For customer you go to FDI1, for vendor you go to FKI1 (reports).
For Customer you go to FDI4, for vendor you go to FKI4 for forms.
Remaining all are the same.
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
Hi
In S_ALR_87012077 - under due date analysis you can see the vendor wise aging analysis
Thank You,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use both S_ALR_87012078 and S_ALR_87012085
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can get these details as you request in report S_ALR_87012078 - Due Date Analysis for Open Items , Try this out
Kesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
9 | |
5 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.