Skip to Content
author's profile photo Dan Sullivan
0
Dan Sullivan

What table to use for report painter trial balance report by document type?

Posted on Jun 27, 2016 at 08:04 PM 488 Views

We need a trial balance report with columns by document type but cannot find a table for this.

Any help with this is greatly appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2016 at 02:55 PM
    1

    Hi Dan,

    Since document type is not included in the standard ledger, you may have to define a custom ledger (kind of a SPL solution) and include Document type and other fields you would like to have. That may be an alternative.

    Thanks,

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Erwin Leitner
    Erwin Leitner
    Posted on Jun 28, 2016 at 02:28 PM
    1

    Hello,

    For balance sheet report total tables are relevant:

    GLT0 (classical GL)

    Faglflext (SAP nGL)

    at total tables we do not have document type available.

    Developing Z* report might be helpful.

    If you just need a total per account you can use:

    GLT0 for balance carry forward values

    BSEG for current year values

    Balance carry forward + current year = total today.

    additionally you have to add BKPF table for document type per document/GL account.

    br erwin

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Jun 27, 2016 at 09:40 PM
    0

    I have not seen that kind of wish on the report painter. report painter isusing faglflext tables for this kind of reports and these tables is the totals table so in you requirement you want to summerize the documents based on the document type instead of account or you want to see the document posting during a period. Maybe journal canhelp you

    try reports :

    S_ALR_87012282 AND S_ALR_87012287

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

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.