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 2 of 3
  1. VRS

    VRS Member


    This is Same File, Which i had posted previously.
    Can i know which changes you had made
     
    VRS, Oct 11, 2017
    #26


  2. Rameshkumar

    Rameshkumar New Member


    Please be clear I am not the developer of this Tdl, I had goot it from other sites , and also from this site after comparing both the tdls, I only made minor change , as the tdl fromthis site was only showing IGST I replase it with GST%, reduce the with from 20 to 10, also I was trying to combine it with GSTin Number tdl but it was not working,
     
    Rameshkumar, Oct 11, 2017
    #27


  3. aryan

    aryan New Member


    http://www.tdlexperts.info/index.ph...m-hsn-code-display-in-voucher-entry-txt.3022/
    Sir
    I tried with above link file sir
    code is as under:
    ;;======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 :$GSTHSNCode
    Fetch:GSTHSNCode

    ;;=====END OF CODE========
     
    aryan, Oct 11, 2017
    #28


  4. aryan

    aryan New Member


    Dear Sir I need Closing Stock report with HSN code & GST rate as below format.

    Item Description HSN Code GST Rate Opening Inward Outward Closing
    Please provide tdl Code for the same
    Thanks & Regards
    Aryan
     
    aryan, Oct 11, 2017
    #29
    JPS Gujral and Rajsrisrimal like this.


  5. Systecg

    Systecg Member


    can you make a filter on a stock item list ?????
    how to ???
    Please Help Admin
     
    Systecg, Nov 13, 2017
    #30


  6. Systecg

    Systecg Member


    can you make a filter on a stock item list ?????
    how to ???
    Please Help Admin
     
    Systecg, Nov 13, 2017
    #31


  7. sirisetty balaji

    sirisetty balaji Member


    Please Help Admin
     

    Attached Files:

    sirisetty balaji, Nov 24, 2017
    #32
    Gopal solanki likes this.


  8. shrikrishna

    shrikrishna New Member


    Hi,

    I am able to see both column on report, but enable to export these value. The xml which I get out of this not contains these two column. Can you please assist why its not coming in report while exporting.

    Thanks in Advance.
     
    shrikrishna, Nov 29, 2017
    #33


  9. rahul nigotiya

    rahul nigotiya New Member


    dear sir,
    i want HSN Code & Stock item wise HSN Codes Display in STOCK SUMMARY also , please help
     
    rahul nigotiya, Jan 1, 2018
    #34


  10. Systecg

    Systecg Member


    9510515803 call me
     
    Systecg, Jan 23, 2018
    #35


  11. Gopal solanki

    Gopal solanki New Member


     
    Gopal solanki, Feb 7, 2018
    #36


  12. amitkjangid

    amitkjangid New Member


    HERE IS THE TDL CODE FOR SHOWING HSN CODE RATE AND PART NO

    ;;======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, PrtNMbr

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

    [Field : IAMVAT]
    Info : "GST%"
    Align : Centre
    Width : @@NumberWidth
    Style : Small bold
    [Field : PrtNNbr]
    Info : "Part No."
    Align : Centre
    Width : 15
    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: PartColumnThree]


    Add : Right Fields : At Beginning : PrtNMbr
    Local : Field : Default : Align : Center

    Local : Field : PrtNMbr : Info : ""

    [#Line: EI InvInfo]

    Option : Part Line : @@IsSales



    [#Line: CI InvInfo]

    Option : Part Line : @@IsSales


    [!Line: Part Line ]

    Add : Right Fields : At Beginning : PrtNMbr




    [#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, PrtNmbr

    [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
    [Field : PrtNMbr ]
    Use : Short Name Field
    width : 12
    Align : center
    Border : Thin Left Right
    Set as : $PartNo:StockItem:$StockItemName
    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========
     
    amitkjangid, Apr 3, 2018
    #37


  13. Systecg

    Systecg Member


    Dear

    we want HSN & Rate in

    Gateway of Tally -> Stock Summary.

    it not Showing in Above Report Can you do something
     
    Systecg, Apr 3, 2018
    #38


  14. Systecg

    Systecg Member


    Dear

    we want HSN & Rate in

    Gateway of Tally -> Stock Summary.

    it not Showing in Above Report Can you do something
     
    Systecg, Apr 3, 2018
    #39


  15. Santosh

    Santosh Member


    Good work!!!!
    But there is one issue :if we type random or any word item related not search in item list. only search item starting first word of item.
    please give suggestion or solution.
    please help...!!!!
     
    Santosh, Jun 11, 2018
    #40


  16. dkp_jal

    dkp_jal Member


    Please give TDL Code to View Item Part Number during Item Voucher Entry.

    Thanks in advance...
     
    dkp_jal, Jul 27, 2018
    #41


  17. S P gupta

    S P gupta New Member


    Sir, I have downloaded the Gst Rate & HSN Code in Voucher.txt file and copied it into the tally.exe folder but it is not working at sales/purchase voucher entry. Please help and guide. Thanks very much in advance.
    spg
     
    S P gupta, Sep 17, 2018
    #42


  18. udaya

    udaya Active Member


    i want only part no..... how?
     
    udaya, Oct 7, 2018
    #43


  19. dipu369

    dipu369 Member


    product code indexing not perfect . problem faced when search items
     
    dipu369, Nov 17, 2018
    #44


  20. udaya

    udaya Active Member


    sir please add "partNo" also best for view in both itel list and sale (or)purchase vouchers....
     
    udaya, Nov 20, 2018
    #45


  21. hprahul

    hprahul Member



    Kindly add following code (to above code) to view HSN in stock summary:
    Code:
    [#Line: DSPAccLine]
    Option : HSNCodeSS: (##IsStockReport And $$IsStockItem)

[!Line: HSNCodeSS]
    Add    : Field    : HSNCodeSS

[Field: HSNCodeSS]
    Use    : DSPDispName
    Set As    : $GSTHSNCode
    Style    : Small Italic
     
    hprahul, Nov 26, 2018
    #46


  22. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Add this code for Gst tax rate on item

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

    [!Line: GSTRATESS]
    Add : Field : GSTRATESS

    [Field: GSTRATESS]
    Use : DSPDispName
    Set As : $GSTIGSTRATE
    Style : Small Italic
    Width : 10
     
    Last edited: Nov 27, 2018
    Jay kumar tailor, Nov 27, 2018
    #47


  23. Iyer

    Iyer Member



    sorry please not working
     
    Iyer, Nov 29, 2018
    #48


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    which version are you using????
     
    Amit Kamdar, Nov 29, 2018
    #49


  25. hprahul

    hprahul Member


    Code:
    ;======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, PrtNMbr

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

[Field : IAMVAT]
Info : "GST%"
Align : Centre
Width : @@NumberWidth
Style : Small bold
[Field : PrtNNbr]
Info : "Part No."
Align : Centre
Width : 15
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: PartColumnThree]


Add : Right Fields : At Beginning : PrtNMbr
Local : Field : Default : Align : Center

Local : Field : PrtNMbr : Info : ""

[#Line: EI InvInfo]

Option : Part Line : @@IsSales



[#Line: CI InvInfo]

Option : Part Line : @@IsSales


[!Line: Part Line ]

Add : Right Fields : At Beginning : PrtNMbr




[#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, PrtNmbr

[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
[Field : PrtNMbr ]
Use : Short Name Field
width : 12
Align : center
Border : Thin Left Right
Set as : $PartNo:StockItem:$StockItemName
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"

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

[!Line: HSNCodeSS]
  Add  : Field  : HSNCodeSS

[Field: HSNCodeSS]
  Use  : DSPDispName
  Set As  : $GSTHSNCode
  Style  : Small Italic
    This is working fine. Jay Ji's Code has some error and needs a fix..
     
    hprahul, Nov 29, 2018
    #50


Page 2 of 3

Share This Page