Skip to Content
author's profile photo Former Member
Former Member

Gl report requirement

Hi All ,

We have a requirement as mentioned below ,could you please help me out , I thought FS10N will help me out

but FS10N does not allow company codes with different currencies.

requirement :

A REPORT NEEDS TO BE DESIGNED TO CAPTURE ALL TRANSACTIONS IN GENERAL LEDGER CODES : XXXXXXX AND XXXXXXX FOR ALL COUNTRIES AND LEGAL ENTITIES (COMPANY CODES) in a specific region for example Asia region.

Points guaranteed , please let me know

Thanks

Aryan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2009 at 04:27 PM

    This forum is for Asset Accounting. Please post your question is the appropriate forum.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2009 at 04:43 PM

    Aryan,

    I think you could try this report:S_ALR_87012301 - Totals and Balances. Eventough it does not look like FS10N that it shows the information in such a way you may appreciate.

    One potential issue you would face with this report, is that all company codes you enter must have the same fiscal variant, otherwise it will error out.

    I suggest that you configure, in the selection screen, a detial list layout, where you can subtotalize by currency, company code and or Gl account.

    If this does not fulfill you requirement, and I am afraid that you will end putting together a functional spec for a developer to built a custom report.

    Hope this helps.

    GG

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thankyou Guys , Gustavo and Srinivasa,

      Yes , agree with you , so the proper requirement is , they need a report that will show opening balance , all debits and credits for each company code on a monthly basis ,

      now I know that in FS10N we get to see the Opening balance and the debits and credits but its limitation is , if companys have different currecny then the FS10N does not work and FBL3N just diplays the balance , if it is open item or all cleared item or all items based on the criteria selected, please correct me if I am wrong and hence what I am looking for is , is there

      a standard report which SAP has provided or do we have to develop a Z report which will fulfill the requirement .

      thanks

      Aryan

  • author's profile photo Former Member
    Former Member
    Posted on Aug 07, 2009 at 06:48 AM

    Hi,

    As explained by them is true.

    You cannot run FS10N report for company codes all together in one instance, if your company codes having diff FY variants assigned and having diff LCs maintained.

    I hope you must go for ABAP reports,

    While prparing your func specs the below tables might help you out.

    GL account totals table - GLT0

    and the below for business partner balances report

    Customer totals - KNC1

    Vendor totals - LFC1

    Thanks,

    Srinu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2009 at 07:32 AM

    Hi Guys , I am marking this as closed , thankyou all for your help and support , I have asked them to create a new report .

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.