Explode Balance Sheet/P & L to maximum

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

    
  1. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    This 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.

    cks

    30/03/16 - It is not my fault, I had already uploaded the file but the website is showing an error message, now too the same happens, so find the code below:
     
    Last edited: Oct 12, 2018


  2. Raj Hundia

    Raj Hundia New Member


    Dear Kurian,
    Can you send me the TDL file for 'Explode Balance Sheet/P & L to maximum' for Tally9 version
    Thanks, Raj
     


  3. psjain_jal

    psjain_jal Member


    where is the code? pl update or upload
     


  4. mpal2311

    mpal2311 Active Member


    Great.
     


  5. Raj Hundia

    Raj Hundia New Member


    Thank you Kurian.
    I am new to TDL and I get this error:
    "Exiting Tally
    Error in TDL.
    'Part:BSGRP Explosion'
    Could not Understand
    Failed Lines: 'Lines:BS Detail'
    File: C:\Tally\bal.txt (Line: 19)

    Please advise
     


  6. kamal

    kamal Member


    Thank you Santhosh Ji
     


  7. NKVINOD

    NKVINOD New Member


    Thank you Santhosh sir
     


  8. priya

    priya Member


    Hi, At the outset, I thank you for the continued research and invention of new TDL. I have tried, as usual, for academic interest your TDL. Although no error has been reported, I am not getting F12 Configuration enable "Maximum explode by CKS" Can you inform me the mistake that I have done. BS opening, default detail mode is functioning; but the F12 configuration, as informed by you is not available. This is a feed back after testing it, so that you can fine tune the TDL. Thank you
     


  9. SANTHOSH C KURIAN

    SANTHOSH C KURIAN Active Member


    Priya kindly check the screen captures, hope you are going to BS Config (F12 on BS) and PL Config (F12 on PL), it is working fine, don't know what problem you are facing, revert with more details..................Thanks

    Sorry screen captures cannot be uploaded since some error is showing by web site.............
     
    Last edited: Apr 4, 2016
    santosh swami likes this.


  10. sayed

    sayed Member


    EDITED - We will not encourage these type of request
     
    Last edited by a moderator: Apr 7, 2016


  11. priya

    priya Member


    Apologies. I got it and fantastic explosion. I like blue than red letters. For Joke only. This is a wonderful TDL and sorry for my ignorance displayed in my earlier observation. Bye Bye
     


  12. mkumar

    mkumar New Member


    thanks a lot
     


  13. Md Hanief Shaik

    Md Hanief Shaik New Member


    Dear Sir,
    Very Nice Programming we find very quality in your Programming i have a purchase process TDL Requirement if you are willing please give me test mail to my mail id
    moretally@hotmail.com
    Thanks in advance,
     


  14. J.Ravi Kumar Rao

    J.Ravi Kumar Rao New Member


    Dear sir,

    really its vey nice looking

    Thanks & Regards
     


  15. VijayBach

    VijayBach New Member


    Sir, Your Code is EXCELLENT !!!! Thanks a lot.
    But could we include THOSE ZERO Valued Ledgers in BalanceSheet which have AT LEAST ONE transaction during the year ???
    Eg.
    I have an FD which matures during the FY. I encash it. Now the value of the FD Ledger is NULL for the year..... So according to our code it will not show in BS. It would become easier to compare previous year's figures !!
    You have DEFINITELY got my point !!!!!!!!!

    Thanks in Advance......
    Vijay.
     


  16. Praveen Davis

    Praveen Davis Member



    Hi Santhosh,

    Its working fine with BL but no effect in P&L !!
     


  17. Shashikant Saini

    Shashikant Saini New Member


    Thank you Santhosh Ji
    And can we explode same in trail balance ?

    Thanks in Advance.....

    Shashi
     


  18. divy2281774

    divy2281774 New Member


    Sir how to expand Sundry Creditor and Debtors in Trial Balance through code
     


  19. nasir

    nasir Member


    can i change the red value alighment
    thanks
    i want to just a little on left side
    thanks
     


  20. divy2281774

    divy2281774 New Member


    in trial balance press ctrl+Enter on sundry debtors group and Set "No" on Groups Behave lika a Sub-Ledger.
    then Press F12 for Expand All Levels in detailed Format.
    It will always show sundry debtors expolded. Same for Sundry Creditor
     


  21. Aliasger

    Aliasger New Member


    Great Upload Kurian ji,
    is there any option by which we remove exploded lines by pressing ALT + R which we want to remove
     


  22. Ankith Agarwala

    Ankith Agarwala New Member


    This is really nice code. Thanks for sharing it
     


  23. Ankith Agarwala

    Ankith Agarwala New Member


    One minor issue is that in B/S, Current assets expands but Current Liabilities are not expanding. Kindly see to that
     


  24. naveen mahawar

    naveen mahawar New Member


    dear Please Help me,
    I want to show in trail Balance showing report ledger name with alias code (Separate Colum) Please help me
     


  25. Drishti Softwares

    Drishti Softwares New Member



Share This Page