1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

hlep for import gst % & HSN in tally prime 3.0

Discussion in 'Tally & TDL Learning HUB' started by suyash, Aug 26, 2023.

    
Tags:
  1. suyash

    suyash New Member


    please help for code how to stockitem gst & hsn code on excel to tally


    upload_2023-8-26_16-8-39.png
     
    suyash, Aug 26, 2023
    #1


  2. ROHIT JAISWAR

    ROHIT JAISWAR Active Member


    What you have written for Importing HSN & GST Rate Because UDF has been Changed in 3.O
     
    ROHIT JAISWAR, Sep 13, 2023
    #2


  3. vishnu joshi

    vishnu joshi Member


    ;Try This...

    ;for HSN Info
    1011 : Insert Collection Object:HSNDETAILS
    1012 : Set Value:APPLICABLEFROM:mad:@BooksFromDate
    1013 : Set Value:HSNCODE:$HSN
    1014 : Set Value:SRCOFHSNDETAILS:"Specify Details Here"
    1015 : Set Target:..

    ;for Tax Info
    1040 : Insert Collection Object : GSTDETAILS
    1050 : Set Value : APPLICABLEFROM : @@BooksFromDate
    1060 : Set Value : CALCULATIONTYPE : "On Value"
    1070 : Set Value : TAXABILITY : If $TaxPerc > 0 then "Taxable" else "Nil Rated"
    1080 : Set Value : ISREVERSECHARGEAPPLICABLE:No
    1090 : Set Value : ISNONGSTGOODS : No
    1100 : Set Value : GSTINELIGIBLEITC : No
    ; 0100 : Set Value : HSNCode : $HSN
    1101 : Set Value : SRCOFGSTDETAILS : "Specify Details Here"
    1110 : Insert Collection Object: STATEWISEDETAILS
    1120 : Set Value : STATENAME: $$SysName:Any
    1130 : Insert Collection Object: RATEDETAILS
    1140 : Set Value : GSTRATEDUTYHEAD:"CGST"
    1150 : Set Value : GSTRATEVALUATIONTYPE:"Based on Value"
    1160 : Set Value : GSTRATE:$TaxPerc/2
    1170 : Set Target: ..
    1180 : Insert Collection Object: RATEDETAILS
    1190 : Set Value : GSTRATEDUTYHEAD:"SGST/UTGST"
    1200 : Set Value : GSTRATEVALUATIONTYPE:"Based on Value"
    1210 : Set Value : GSTRATE: $TaxPerc/2
    1220 : Set Target : ..
    1230 : Insert Collection Object : RATEDETAILS
    1240 : Set Value : GSTRATEDUTYHEAD:"IGST"
    1250 : Set Value : GSTRATEVALUATIONTYPE:"Based on Value"
    1260 : Set Value : GSTRATE: $TaxPerc
    1270 : Set Target : ..
    1280 : Insert Collection Object : RATEDETAILS
    1290 : Set Value : GSTRATEDUTYHEAD:"Cess"
    1300 : Set Value : GSTRATEVALUATIONTYPE:"Based on Value"
    1310 : Set Value : GSTRATE: 0
    1320 : Set Target : ..

    1422 : Insert Collection Object:Rate details
    1433 : Set Target : Rate details
    1444 : Set Value : GSTRATEDUTYHEAD:"State Cess"
    1455 : Set Value : GSTRATEVALUATIONTYPE:"Based on Value"
    1466 : Set Value : GSTRate:0
    1470 : Set Target : ..
    1330 : Set Target : ..
    1340 : Set Target : ..
     
    vishnu joshi, Sep 13, 2023
    #3


Share This Page