1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Ledger list with Cost Centre enabled column

Discussion in 'Tally Developer' started by A Sam, Feb 15, 2023.

    
Page 1 of 2
  1. A Sam

    A Sam Member


    Hi all,

    Is there a way to get Ledger list with Cost Centre Enabled Yes/No Column

    Thanks
     
    A Sam, Feb 15, 2023
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    1 - Go to "Chart of Accounts"
    2 - Select Ledgers
    3 - Alt+H - "Multi Masters" -- Select -- "Multi Alter" and then "All Items"

    This will give you the Report --- "Multi Ledger"
    Add your fields in Title and Body...........
    Title field will be a Name field and Body/Data field will be a Logical field......... use ---- $IsCostCentresOn:Ledger:#MultiMasterName to obtain the value in the report.
     
    Amit Kamdar, Feb 15, 2023
    #2


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Capture.PNG
     
    Amit Kamdar, Feb 15, 2023
    #3


  4. A Sam

    A Sam Member


    Could not get the correct tiltles
     
    A Sam, Feb 16, 2023
    #4


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    do not understand your statement. Where is your code?
     
    Amit Kamdar, Feb 16, 2023
    #5


  6. A Sam

    A Sam Member


    [#Line:Multi Master Name Title]
    Add: Right field: before : Multi Master Parent Title
    Local : Field : CC Enabled : Set as : $$LocaleString:"CC Enabled"
    [#Line: Multi Master Name]
    Add:Field:CC Enabled
    [Field: CC Enabled]
    Set as: $IsCostCentresOn:Ledger:#MultiMasterName
     
    A Sam, Feb 16, 2023
    #6


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Line:Multi Master Name Title]
    Add: Right field: before : Multi Master Parent Title : CC Enabled
     
    Amit Kamdar, Feb 16, 2023
    #7


  8. Bipin Damania

    Bipin Damania Active Member


    In Multi Ledger Display

    upload_2023-2-17_16-13-54.png
     
    Bipin Damania, Feb 17, 2023
    #8


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very nice....... :D

    Add to formula...... if Group then "" else value. Also for title, it must appear only for ledgers and not any other master.
     
    Amit Kamdar, Feb 17, 2023
    #9


  10. A Sam

    A Sam Member


    do not work Prime 2.1

    Could not find the default TDL definition of line Multi Master Name Title
     
    Last edited: Feb 18, 2023
    A Sam, Feb 18, 2023
    #10


  11. A Sam

    A Sam Member

    A Sam, Feb 18, 2023
    #11


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It works in 2.1 also...........

    There is no LINE named Multi Master Name Title in default tally. You are referencing the wrong line, find the correct one from developer.
     
    Amit Kamdar, Feb 18, 2023
    #12


  13. Bipin Damania

    Bipin Damania Active Member


    Thank you for your suggestion.

    Title display only in Ledger view.
     
    Bipin Damania, Feb 18, 2023
    #13


  14. Bipin Damania

    Bipin Damania Active Member


    In Multi Ledger Creation & Alteration Report

    CostCenterEnabledField.png
     
    Bipin Damania, Feb 18, 2023
    #14


  15. A Sam

    A Sam Member


    [​IMG]
    This is what shows in developer mode
     

    Attached Files:

    Last edited: Feb 20, 2023
    A Sam, Feb 19, 2023
    #15


  16. Bipin Damania

    Bipin Damania Active Member


    Yes
    In same report after "Under" (Group) add Field for CC Enabled and same with body line, and you will get...
     
    Bipin Damania, Feb 20, 2023
    #16


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    That is a FIELD name............ not the LINE name.
     
    Amit Kamdar, Feb 20, 2023
    #17


  18. A Sam

    A Sam Member


    where I can find line name in developer mode
     
    A Sam, Feb 21, 2023
    #18


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Search for the FIELD in developer........ and you will find the LINE that uses that field........

    Sometimes a common Field is used at multiple places, but you will get the hang of finding the correct report/Form/Part/Line etc......

    I could tell you the LINE name, but that will take away your learning ability.........
     
    Amit Kamdar, Feb 21, 2023
    #19


  20. Mahesh Sethi

    Mahesh Sethi Member


    Bipipn Ji,

    Title is enable but yes/No Option is not getting. Pls guide me.

    Thanks in Advance

    Mani



    [#Line: MLED Titles]
    Add:Right Field: before : Multi Master Parent Title : CC Enabled
    Local : Field : CC Enabled : Set as : $$LocaleString:"CC Enabled"
    [#Line: MLED Body]
    Add:Right Fields:Before: MST Parent: CC Enabled
    [Field: CC Enabled]
    Set as: $IsCostCentresOn:Ledger:#MultiMasterName


    upload_2023-2-21_0-59-33.png
     
    Mahesh Sethi, Feb 21, 2023
    #20


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use : Logical field
     
    Amit Kamdar, Feb 21, 2023
    #21


  22. Bipin Damania

    Bipin Damania Active Member


    Add this at [Field: CC Enabled]
    Use : Logical Field
    Storage : IsCostCentresOn
    Set always : Yes
     
    Bipin Damania, Feb 21, 2023
    #22


  23. Mahesh Sethi

    Mahesh Sethi Member


    Sir Its Give errer

    [Field: CC Enabled]
    Use : Logical Field
    Set as : $IsCostCentresOn:Ledger:#MultiMasterName
    Storage : IsCostCentresOn
    Set always : Yes

    upload_2023-2-21_3-6-45.png
     
    Mahesh Sethi, Feb 21, 2023
    #23


  24. Bipin Damania

    Bipin Damania Active Member


    Remove
    Set as
     
    Bipin Damania, Feb 21, 2023
    #24


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Remove...... Storage line......... it is already a system defined UDF .......... so why use storage again?
     
    Amit Kamdar, Feb 21, 2023
    #25


Page 1 of 2

Share This Page