GL BALANCES DATE WISE

[Former Member]

Hi All,

Is there any T.Code for that I want to know the GL Balances on a particular date <b>not period wise</b>.

BSR

[Former Member]

Hi,

Kindly execute Tcode FS10N

Thanks & Regards,

Satheesh K

[raheem_baksh]

Hi ,

You can refer this link G/L Opening/Closing Balance as on Key Date

Regards

Raheem

[former_member612567]

HI experts..,

    Even am working on FI report,

where i need to calculate the G/L account opening  balance on a daily basis,

afteer I search for long time... i found

BAPI_AR_ACC_GETKEYDATEBALANCE gives  "Customer account balance at a key date"

but i want " GL  account balance(opening balance) at a key date"

in BAPI_AR_ACC_GETKEYDATEBALANCE, By replacing

tables : BSID    WITH    BSIS,

         BSAD    WITH    BSAS,

IMPORT: CUSTOMER(KUNNR)       WITH      GLACCOUNT(HKONT).

WHAT OTHER CHANGES DO I NEED TO DO....

please help me out.

OR ELSE TELL ME is there any other way to do this.. with some sample report or logic to claculate the opening  balance day wise.

[Former Member]

Hi,

Please check this link

http://scn.sap.com/docs/DOC-33486

Thanks,

Sharif

[Former Member]

Hi,

You can get the balances by BSEG table. Go to se16, give the required information and the key date on which you require the balances and execute. I think this will solve your purpose. You can get the report in ALV format and can download it to excel also.

Reward points if it helps.

[Former Member]

Hi BSR,

Try these reports:

1. Structured Account Balances (Balance Sheet & P&L Account in FS Version Format) S_ALR_87012279

2. GL Account Balances (Totals & Balances ) S_ALR_87012301

3. GL Line Items S_ALR_87012282

4. Statements for GL Accounts, Customers & Vendors S_ALR_87012332

5. Document Journal S_ALR_87012287

6. Compact Document Journal S_ALR_87012289

7. Line Item Journal S_ALR_87012291

8. Display of Changed Documents S_ALR_87012293

9. Invoice Numbers assigned Twice S_ALR_87012341

10. Gaps in Document Number Assignments S_ALR_87012342

11. Posting Totals Document Type wise S_ALR_87012344

12. Recurring Entry Documents S_ALR_87012346

Satish

Assign points if useful

[Former Member]

FBL3N. You can view the balances of all the open / cleared items GL wise.

Prakash

[Former Member]

HI,

I am working on FI report, where i need to calculate the G/L account closing balance on a daily basis, which will be used as the opening balance for the next day, please help me out with some sample report or logic to claculate the closing balance day wise.

u can mail me to :soyunee@gawab.com

Regards

Soyunee.

[Former Member]

HI,

I am working on FI report, where i need to calculate the G/L account closing balance on a daily basis, which will be used as the opening balance for the next day, please help me out with some sample report or logic to claculate the closing balance day wise.

u can mail me to :soyunee@gawab.com

Regards

Soyunee.

[former_member612567]

HI experts..,

    Even am working on FI report,

where i need to calculate the G/L account opening  balance on a daily basis,

afteer I search for long time... i found

BAPI_AR_ACC_GETKEYDATEBALANCE gives  "Customer account balance at a key date"

but i want " GL  account balance(opening balance) at a key date"

in BAPI_AR_ACC_GETKEYDATEBALANCE, By replacing

tables : BSID    WITH    BSIS,

         BSAD    WITH    BSAS,

IMPORT: CUSTOMER(KUNNR)       WITH      GLACCOUNT(HKONT).

WHAT OTHER CHANGES DO I NEED TO DO....

please help me out.

OR ELSE TELL ME is there any other way to do this.. with some sample report or logic to claculate the opening  balance day wise.

[Former Member]

Hi Soyunee,

use the function module BAPI_GL_ACC_GETPERIODBALANCES to get the balance period wise.

and use that logic Go to BKPF table pass BUKRS, GJAHR and BUDAT to get BELNR.

Go to BSEG table pass BKPF-BELNR, BUKRS, GJAHR and HKONT to get DMBTR.

Add that DMBTR to function module BAPI_GL_ACC_GETPERIODBALANCES to get the opening balance of the GL. Ex: you have to run the report on mid of the month, at the time you got the closing balance of the previous month and you didn't know about the balance of the remaining 15 days for current month. in this case it's helpful for you.

[Former Member]

hi BSR,

got to Tcode FBL3n for the GL Line item display.....

on the particular date u can see the balance of the particular GL account.. without period.

Assign the points...

Ranjit

[Former Member]

Sir,

I want to see the trial balance on date wise . Can anybody help how to view.

BSR

[srinivasarao_kambala4]

Hi,

   Use the T code (F.08) OR (S_ALR_87012277)

Regards

Raji.ch