3 Replies Latest reply: Apr 22, 2009 5:05 AM by Deepak Agrawal RSS

Tcode for Vendor and Customer Trial balance

Deepak Agrawal
Currently Being Moderated

Hi,

 

I want to generate Vendor trial balance & customer trial balance. I want name of each vendor and customer with the normal and special GL balance written against it

 

Ex:

 

Vendor A     -    Rs.100-

Vendor B     -    Rs. 2300-

Vendor C     -    Rs. 1000

.

.

.

.

.

.

Total -- XXXXX -


> This should match with my Vendor Reco account total.

  • Re: Tcode for Vendor and Customer Trial balance
    Currently Being Moderated

    Hi, I think S_ALR_87012172 - Customer Balances in Local Currency and S_ALR_87012082 - Vendor Balances in Local Currency will help you with the required data. Only limitation is, you can't change the layout of the output. There are several selection fields in these reports to use.

  • Re: Tcode for Vendor and Customer Trial balance
    Ravi Sankar Venna
    Currently Being Moderated

    If standard report does not suffice your requirement, then create your own.

     

    FOR vendor USE K in transaction code instead of D.

     

    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

Actions