Explode Balance Sheet/P & L to maximum

Discussion in 'Free Source Codes' started by SANTHOSH C KURIAN, Mar 29, 2016.

         
  1. Kirandineshjoshi

    Kirandineshjoshi New Member


    Hello sir if i dont want Sundry creditors and Sundry Debtors expand in Balance sheet if i will print my balance sheet will print 5 to 6 pages so pls help me

    my email id is kiranjoshi@live.in everything is best but

    so pls mail me without fail pls

    thanks
     


  2. Kirandineshjoshi

    Kirandineshjoshi New Member


    how can i hide some option if i dont want to expand that
     

    Attached Files:



  3. Ajitsinh Babariya

    Ajitsinh Babariya New Member


    Dear Sir, Your TDL is Superb !!!!

    Thank you so much.
     


  4. Apoorva Jain

    Apoorva Jain New Member


    Dear Santosh Ji,


    This code is really appreciable. I need to explode the Trial Balance in the same manner. How can we do so. Can you please help for that too.


    With Regards
    Apoorva



     


  5. VijayBach

    VijayBach New Member


    Sir, Your code for BS & PL exploding is EXCELLENT...
    But I am facing a problem in Print to PDF of the exploded BS..I have attached a Screenshot as well as PDF of the said BS. As you can see the Screenshot displays the exploded fields along with the values, but the PDF shows the fields and not the respective values !!!!!

    Please HELP !!!
    Vijay (bach.vijay@gmail.com)
     

    Attached Files:



  6. Shreyansh Jindal

    Shreyansh Jindal New Member


    Hey can you please repost or send the TDL.
     


  7. s.santhnam

    s.santhnam New Member


    THANK YOU SO MUCH
     


  8. udaya

    udaya Member


    sir i can't see the code or file all ur post .....Why?????
     


  9. Jay kumar tailor

    Jay kumar tailor Active Member


    Dear udaya,
    Search Forum For ..........
    Already available.

    code facilitates the following: -

    01. Removes zero valued items from BS & PL
    02. Apart from the default Detailed Mode (Alt + F1) in tally, it explodes BS & Pl to the extreme end
    03. The Explosion is shown in red color
    04. The Explosion can be controlled in F12 configuration in BS & PL
    05. The Exploded BS & PL can be printed and exported
    06. The print of BS & PL will be in continuous mode to save pages

    After installing this code, open BS or PL ----- Press Alt + F1 you will get normal tally explosion........
    Go to F12 Configuration enable "Maximum explode by CKS" to "YES" and you will get the ultimate explosion with print-ability

    [#Report: Balance Sheet]
    Add:Set:SVBSExcludePrtZeroClBal:Yes

    [#Report: Profit and Loss]
    Add:Set:SVBSExcludePrtZeroClBal:Yes

    ;;The below code is to rewrite the default explosion to add maximum explosion


    [#Part:BSGRP Explosion]
    Lines:BS Detail
    Repeat:BS Detail:BS GroupLedgerChildOfGroupName
    Scroll:Vertical
    Local:Line:BSDetail:Delete:Explode
    Local:Line:BSDetail:Add:Explode:CKSExplode:$$IsGroup AND ##CKFlag
    Local:Line:BSDetail:Delete:Space Top

    ;;The code is to define a new variable

    [Variable: CKFlag]
    Type:Logical
    Volatile:No

    [System:Variables]
    CKFlag:No

    ;;Below code is to perform a maximum explosion with red color - CKS

    [Part:CKSExplode]
    Lines:BS Detail
    Repeat:BS Detail:BS GroupLedgerChildOfGroupName
    Scroll:Vertical
    Local:Line:BSDetail:Delete:Space Top
    Local:Field:Default:Color:"Red"

    ;;This is to make sub amounts printable - CKS


    [#Field: BSSubAmt]
    Delete:Set as
    Add:Set as:if $$ExplodeLevel = 0 then $$AsAmount:0 else +
    if $IsLedgerProfit then @AsProfitVal else +
    if $$Owner:$IsStockLine then @AsItemVal else +
    if @@IsWkgCapItem then @UseWkgCapVal else +
    $$SignedAmount:mad:SetVal:mad:SignType

    ;;Below code is to add variable modification in BS/PL Configs - CKS

    [#Part: BSCFG Common]
    Add:Line:At End:CKSExpl

    [#Part: PLCFG Common]
    Add:Line:At End:CKSExpl

    [Line:CKSExpl]
    Field:Medium Prompt, CKSExplFld
    Local:Field:Medium Prompt:Info:$$LocaleString:"Maximum Explode by CKS ?"
    Local:Field:Medium Prompt:Color:"Red"

    [Field: CKSExplFld]
    Use:Logical Field
    Set:##CKFlag
    Set always:Yes
    Modifies:CKFlag : Yes
    Show Table:Always
    Color:"Red"

    ;;Following code is to realign page separation - CKS

    [#Line: PLDetail]
    Delete:Next Page

    [#Line: BSDetail]
    Delete:Next Page
     
    Frz likes this.


  10. udaya

    udaya Member


    Thanaaaaaaank U sir.....
     


  11. Bipin Damania

    Bipin Damania Member


    Hello Santhosh & Jay Kumar

    Thank you for sharing
    But
    Not getting amount in Explode Balance Sheet & Profit & Loss A/c
    Please refer to attached PDF for your reference
    Please reply.

    Thanks
     

    Attached Files:




  12. can u
    share the code with me at alberoply@gmail.com
     


  13. CHANDRESH GAUR

    CHANDRESH GAUR New Member



    Just Comment this
    ;[#Field: BSSubAmt]
    ;Delete:Set as
    ;Add:Set as:if $$ExplodeLevel = 0 then $$AsAmount:0 else +
    ;if $IsLedgerProfit then @AsProfitVal else +
    ;if $$Owner:$IsStockLine then @AsItemVal else +
    ;if @@IsWkgCapItem then @UseWkgCapVal else +
    ;$$SignedAmount:mad:SetVal:mad:SignType


    it is working fine
     


Share This Page