Balance Sheet

I want tdl code for Balance Sheet display all ledgers upto end level, want expand in detailed format,
how is done with explode ?
using a button it should be expand in detailed. please share and guid tdl code for it.

 

Hi,
You can achive this by using a below code
Hope it will help you.

Code:

;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara
 
[#Part: BSGRP Explosion]
 
    Lines  : BS Detail
    Repeat  : BS Detail : BS GroupLedgerChildOfGroupName
    Scroll  : Vertical
    Local  : Line  : BSDetail: Delete : Explode
    Local    : Line    : BSDetail : Add : Explode : BSGRP Explosion      : $$IsGroup AND (@@IsWkgCapItem OR @@GrpExplodableNew)
    Local  : Line  : BSDetail: Delete : Space Top
           
 
[System : Formula]
        GrpExplodableNew      : $$KeyExplode OR ##ExplodeFlag        

 

WOW..! after a too hard working on this, i have got from you. ITS VERY HELPFULL TO ME AND MY FREINDS.
THANKS A LOT

 

thank you so much.....

 

we can do it for P&L also?

 

This is only display on screen.. Can we print the detailed B/s & P/L ? What further codes to be written.. ?

 

How To Add Print Button & Export Button at Form level.

The Above CODE Display Properly but Do not Print sub group or ledger amount detail.

Please Help.

 

Respected Dinesh Ji,

This code worked fantastic but i have a little issue.

It show all the ledgers but it should show only the ledgers having balance in it.

Suppose i select the balance sheet for the month of April then it should show only the April month legers having transactions in it.

I will be highly obliged if this can be done.

Thank you from bottom of my heart.

Bikash

 

Sir,
I am unable to use Filter properly. Can u kindly help me with This.
Thank Yoy

 

Sir, Kindly Reply.

Where i need to write the code for this.

Bikash

 

Great Work.
Thanks for Sharing.

 

It is very use-full
Thank you.

 

Dear Experts


I enabled to hide alter,delete,cancel button,when i closed the period

for ur refrence i upload the tdl file.

 

Bro here it is...............
[#Part: BSGRP Explosion]

Lines : BS Detail
Scroll : Vertical

Local : Line : BSDetail : Add : Explode : BSGRP Explosion : $$IsGroup AND (@@GrpExplodableNew)
Local : Line : BSDetail: Delete : Space Top
Local : Line : BSDetail :Add: Empty if: $$IsEmpty:$ClosingBalance

[System : Formula]
GrpExplodableNew :$$KeyExplode OR ##ExplodeFlag

 

this is to much good for balance sheet
but this report not coming to print
please add print option

 

can some one give me the balance sheet tdl file as mine is not working..tally throws an error " Part: BSGRP Explosion"

 

Could not understand! Failed Line: 'Line : BS Detail'