TallyPrime TDL Enthusiast

Discussion in 'Free Source Codes' started by Nithin Patel, May 6, 2022.

    
  1. Nithin Patel

    Nithin Patel Member


    My New Gateway of Tally for TallyPrime.
    Learned a lot through this forum, Good job experts, keep going New GOT.jpg
    Thanks, n Regards
    nithinpatel
     


  2. Nithin Patel

    Nithin Patel Member



  3. Nithin Patel

    Nithin Patel Member


    Help Needed, Code not executing the results
    I think Error Lies at "Set as : $PartyMailingName"
    plz correct me
    Code:
    [#Line         : DSPVCHAcctitles]
    Add         : Right Field     : Before         : DSPVCHTypeTitle : MailName1
    
    [#Line        : DBTitle1]
    Add         : Right Field     : Before         : DSPVchTypeTitle : MailName1
    [Field         : MailName1]
    Used         : NameField
    Set as         : "Name"
    Style        : Small Bold
    Align        : Centre
    Width        : 25
    Color         : Black
    
    [#Line         : DSPVCHDetail]
    Add         : Right Field     : Before         : DSPVchSuppleCount : MailName
    [Field         : MailName]
    Use         : NameField
    Align        : Left
    Border      : Thin Left Right
    Width         : 25
    Set as        : $PartyMailingName
    Color         : Black
    
    [#Collection: Vouchers of Ledger]
    Fetch        : PartyMailingName
    Compute        : PartyMailingName
     
    Last edited: May 7, 2022


  4. Access

    Access Member


    Fetch : PartyMailingName
     


  5. Nithin Patel

    Nithin Patel Member


    Working in Sales Account (Ledger Vouchers)
    Not Working in Sales Register

    Plz Help!
     
    Last edited: May 11, 2022


  6. Nithin Patel

    Nithin Patel Member


    Code:
    [#Line         : DSPVCHAcctitles]
        Add        : Right Field     : Before         : DSPVCHTypeTitle : MailName1
      
    [#Line        : DBTitle1]
        Add        : Right Field     : Before         : DSPVchTypeTitle : MailName1
      
    [Field         : MailName1]
        Used    : NameField
        Set as    : "Name"
        Style    : Small Bold
        Align    : Centre
        Width    : 25
        Color    : Black
    
    [#Line         : DSPVCHDetail]
    ;;    Add     : Right Field     : Before         : DSPVchType        : MailName
        Add     : Right Field     : Before         : DSPVchSuppleCount : MailName
    [Field         : MailName]
        Use     : NameField
        Align    : Left
        Border  : Thin Left Right
        Width     : 25
        Set as    : $PartyMailingName
        Color     : Black
        Line    : 0
    
    [#Collection: Vouchers of Ledger]
        Fetch     : PartyMailingName
        Compute    : PartyMailingName:$PartyMailingName
    
    [#Line         : DSPVCHAcctitles]
    Add         : Right Field     : Before         : DSPVCHTypeTitle : AGSLVNarration1
    
    [#Line        : DBTitle1]
    Add         : Right Field     : Before         : DSPVchTypeTitle : AGSLVNarration1
    
    [Field         : AGSLVNarration1]
    Used         : NameField
    Set as         : "Narration"
    Style        : Small Bold
    Align        : Centre
    Width         : 25
    Color         : Black
    
    [#Line         : DSPVCHDetail]
    Add         : Right Field     : Before         : DSPVchSuppleCount : AGSLVNarration
    
    [Field         : AGSLVNarration]
    Use         : NameField
    Align        : Left
    Border      : Thin Left Right
    Width         : 25
    Set as         : $Narration
    Color         : Black
    
    [#Collection:Vouchers of Ledger]
    Fetch        : Narration
    Compute        : Narration:$Narration    
     


  7. Nithin Patel

    Nithin Patel Member


    Please Correct me
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [#Collection: Vouchers of Ledger]
    Fetch : PartyMailingName
    Compute : PartyMailingName:$PartyMailingName

    As done in above .... similarly find the Collection for Sales Register and fetch / compute the required details.
     


  9. Nithin Patel

    Nithin Patel Member


    Sir, may i know the definition of Collection for Sales Register
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Open developer ..... go to FORM : Voucher register ........ you will get the part...... choose the appropriate PART and you will get the line........ the LINE would be using a REPEAT..... and there you have the Collection name.
     


  11. Nithin Patel

    Nithin Patel Member


    Sir, while hovering through Developer Mode in sales register it shows "Voucher Register" still coudn't get it right
     


  12. Mahesh Sethi

    Mahesh Sethi Member


    Res. Developer's it show in Day Book not in sales register.


    upload_2023-2-27_12-17-34.png
     


  13. Nithin Patel

    Nithin Patel Member


    Display in Sales Register
    [#Collection: Filtered Vouchers of Company]
    Fetch : PartyMailingName
    Compute : PartyMailingName : $PartyMailingName

    but Day Book shows empty columns
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You can also try this way.....

    Set as : If $$IsEmpty:$PartyLedgername Then $PartyMailingName Else $PartyLedgerName
     


  15. Nithin Patel

    Nithin Patel Member


    Please Help to select default Voucher Class in Sales Voucher Entry

    Code:
    [Collection    : Vsales]
        Type    : Voucher
        ChildOf    : ##SVCurrentDate
        Report    : VSales
        Filter    : VSaleFilt
    
    [System        : Formula]
    Vsalefilt    : $Vouchertypename        = "Sales"
    [Report        : VSales]
        Use        : Voucher
        Set        : SVvouchertype            : "Sales"
        Set        : Origvchtype            : $$Vchtypesales
        Set        : ChgVchSub             : "SALES"              ;;replace with your class
        Set        : ChgVchSub Type   : "GST - SALES"  ;;replace with your class
        Delete    : Form
        Form    : Vsales
    [Form        : Vsales]
        Use        : Voucher
     


  16. Sanjeev S

    Sanjeev S Active Member


    Dear Nithin ji,

    Normally I use following method....

    1. Create a button on Gateway of Tally ... Say Counter1
    2. Add button in Menu
    3. Define a function with series of keys required
    4. Done!!!

    Code:
    [#Menu  : Gateway of Tally]
    add : button : counter1
    
    [button : counter1]
        Title            :     $$LocaleString:"Counter1"
        Key                :    F5
        Action    :     Call        :    Sales Counter1
    
    
    [Function: Sales Counter1]
        010        :        Trigger Key : v,f8,counter1,enter,g,enter
        020        :        Return
     
    Mahesh Sethi and Nithin Patel like this.


  17. Mahesh Sethi

    Mahesh Sethi Member



    Dear Sanjeev Ji,

    Can we use same trigger in menu.

    Thanks in Advance,

    Mani
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    No....
    Menu will have a BUTTON
    Button will call a FUNCTION
    Function will TRIGGER the keys........
     
    Mahesh Sethi likes this.


  19. Nithin Patel

    Nithin Patel Member


    Thanks Sanjeev, your idea was helpful
    In meantime i would also like to know how to apply Voucher class from GOT>Voucher Creation> and selection of Voucher Class through Collection Code in TDL
     


  20. Sanjeev S

    Sanjeev S Active Member


    Dear Sir,

    Simple way is to export the required voucher to xml

    Search ClassName & VouchertypeName.

    Confirm the names and method names

    Use those names in collection filter.

    Sample code .....

    Code:
    [Collection        :    My Class Vouchers]
        Type                     :     Vouchers : VoucherType
        Child of                :     $$VchTypeSales
        Belongs to           :     Yes   
        Fetch                    :     Date,VoucherNumber,VoucherTypeName,Class Name, PartyLedgerName,Amount
    
        Filter                    :    TIClass
       
    
    [System    :    Formula]
        TIClass                    :    $VoucherTypeName = "Sales" and $ClassName = "Tax Invoice"
       
    ;;; Following query can be used at command level
    ;;Select $Date,$VoucherNumber,$VoucherTypeName,$Class Name, $PartyLedgerName,$Amount from MyClassVouchers
    
     


  21. Nithin Patel

    Nithin Patel Member


    ngptallydashboard.jpg
    My New TallyPrime 3.0.1 Gateway of Tally
     


  22. Nithin Patel

    Nithin Patel Member


    Help me to where iam wrong

    [#Form : Sales Color]
    [#Form : Voucher]
    Add : Button : PRINTModeBTN
    [Button : PRINTModeBTN]
    Title : "Print Mode"
    Key : CTRL+P
    Action : Trigger Key : F5,1,"Extra Copy"
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Simple -- Ctrl+P Already defined by Tally -- so cannot be overridden except by deleting THAT button from the Form.
     


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Secondly -- based on your button name -- you want to invoke the Print Report and then trigger some keys ---

    If that so, you need to modify the existing Print button and add your triggers.
     


  25. Nithin Patel

    Nithin Patel Member



Share This Page