1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Not Working with Tally 9 Release 2.14

Discussion in 'Free Source Codes' started by M. Sajid Razzaq, Mar 1, 2023.

    
  1. M. Sajid Razzaq

    M. Sajid Razzaq Member


    [#Field:EI COnsignee]
    Delete:Table
    Add:Table:MyLedgerColl

    [Collection:MyLedgerColl]

    Use : Alias Collection
    Title : $$LocaleString:"List of Ledger"
    Type : Ledger
    Fetch : Name
    Report : Ledger
    Variable : LLedger
    Trigger : LLedger
    IsODBCTable : Yes
    Add : SubTitle : $$LocaleString:"Ledger Name","Parent Group"
    Add :Format :$Parent
    Fetch:parent


    but working with Tally Erp9, Please help
     
    M. Sajid Razzaq, Mar 1, 2023
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Nothing wrong with the code, it should work......... problem is from somewhere else.
     
    Amit Kamdar, Mar 1, 2023
    #2
    M. Sajid Razzaq likes this.


  3. Mahesh Sethi

    Mahesh Sethi Member


    Hi every One,

    Also Try This ..... Its perfect working in prime also. But End of List is not shown
    can any one solve it. where i am going wrong.

    [#Field: ACLSLed]
    Delete:Table
    Add:Table:MyLedgerColl
     
    Last edited: Mar 1, 2023
    Mahesh Sethi, Mar 1, 2023
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There is NO "EndOfList" in the original either............ and it is not required either, because it is a single selection list only............ "EndOfList" is needed where there are multiple selections from the list.

    If one requires than simply add the system table -- Table EndofList before the new Table name.
     
    Amit Kamdar, Mar 1, 2023
    #4


  5. M. Sajid Razzaq

    M. Sajid Razzaq Member


    Dear Sir, somewhere else mean
     
    M. Sajid Razzaq, Mar 2, 2023
    #5


  6. Mahesh Sethi

    Mahesh Sethi Member



    Dear Admin,

    Thanks for your replay. pls suggest me how i fetch the UDF Value. Code & Screen shoot is as under:

    [System : UDF]

    FathNam : String : 10001
    MotherNam: String : 10008
    RoNo : String : 10002
    Birth Date : Date : 10003
    Bat : String : 10004
    Cour : String : 10005
    AcYr : String : 10006
    Gen : String : 10007


    ;;======================
    [#Field: ACLSLed]
    Delete:Table
    Add:Table:MyLedgerColl


    [#Field:EI COnsignee]
    Delete:Table
    Add:Table:MyLedgerColl

    [Collection:MyLedgerColl]

    Use : Alias Collection,Table EndofList
    Title : $$LocaleString:"List of Ledger"
    Type : Ledger
    Fetch : Name
    Report : Ledger
    Variable : LLedger
    Trigger : LLedger
    IsODBCTable : Yes
    Add : SubTitle : $$LocaleString:"Ledger Name", ;;"Parent Group"
    Add :Format :$FathNam,$Parent
    Fetch:parent,FathNam

    [#Collection: Master Name Format]
    Format : $Parent, 27
    ;; Format : $Parest, 36
     

    Attached Files:

    Last edited: Mar 2, 2023
    Mahesh Sethi, Mar 2, 2023
    #6


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There is no code attached...........
    Simply add the UDF to the collection List.
     
    Amit Kamdar, Mar 2, 2023
    #7


  8. Mahesh Sethi

    Mahesh Sethi Member



    Dear Admin,

    Thanks for your replay. pls suggest me how i fetch the UDF Value. Code & Screen shoot is as under:

    [System : UDF]

    FathNam : String : 10001
    MotherNam: String : 10008
    RoNo : String : 10002
    Birth Date : Date : 10003
    Bat : String : 10004
    Cour : String : 10005
    AcYr : String : 10006
    Gen : String : 10007


    ;;======================
    [#Field: ACLSLed]
    Delete:Table
    Add:Table:MyLedgerColl


    [#Field:EI COnsignee]
    Delete:Table
    Add:Table:MyLedgerColl

    [Collection:MyLedgerColl]

    Use : Alias Collection,Table EndofList
    Title : $$LocaleString:"List of Ledger"
    Type : Ledger
    Fetch : Name
    Report : Ledger
    Variable : LLedger
    Trigger : LLedger
    IsODBCTable : Yes
    Add : SubTitle : $$LocaleString:"Ledger Name", ;;"Parent Group"
    Add :Format :$FathNam,$Parent
    Fetch:parent,FathNam

    [#Collection: Master Name Format]
    Format : $Parent, 27
    ;; Format : $Parest, 36
     
    Mahesh Sethi, Mar 2, 2023
    #8


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Kindly give proper information........ where is the UDF defined? in master?? in Voucher? in other Reports??

    accordingly, if you want it in the Voucher, then you need to define in the respective OBJECT ..... in this case it will be Object : Ledger Entry ...........
     
    Amit Kamdar, Mar 2, 2023
    #9


  10. Mahesh Sethi

    Mahesh Sethi Member


    Res. Sir,

    Thanks for your replay. I use UDF in Ledger Master.
    Screen shoot as under:

    upload_2023-3-2_9-11-16.png
     
    Mahesh Sethi, Mar 2, 2023
    #10


  11. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Then define in Object : Ledger all your UDFs and then call for it in other reports.
     
    Amit Kamdar, Mar 3, 2023
    #11


  12. Mahesh Sethi

    Mahesh Sethi Member


    Sir Can you pls give me example.

    Thanks for your valuable replay.

    Mani
     
    Mahesh Sethi, Mar 3, 2023
    #12


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Object : ledger]
    newudf : $FathNam .... and so on

    then fetch and call for $newudf in your report.
     
    Amit Kamdar, Mar 3, 2023
    #13


  14. Mahesh Sethi

    Mahesh Sethi Member


    Sir,

    Not Done.

    [#Field: ACLSLed]
    Delete:Table
    Add:Table:MyLedgerColl


    [#Field:EI COnsignee]
    Delete:Table
    Add:Table:MyLedgerColl

    [Collection:MyLedgerColl]

    Use : Alias Collection,Table EndofList
    Title : $$LocaleString:"List of Ledger"
    Type : Ledger
    Fetch : Name,fathnam
    Report : Ledger
    Variable : LLedger
    Trigger : LLedger
    IsODBCTable : Yes
    Add : SubTitle : $$LocaleString:"Ledger Name", ;;"Parent Group"
    Add :Format :$newudfathnam,$Parent
    Fetch:parent ;;,newudfathnam

    [#Collection: Master Name Format]
    Format : $newudfathnam, 18
    Format : $Parent, 27




    upload_2023-2-27_11-43-36.png

    upload_2023-2-27_11-43-55.png
     
    Mahesh Sethi, Mar 3, 2023
    #14


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    fetch : newudffathnam
     
    Amit Kamdar, Mar 3, 2023
    #15


  16. Mahesh Sethi

    Mahesh Sethi Member


    [#Field: ACLSLed]
    Delete:Table
    Add:Table:MyLedgerColl
    [#Field:EI COnsignee]
    Delete:Table
    Add:Table:MyLedgerColl
    [Collection:MyLedgerColl]
    Use : Alias Collection,Table EndofList
    Title : $$LocaleString:"List of Ledger"
    Type : Ledger
    Fetch : Name,NewudfFathNam ;;fathnam
    Report : Ledger
    Variable : LLedger
    Trigger : LLedger
    IsODBCTable : Yes
    Add : SubTitle : $$LocaleString:"Ledger Name", ;;"Parent Group"
    Add :Format :$NewudfFathNam,
    Add :Format :$Parent
    Fetch:parent ,NewudfFathNam
    [#Collection: Master Name Format]
    Format : $newudffathnam, 27
    Format : $Parent, 27


    Thanks a Lot Sir. In Your kind guidance i am able to create school module & almost i succeed at list 50% can i send you the complete project to your supper guidance & give me tips to add best features.

    Thanks in Advance.

    Mani
     
    Mahesh Sethi, Mar 3, 2023
    #16


Share This Page