cancel
Showing results for 
Search instead for 
Did you mean: 

Vendor & Customer balances

Former Member
0 Kudos

Dear Experts,

Is there any transaction available in SAP in order to download vendor and customer balances on specific date. I need to download all the details without any sub total. and with all header and line item details of the document.

i and checked FBL5/FBL3N/FD10N/FK10N (how to avoid sub totals for each vendor/customers?) etc. but i could not get as per my requirement.

regards

Babu.

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member182098
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Surendra.......

Download means what? where do you need to download the Balance list. You mean to export Balance List?

Regards,

Rahul

Former Member
0 Kudos

Hi Rahul,

I need to downloand these details(Vendor/Customer open items and GL balances) from SAP to Excel format.

Regards

Babu..

former_member2342
Active Contributor
0 Kudos

Have you checked S_AC0_52000888 and S_AC0_52000887 These profit center wise reports might be useful.