HSN CODE LIST WITH DESCRIPTION AUTOFILL

Discussion in 'Tally Integration' started by teja varma, Jan 3, 2020.

         
  1. teja varma

    teja varma Active Member


    Hello people
    This is updated version to my previous project HSN CODES LIST (TABLE)
    This contains auto fill of description when you select HSN code
    and have other options (Manual entry of HSN codes and description if it doesn't contain in the existing list) to be added...



     
    Last edited: May 9, 2020
    Deepak Sharma (KNP) likes this.


  2. Bipin Damania

    Bipin Damania Active Member


    Too Good...

    Keep it up...
     


  3. teja varma

    teja varma Active Member


    ;;; Free code
    HSN CODE AND DESCRIPTION MASTER
    ->Option in Main Menu to add HSN codes and DESCRIPTIONS
    ->Press Alt + C at HSN Field to Add HSN CODE and DESCRIPTION

    Code:
    
    ;; HSN CODE AND DESCRIPTION MASTER   
    
    [#Field:GST ClassfnMst Code]
        Table:HsnTableColl,NotApplicable
        Show Table:On Empty
        Key:CREATEUSERHSN
        Tooltip:"Press ALT+ C to Create New HSN Code"
       
    [#Field:GST ClassfnMst Desc]
        Lines:3
        Set Always:Yes
        Set as:$$FilterValue:$DESC:HsnTableColl:1:OnlythatDesc
       
    [System:Formulae]
        OnlythatDesc:$HSN = #GSTClassfnMstCode
    
    [Collection:HsnTableColl]
    Title:$$LocaleString:"List of Hsn Codes"
    Align:Right
    Full Height:Yes
    Source Collection:USERENTERHSNCOLL
    Fetch :Hsn,Desc
    Format:$Hsn,25
    Unique:$HSN
    
    
    
    [Key:CREATEUSERHSN]
        Key:Alt+C
        Action:Alter:HSNMASTERREPORT
        Mode:Edit
    
    ;;;;;;;;;;;;;;;;;;;;;; Report for Storing HSN CODES And DESCRIPTIONS
    
    
    [#Menu:GateWayOfTally]
        Add:Key Item:HSN AND DESC MASTER:H:Alter:HSNMASTERREPORT
    
    [Report:HSNMASTERREPORT]
        Object:Company
        Form:HSNMASTERREPORT
        Title:$$LocaleString:"HSN MASTER CREATION"
       
    [Form:HSNMASTERREPORT]
        Part:HSNMASTERREPORT
        Width:50% page
       
    [Part:HSNMASTERREPORT]
        Line:HSNMASTERREPORTTITLES,HSNMASTERREPORTLINE
        Repeat:HSNMASTERREPORTLINE:USERHSNDESCAGGR
        Scroll:Both
        Break:$$IsEmpty:#HsndataInput
        Background:white
       
    [Line:HSNMASTERREPORTTITLES]
        Field:Name Field,Simple Field
        Border:thickbottom
        Local:Field:Name Field:Info:$$LocaleString:"HSN CODE"
        Local:Field:Simple Field:Set as:$$LocaleString:"DESCRIPTION"
        Local:Field:default:Align:Left
        Local:Field:default:Style:Normal Bold
    
    [Line:HSNMASTERREPORTLINE]
        Fields:HsndataInput,DescdataInput
        Local:Field:default:Align:Left
    
    [Field:HsndataInput]
        Use:Name Field
        Storage:USERENTERHSN
       
    [Field:DescdataInput]
        Use:NameField
        Storage:USERENTERDESC
        Width:50
        Notify:USERDESCINVALID:($$IsEmpty:$$Value) and NOT ($$IsEmpty:#HsndataInput)
        Skip Forward:$$IsEmpty:#HsndataInput
       
    [System:UDF]
        USERHSNDESCAGGR:Aggregate:5678
        USERENTERHSN:String:2000
        USERENTERDESC:String:2500
    
    [System:Formulas]
        USERDESCINVALID:"Description Not Filled!"+$$NewLine+"Are You Sure?"
       
    
    [Collection:USERENTERHSNCOLL]
        Type:USERHSNDESCAGGR:Company
        Child Of:##SvCurrentCompany
        Compute:HSN:$USERENTERHSN
        Compute:DESC:$USERENTERDESC
       
    
    Hope you like this..
     
    Rohit Khedar likes this.


  4. anish

    anish Member


    Thank for sharing !
     


  5. Bipin Damania

    Bipin Damania Active Member


    Useful Code...
     
    Deepak Sharma (KNP) likes this.


  6. SURENRA

    SURENRA New Member


    hsn list.jpg Check This
    Just Copy HSN.xml File in Tally Folder Location where tally installed and injoy
     

    Attached Files:

    Last edited: Jan 9, 2020


  7. Jenny

    Jenny Active Member


    Check This
    Just Copy HSN.xml File in Tally Folder Location where tally installed and Below is your Tdl code

    Code:
    ;; HSN CODE AND DESCRIPTION MASTER  
    
    [#Field:GST ClassfnMst Code]
        Table:HsnTableColl,NotApplicable
        Show Table:On Empty
       
      
    [#Field:GST ClassfnMst Desc]
        Lines:8
        Set Always:Yes
        Set as:$$FilterValue:$DESC:HsnTableColl:1:OnlythatDesc
        Skip : Yes
      
    [System:Formulae]
        OnlythatDesc:$HSN = #GSTClassfnMstCode
    
    [Collection: HsnCodesXmlCollection]
        Data Source:File XML :"HSN.xml"
        XML Object Path : DATA : 1 :ROOT
        Client Only:Yes
    
    [Collection:HsnTableColl]
    Title:$$LocaleString:"List of Hsn Codes"
    Align:Right
    Full Height:Yes
    Source Collection:HsnCodesXmlCollection
    Fetch :Hsn,Desc
    Format:$Hsn,20
    Format:$Desc,50
    Unique:$HSN
    
     

    Attached Files:

    • HSN.rar
      File size:
      202.8 KB
      Views:
      73


  8. anish

    anish Member


    Thank You Mad'm for the great share and knowledge .............
     
    Jenny likes this.


  9. Gopal solanki

    Gopal solanki New Member


    thank sir
    verry good super work fine
     


  10. ASHOK

    ASHOK Member


    m

    madam ji namaskar

    how to desc area in tally short area not desc.list all words accept in tally area so big area in tally desc space so all word accept

    thanks
     


  11. ASHOK

    ASHOK Member


    20200507_224759.jpg 20200507_224759.jpg

    Sir
    Please chack my problam
    how to desc area in tally short area not desc.list all words accept in tally area so big area in tally desc space so all word accept

    thanks
     


  12. rke

    rke New Member


    Try this code


    ;; HSN CODE AND DESCRIPTION MASTER

    [#Field:GST ClassfnMst Code]
    Table:HsnTableColl,NotApplicable
    Show Table:On Empty


    [#Field:GST ClassfnMst Desc]
    Lines:15
    Set Always:Yes
    Set as:$$FilterValue:$DESC:HsnTableColl:1:OnlythatDesc
    Skip : Yes

    [System:Formulae]
    OnlythatDesc:$HSN = #GSTClassfnMstCode

    [Collection: HsnCodesXmlCollection]
    Data Source:File XML :"HSN.xml"
    XML Object Path : DATA : 1 :ROOT
    Client Only:Yes

    [Collection:HsnTableColl]
    Title:$$LocaleString:"List of Hsn Codes"
    Align:Right
    Full Height:Yes
    Source Collection:HsnCodesXmlCollection
    Fetch :Hsn,Desc
    Format:$Hsn,20
    Format:$Desc,165
    Unique:$HSN View attachment 6760
     

    Attached Files:



  13. ASHOK

    ASHOK Member



    sir please chack hsn code 85481020 desc. not full word add desc.area
     


  14. rke

    rke New Member


    try this this is maximum u can view and desciption is full view is not possible if too long ,but its enough for select hsn

    ;; HSN CODE AND DESCRIPTION MASTER

    [#Field:GST ClassfnMst Code]
    Table:HsnTableColl,NotApplicable
    Show Table:On Empty


    [#Field:GST ClassfnMst Desc]
    Lines:25
    Set Always:Yes
    Set as:$$FilterValue:$DESC:HsnTableColl:1:OnlythatDesc
    Skip : Yes

    [System:Formulae]
    OnlythatDesc:$HSN = #GSTClassfnMstCode

    [Collection: HsnCodesXmlCollection]
    Data Source:File XML :"HSN.xml"
    XML Object Path : DATA : 1 :ROOT
    Client Only:Yes

    [Collection:HsnTableColl]
    Title:$$LocaleString:"List of Hsn Codes"
    Align:Right
    Full Height:Yes
    Source Collection:HsnCodesXmlCollection
    Fetch :Hsn,Desc
    Format:$Hsn,20
    Format:$Desc,200
    Unique:$HSN
    View attachment 6760
     


  15. hprahul

    hprahul Member


    Please find the updated HSN Code list. This also includes the SAC code of services...
     

    Attached Files:

    • HSN.zip
      File size:
      258.2 KB
      Views:
      38


  16. Frz

    Frz Member


    thanks all
    great work Capture.PNG
    can we have the table in multi-line as the description for all items doesn't fit or is too condensed to read

    regards
    frz
     


  17. Frz

    Frz Member


    description a few items HSN Code is repeated
    020xxxxx till 040xxxxx
    regards
    frz
     


Share This Page