Display HSN Code on Sales/Purchase Screen

Discussion in 'Tally.ERP 9' started by divy2281774, Jul 13, 2017.

    
  1. divy2281774

    divy2281774 New Member


    You can watch HSN code with Item name on Sales or Purchase Entry Screen that is inserted by you at the time of item creation. For doing this

    For More info watch this video
     



  2. Dear sir, I am trying to use the TDL, I am able to get the HSN/SAC header in the invoice, but unable to get the codes for the items. Could you please help me?
     


  3. amitkjangid

    amitkjangid New Member


    where is the tdl ?
     


  4. psjain_jal

    psjain_jal Member


    ;;Jai Shree Janesh||Jai Shree Krishna||Jai Narayan||Jai Shree Ram||
    ;*******************************************************************
    ;Objective
    ;Watch HSN code with Item name on Sales & Purchase entry Screen
    ;Author:Deepak Garg
    ;*******************************************************************
    [System:UDF]
    dpk:String:2017
    [#Line: EI ColumnOne]
    Add:Field:After:VCH ItemTitle:VchdhsnA

    [Field:vchdhsnA]
    Width : 5
    SubTitle : Yes
    Setas : $$LocaleString:"HSN/SAC"
    Style : Small Bold
    Align : Center
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
    Skip : Yes
    Fixed : Yes

    [#Field: VCH ItemTitle]
    Width : 36
    [#Part: EI InvInfo]

    Lines : EI InvDetails, EI InvSubTotal
    Repeat : EI InvDetails : Inventory Entries
    BreakOn : $$IsEnd:$StockItemName
    Total : VCH Value

    [#Line: EI InvInfo]
    Add:Field:After:VCH StockItem:VCH Stockhsn
    Local : Field : Stockhsn : Width : 10

    [Field:VCH Stockhsn]
    Use:short prompt
    Set as:$(Stockitem,$stockitem).GstDetails[Last].dpk
    Alignment:Right
    [#Field: GSTTaxHistoryHSN]
    Use : Name Field
    Storage : HSNCode
    Storage : dpk
    Width : 10
    Border : Thin Right
    Inactive: $$IsEmpty:$ApplicableFrom
    Skip : $$IsSysNameEqual:Undefined:#GSTTaxHistoryTypeofSupply
     


  5. Sudheer

    Sudheer New Member


    not working option display but no hsn code
     


  6. SURYA

    SURYA New Member


    Set as:$(Stockitem,$stockitem).GstDetails[Last].dpk
    remove ".dpk" add ".hsncode"
    it will work
     


  7. divy2281774

    divy2281774 New Member


    check again my post... i upload text file
     


  8. divy2281774

    divy2281774 New Member


    check again my post
     


  9. SURYA

    SURYA New Member



    [System:UDF]
    dpk:String:2017

    [#Line: EI ColumnOne]
    Add:Field:After:VCH ItemTitle:VchdhsnA

    [Field:vchdhsnA]
    Width : 8
    SubTitle : Yes
    Setas : $$LocaleString:"HSN/SAC"
    Style : Small Bold
    Align : Center
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType
    Skip : Yes
    Fixed : Yes

    [#Field: VCH ItemTitle]
    Width : 36

    [#Part: EI InvInfo]

    Lines : EI InvDetails, EI InvSubTotal
    Repeat : EI InvDetails : Inventory Entries
    BreakOn : $$IsEnd:$StockItemName
    Total : VCH Value

    [#Line: EI InvInfo]
    Add:Field:After:VCH StockItem:VCH Stockhsn
    Local : Field : Stockhsn : Width : 10

    [Field:VCH Stockhsn]
    Use:short prompt
    Set as:$(Stockitem,$stockitem).GstDetails[Last].hsncode
    Alignment:Right


    [#Field: GSTTaxHistoryHSN]
    Use : Name Field
    Storage : HSNCode
    Storage : dpk
    Width : 10
    Border : Thin Right
    Inactive: $$IsEmpty:$ApplicableFrom
    Skip : $$IsSysNameEqual:Undefined:#GSTTaxHistoryTypeofSupply
     



  10. Dear sir, Please write of code, how to display Item GST Rate in Voucher Purchase & Sales
     


  11. GANESH MAKWANA

    GANESH MAKWANA New Member


    Sir The Code Is Working Only For HSN But Not For SAC.
    if I M Picking Ledger Of Telephone Expense & in That I Have Mention SAC code 9984 Then It is Not Showing as SAC Code For Purchase Entry - Accounting Invoice Type.

    Please Suggest Or Give A Code For This Too Sir.

    upload_2017-8-22_19-29-17.png


    upload_2017-8-22_19-31-51.png
     


  12. ashishwadyekar

    ashishwadyekar New Member


    yes sac is not working . Pls provide the code
     



  13. yes HSN/SAC is not working . Pls provide the new code
     


  14. Prema75

    Prema75 New Member


    For SAC

    Set as:$(Ledger,$LedgerName).GstDetails[Last].hsncode
     


  15. ashishwadyekar

    ashishwadyekar New Member


    please provide code for sac ..
     


  16. ashishwadyekar

    ashishwadyekar New Member


    Dear prema above code is not working can you please provide working txt file.. Of what your saying
     


  17. ashishwadyekar

    ashishwadyekar New Member


    Did you got solution for ur question yet
     


  18. ashishwadyekar

    ashishwadyekar New Member


    Code:
    ;;; OM...
    ;;; BE HAPPY AND KEEP EVERYBODY HAPPY
    
    [#Line  :   EI COLUMNONE]
       
        Option      :   PREM EICOLUMNONE    :   Yes
           
    [!Line  :   PREM EICOLUMNONE]
       
        Add            :   Fields    : At End    : PREM LEDHSNCODETITLE, IAMVAT
    
    [Field  :   PREM LEDHSNCODETITLE]
       
        Info        :   "SAC CODE"
        Width       :   30
        Style       :   SMALL BOLD
        Align       :   Right
    
    [Field : IAMVAT]
        Info    : "IGST%"
        Width       :   30
        Style       :   SMALL BOLD
        Align       :   Right
                   
    
    [#Line  :   EI COLUMNTWO]
       
        Option      :   PREM EICOLUMNTWO   :   Yes
       
    [!Line  :   PREM EICOLUMNTWO]
       
        Add         :   Fields   :   At End   :   PREM LEDHSNCODEDETAIL, IAMVA
        Local        :   Field     :   PREM LEDHSNCODEDETAIL    :   Info    : " "       
        Local       :   Field      :   IAMVA            :   Info     : " "
    
    [#Line  :    EI ACCINFO]
       
        Option      :   PREM  EIACCINFO :   Yes  
    
    [#Line  :    CI ACCINFO]
       
        Option      :   PREM  EIACCINFO :   Yes 
    
    [!Line  :   PREM  EIACCINFO]
       
        Add            :   Left Fields    :    At End : PREM LEDHSNCODEDETAIL, IAMVA
    
    [Field  :   PREM LEDHSNCODEDETAIL]
       
        Use         :   SHORT NAME FIELD
        Set as      :   $(LEDGER,$LEDGERNAME).GSTDETAILS[LA].HSNCODE
        Width       :   20
        Style       :   SMALL BOLD
        Align       :   Center
        Skip        :   Yes
       
    [Field : IAMVA]
        Use         :   SHORT NAME FIELD
        Set as      :   $GSTIGSTRate:$(Ledger,$LEDGERNAME)
        Width       :   20
        Style       :   SMALL BOLD
        Align       :   Center
        Skip        :   Yes
       
    
    
    ;;; BE HAPPY AND KEEP EVERYBODY HAPPY
    ;;; E.O.F



    for code credits goes to prema 75, but itried to modified those code to make display G.S.T % but no reasult,
    sac code able to display
     


  19. jgkumar1976

    jgkumar1976 Member


    info
     

    Attached Files:

    • rt.png
      rt.png
      File size:
      111.4 KB
      Views:
      135


  20. Vijay1025Verma

    Vijay1025Verma New Member


    Codes for Display Item Name (with text wrap), Part Number, HSN/SAC, Taxability and GST Rate on screen while entering Sale/Purchase Voucher in Tally. Also looking to show and print 'Authorized Signatory' and Bank Details Portion only on the last page of voucher, and remaining spaces can be used for the items entry in vouchers.
     


  21. N vinoth

    N vinoth Guest


    This code was helpful for HSN & GST % display on item invoice
     

    Attached Files:

    • HSN.rar
      File size:
      4.2 KB
      Views:
      94


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    There are many variants of this code existing in the forum. One can use it as per their requirements.

    One of the variants gives information in the Collection itself. (when you select the item Name).
     


  23. drive

    drive Active Member


    try this one

    Set as: $GSTItemHSNCodeEx
     


  24. ONKAR

    ONKAR Active Member


    hello guys try this one

    [#Line : EI Column One]
    Add : Right Field: At Beginning:OTSHSNCode
    Add:Right Field: After:OTSHSNCode:OTSGSTPerT

    [Field:OTSGSTPerT]
    Use:Name Field
    Set as: "GST %"
    Skip: Yes
    Border:Thick Left Right
    Width:10
    Align: Center

    [Field:OTSHSNCode]
    Use:Name Field
    Set as: "HSN"
    Skip: Yes
    Border:Thick Left Right
    Width:10
    Align: Center

    [#Line : EI Inv Info]
    Add: Right Field:At Beginning:OTSHSNCodeNo
    Add: Right Field: After: OTSHSNCodeNo: OTSGSTPer

    [Field:OTSHSNCodeNo]
    Use: Name Field
    Set as:$(Stockitem,$stockitem).GstDetails[Last].hsncode
    Width:10
    Align: Center
    Set Always: Yes
    Skip: Yes

    [Field:OTSGSTPer]
    Use: Number Field
    Set as:$(Stockitem,$stockitem).GSTDetails[First].StatewiseDetails[1, @@IsAnyState].RateDetails[1, @@IsIGST].GSTRate
    Format: Percentage
    Width:10
    Align: Center
    Set Always: Yes
    Skip: Yes
     


Share This Page