Skip to Content
avatar image
Former Member

GL Open Balance

Hello Experts,

I am working on open GL balance conversion and I have to extract the balances of GL balance sheet accounts and our system is in SAP R/3 4.6c.

Could you please let me know what are the tables and the logic that I have to use to get the open GL balance?

Is there any possibility that I can extract the data as of a date rather than month end like balace as of May 22 rather than May 31st?

Any input is much appreciated.

Regards,

Harish R

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Aug 04, 2009 at 05:21 AM

    Hi,

    Do you want a report to see the opening balances of GL on a key date ?

    Regards

    K Khatri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the reply.

      I am looking at writing a query to extract the balances of some 200 odd GL balance sheet accounts. We are on 4.6c and I guess I should use GLT0 to get the balance?

      Regards,

      Harish R

  • avatar image
    Former Member
    Aug 04, 2009 at 05:23 AM

    Hi Harish,

    You can use table table BSIS to get open GL Account balance as on date.

    Regards,

    Santosh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 04, 2009 at 05:55 AM

    Hi,

    If you are doing it through query, then you will need to carry out ABAP coding alongwith the the functional process of query writing. SDF is the logical database, which can be used for your data extract.

    What I would suggest is to go for ABAP development. If you are looking for open balances as on a particular key date, then you can extract the data of BSAS and BSIS table both which are falling on the key date (To be selected by user as we do in FBL3N report).

    If I could not resolve your problem, please let me know for further clarification.

    Thanks & Regards

    K Khatri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      - you could write an extract program or build a query based on GLT0 table

      - unfortunately, it goes by period and not a spefic date

      - again it always shows the period as last period of your fiscal year variant (say 16 if you use standard K4 variant)

      - way to get balance as of a period is to

      a. extract/list the output of glto for a given company code/fiscal year

      b. you would find amounts in 3 currencies - TC, LC and GC

      c. and for each currency - you find BCF (c/f) and amounts for each period

      d. you need to add up BCF and as many columns as you need (if you need for 9/2009, add BCF and next 9 columns for each currency

      - would suggest a abap program.

      Hope this clarifies.

      Rgds.

  • avatar image
    Former Member
    Aug 04, 2009 at 06:50 AM

    Hi,

    If you need open balance, you can surely get it from the logic I gave you (i.e. from BSIS and BSAS table). System will give you balance only for the GL selected in the selection screen by the user. It will not give all line items. You will only get the line item of the selected G/L. No need to go to GLT0 table at all.

    Could I clarify you now?

    Regards

    K Khatri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi all

      Sorry - I only saw this question now, and you hve hopefully found a solution already. If you haven't...

      Surely the easiest way though is to call the FM called BAPI_GL_ACC_GETPERIODBALANCES.

      This BAPI gives you the information for all periods, in a table, much like it appears in FS10N. The balance is one of the columns in the result table ACCOUNT_BALANCES.

      Regards,

      Casper

  • avatar image
    Former Member
    Oct 31, 2009 at 05:51 AM

    Hi Haresh,

    You can use GLT0 table for period selection only. better idea user use BSIS table for GL open Item balances.

    In future you want to migrate the future version this program logic can't copy for new version. In ECC 6.0 GLT0 table changed to FAGLFLEXT table.

    Regards,

    Kishore K

    Add comment
    10|10000 characters needed characters exceeded