Skip to Content
avatar image
Former Member

Want to make trial balance even for few days report painter

My company need trial balance from system even for some days. Like Date 12.09.2013  to 23.09.2013.

I have created such report with help of ABAPer. But in my recent interview i have been asked from Accenture that why do not you make this report thru Report painter.

can anyone suggest in this regard that which tcode (report painter tcode) can be used to create such report.

main problem here is to consider data from 01.09.2013 to 11.09.2013 be part of opening balance.

Format of trial balance required is

Dr opening balance | Cr opening balance |  Dr for period 12.09.2013  to 23.09.2013 | Cr for 12.09.2013  to 23.09.2013 |  Total Dr         |      Total Cr

Can we achieve this thru Report painter

Atleast from Accenture someone should answer it

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 10, 2013 at 06:13 PM

    Hi Sanjeev,

    Please find below document which may help you for better understanding report painter.

    Financial Statement Analysis by using Report Painter

    Vendor Aging Analysis Through SAP Report Painter

    Regards,

    Prasad

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 11, 2013 at 03:14 AM

    Pls any expert at least answer it as to is it really possible or not thru report painter and ABAP is only way.

    If such things are not really possible in system then why interviewers ask such questions.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 11, 2013 at 02:36 PM

    Transaction code for Trial Balance is S_ALR_87012310

    Here go to click dynamic selections ((Shift+F4) and select Posting date and document date etc.

    Try same way for any other transaction code you are using.

    Thanks

    Srinivas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I know it is a very old thread, just wanted to know is it ECC 6. 04

      I think this is not available in ECC 6.0

      Regards,

      SNM

  • avatar image
    Former Member
    Jun 03, 2016 at 10:16 AM

    Hi

    We all have been tracking document of Sharifuddin for but its not available. I have implemented exactly the same requirement through ABAP Report.(Report Painter Output was very slow). If anybody needs it, i will be happy to share the logic and code if needed that gives output in a ALV Report format.

    Regards

    Saurabh Sharma

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      Of course, you also can make a report a cut off date as an instance

      28.05 2016

      taking data:

      balance carry forward plus 01 - 04

      and take date from 01.05 - 28-05 from BSEG

      You also can use BSEG instead of FAGLFLEXA when using SAP nGL.

      BSEG = entry view.

      FAGL*A = GL view.

      concerning balances per balance sheet account is on variance.

      all the best erwin