1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

TDL For GST % - HSN Code & Stock item wise HSN Codes Display in Voucher Entry

Discussion in 'Free Source Codes' started by VRS, Sep 9, 2017.

    
Tags:
Page 3 of 3
  1. Iyer

    Iyer Member




    sorry sir it is showing same error sir




    upload_2018-11-30_1-9-22.png
     
    Iyer, Nov 30, 2018
    #51


  2. Iyer

    Iyer Member



    sir am using tally erp 6.4.9
     
    Iyer, Nov 30, 2018
    #52


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    use extension also......like HSN.txt or HSN.tdl
     
    Amit Kamdar, Nov 30, 2018
    #53
    Iyer likes this.


  4. Iyer

    Iyer Member


    sir still same not working. require your help to view th same through team viewer
     
    Iyer, Nov 30, 2018
    #54


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    No buddy.... i never connect online or view online either.......... that is my safety strategy.... so you wait till some other member can do it and help you out.
     
    Amit Kamdar, Nov 30, 2018
    #55


  6. Iyer

    Iyer Member


    ok sir thanks a lot sir as always
     
    Iyer, Nov 30, 2018
    #56


  7. Avrt Technologies

    Avrt Technologies New Member


    Can you able to find the HSN file in d:\program files\tally\tally.erp9\tdl.
     
    Avrt Technologies, Dec 1, 2018
    #57


  8. hprahul

    hprahul Member


    Please copy the code to the given path in file called HSN.

    I feel this can be only issue as per screen shot.
     
    hprahul, Dec 1, 2018
    #58


  9. Iyer

    Iyer Member


    yes sir its in the folder only sir
     
    Iyer, Dec 1, 2018
    #59


  10. Avrt Technologies

    Avrt Technologies New Member


    Go to run command in windows and type that hsn file path and press enter. If windows doesn't the file doesn't exist error then u can copy that path and paste it in tally app. Tdl path field and check it.
     
    Avrt Technologies, Dec 1, 2018
    #60
    Iyer likes this.


  11. Iyer

    Iyer Member



    upload_2018-12-1_10-58-26.png

    upload_2018-12-1_10-59-2.png

    in stock summary not able view sir
     
    Iyer, Dec 2, 2018
    #61


  12. Avrt Technologies

    Avrt Technologies New Member


    I don't know the functionality of the HSN tdl file. Can you share the file. So that i can assist you further.
     
    Avrt Technologies, Dec 2, 2018
    #62


  13. Iyer

    Iyer Member



    Ok sir how to share the file sir
     
    Iyer, Dec 2, 2018
    #63


  14. Avrt Technologies

    Avrt Technologies New Member

    Avrt Technologies, Dec 2, 2018
    #64


  15. Iyer

    Iyer Member








    ;;======TO SHOW IGST RATE & HSN CODE IN SALES & PURCHASE VOUCHER ONLY FOR DISPLAY======

    [#Line : EI ColumnOne]
    Option : Global EI ColumnOne

    [!Line: Global EI ColumnOne]
    Add : Right Fields : At Beginning : IAHSNcodeT, IAMVAT

    [Field : IAHSNCodeT]
    Info : "HSN/SAC Code"
    Align : Centre
    Width : 15
    Style : Small bold

    [Field : IAMVAT]
    Info : "IGST%"
    Align : Centre
    Width : @@NumberWidth
    Style : Small bold

    [#Line : EI ColumnTwo]
    Option : Global EI ColumnTwo

    [!Line: Global EI ColumnTwo]
    Add : Right Fields : At Beginning : IAHSNcodeT, IAMVAT
    Local : Field : IAHSNCodeT : Info : " "
    Local : Field : IAMVAT : Info : " "


    [#Line : EI InvInfo]
    Option : Global EI InvInfo

    [#Line : CI InvInfo]
    Option : Global EI InvInfo

    [!Line: Global EI InvInfo]
    Add : Right Fields : At Beginning : IAHSNCode, IAMVA

    [Field : IAHSNCode]
    Use : Short Name Field
    Set As : $GSTHSNCode:StockItem:$StockItemName
    Align : Centre
    Border : Thin Left Right
    Width : 15
    Skip : YES

    [Field : IAMVA]
    Use : Number Field
    Set As : $GSTIGSTRate:StockItem:$StockItemName
    Format : "NoZero, Percentage"
    Align : Centre
    Border : Thin Left Right
    Skip : YES


    ;;=====HSN-SAC CODE IN VOUCHER ENTRY

    [#Collection: List of Stock Items]

    Use : Alias Collection
    Title : $$LocaleString:"List of Stock Items"
    Type : Stock Item
    Fetch : Name
    Report : Stock Item
    Variable : SStockItem
    Trigger : SStockItem
    IsODBCTable : Yes
    ;;Unique : $StockItemName

    Add :Format :$GSTIGSTRate
    Fetch:GSTIGSTRate

    Add :Format :$GSTHSNCode
    Fetch:GSTHSNCode


    ;;TO SHOW GST DETAILS IN STOCK SUMMARY

    [#Collection: List of Stock Items]
    Add:Sub Title :"Item Name"

    [#Collection: List of Stock Items]
    Add:Sub Title :"GST"
    Add :Format :$GSTIGSTRate
    Fetch:GSTIGSTRate

    [#Collection: List of Stock Items]
    Add:Sub Title :"HSN/SAC"
    Add :Format :$GSTHSNCode
    Fetch:GSTHSNCode


    [#Collection: List of Stock Items]
    Add:Sub Title :"CL Qty"


    ;;=====END OF CODE========
     
    Iyer, Dec 2, 2018
    #65


  16. Avrt Technologies

    Avrt Technologies New Member


    As per above code, i am unable to find the stock summary related collection. Whether you have pasted full code of the HSN tdl.
     
    Avrt Technologies, Dec 2, 2018
    #66


  17. Ankur Goyal

    Ankur Goyal New Member


    this is final code which show hsn and igst rate in stock summary report properly

    ;;TO SHOW GST DETAILS IN STOCK SUMMARY

    [#Collection: List of Stock Items]
    Add:Sub Title :"Item Name"

    [#Collection: List of Stock Items]
    Add:Sub Title :"GST"
    Add :Format :$GSTIGSTRate
    Fetch:GSTIGSTRate

    [#Collection: List of Stock Items]
    Add:Sub Title :"HSN/SAC"
    Add :Format :$GSTHSNCode
    Fetch:GSTHSNCode


    [#Collection: List of Stock Items]
    Add:Sub Title :"CL Qty"

    [#Line: DSPAccLine]
    Option : HSNCodeSS: (##IsStockReport And $$IsStockItem)

    [!Line: HSNCodeSS]
    Add : Field : HSNCodeSS

    [Field: HSNCodeSS]
    Use : DSPDispName
    Set As : $GSTHSNCode
    Style : Small Italic
    Width : 10

    [#Line: DSPAccLine]
    Option : GSTRATESS: (##IsStockReport And $$IsStockItem)

    [!Line: GSTRATESS]
    Add : Field : GSTRATESS

    [Field: GSTRATESS]
    Use : DSPDispName
    Set As : $GSTIGSTRATE
     
    Ankur Goyal, Apr 16, 2019
    #67


  18. Frz

    Frz Member


    Dear All
    as per the above code, the HSN code & GST rate is fetched/displayed only for stock items
    how do we also get the same for the services or SAC
    we need both the codes & rates in invoice


    [!Line: Global EI ColumnTwo]
    Add : Right Fields : At Beginning : IAHSNcodeT, IAMVAT
    Local : Field : IAHSNCodeT : Info : " "
    Local : Field : IAMVAT : Info : " "


    [#Line : EI InvInfo]
    Option : Global EI InvInfo

    [#Line : CI InvInfo]
    Option : Global EI InvInfo

    [!Line: Global EI InvInfo]
    Add : Right Fields : At Beginning : IAHSNCode, IAMVA

    [Field : IAHSNCode]
    Use : Short Name Field
    Set As : $GSTHSNCode:StockItem:$StockItemName => how do we add the collection for SAC here? if item then $GSTHSNCode:StockItem:$StockItemName & if Service then ?
    Rgds
    Frz
     
    Frz, May 2, 2019
    #68


  19. Frz

    Frz Member


    Not getting GST rate & HSN code in stock list
    Gateway of tally>display>item>stock item

    upload_2019-5-9_10-58-6.png

    Rgds
    Frz
     
    Frz, May 9, 2019
    #69


  20. udaya

    udaya Active Member


    Friends.... please load TDL and close Tally and open again... it will work fine

    The new Small Enhancement in this Code.... Enjoy....

    ;;TO SHOW GST DETAILS IN STOCK SUMMARY

    [#Collection: List of Stock Items]
    Add:Sub Title :"Item Name"

    [#Collection: List of Stock Items]
    Add:Sub Title :"GST"
    Add :Format :$GSTIGSTRate,20
    Fetch:GSTIGSTRate

    [#Collection: List of Stock Items]
    Add:Sub Title :"HSN/SAC"
    Add :Format :$GSTHSNCode,8
    Fetch:GSTHSNCode


    [#Collection: List of Stock Items]
    Add:Sub Title :"CL Qty"

    [#Line: DSPAccLine]
    Option : HSNCodeSS: (##IsStockReport And $$IsStockItem)

    [!Line: HSNCodeSS]
    Add : Field : HSNCodeSS

    [Field: HSNCodeSS]
    Use : DSPDispName
    Set As : $GSTHSNCode
    Style : Small Italic
    Width : 10

    [#Line: DSPAccLine]
    Option : GSTRATESS: (##IsStockReport And $$IsStockItem)

    [!Line: GSTRATESS]
    Add : Field : GSTRATESS

    [Field: GSTRATESS]
    Use : DSPDispName
    Set As : $GSTIGSTRATE
     
    udaya, Mar 9, 2020
    #70


  21. udaya

    udaya Active Member


    lisenh.jpg
     
    udaya, Mar 9, 2020
    #71


  22. jgkumar1976

    jgkumar1976 Member


    upload_2020-3-10_22-19-2.png
     
    jgkumar1976, Mar 10, 2020
    #72


  23. kumar vaibhav

    kumar vaibhav New Member


    Thank you for the code.. however i have another TDL installed for adding Serial Number in Invoices. When i install your TDL, there seems to be conflict between the two tdl's.
    Please help me resolve this.. i am sharing the code of the other TDL as well... it would be greate if you can helo me implement the Serial Number ,HSN Code and Tax Rate in one TDL






    [#Line : EI ColumnOne]
    Option: Global EI ColumnOne

    [!Line: Global EI ColumnOne]
    add: fields: before:VCH ItemTitle : VCH srNO
    [field: vch srno]
    use:name field
    setas: "SR.NO"
    width :8
    style:normal bold
    skip : Yes
    Color : "White"
    Background : "Blue"


    [#Line : EI InvInfo]
    Option : Global EI InvInfo

    [#Line : CI InvInfo]
    Option : Global EI InvInfo

    [!Line: Global EI InvInfo]
    add: fields:before: VCH StockItem : vchslno1
    [field:vchslno1]
    Set as:$$Line
    skip : Yes
     
    kumar vaibhav, Apr 5, 2020
    #73


Page 3 of 3

Share This Page