Hello people, Hope it is useful.. Predefined collection of HSN and SAC codes I collected these codes from internet and made a xml collection with them Download the xmlfiles.rar attached below unzip the file and place them in tally folder (Working directory) Code: Code: [Collection:HsnCodesXmlCollection] Data Source:File XML :"HsnData.xml" XML Object Path : DATA : 1 :ROOT Client Only:Yes [Collection:SACCodesXmlCollection] Data Source:File XML :"SacData.xml" XML Object Path : DATA : 1 :ROOT Client Only:Yes [#Field:GST ClassfnMst Code] Table:HsnTableColl,SacTableColl,NotApplicable Show Table:On Empty ;;if you dont want hsn codes then remove Hsntablecoll ;;if you dont want sac codes then remove SacTableColl [Collection:HsnTableColl] Title:$$LocaleString:"List of Hsn/Sac Codes" Align:Right Full Height:Yes Source Collection:HsnCodesXmlCollection Fetch :Hsn Format:$Hsn,25 [Collection:SacTableColl] Title:$$LocaleString:"List of Hsn/Sac Codes" Align:Right Full Height:Yes Source Collection:SACCodesXmlCollection Fetch :Sac Format:$Sac,25 You can create a collection to add HSN codes ,If you want to add HSN code manually then add that collection to HSN table.
dear sir, can you share / develop code for city as per below for me, please email me on tejeet1@gmail.com
[System : UDF] udfLedCity : String : 20001 ;; Ledger City ; City Master [#Menu : Accounts Info.] Add : Key Item : After : @@locLedgers : "City" : Y : Menu : VIT City Menu [Menu : VIT City Menu] Title : $$LocaleString:"City Master" Indent : "Single City" Item : BLANK Key Item : @@locCreate : C : Create Collection : List of ExtractCostCategories : @Allowed AND $$Allow:Create:AccountsMasters Key Item : @@locDisplay : D : Display Collection : List of ExtractCostCategories : @Allowed AND $$NumCostCategories > 0 AND $$Allowisplay:AccountsMasters Key Item : @@locAlter : A : Alter Collection : List of ExtractCostCategories : @Allowed AND $$NumCostCategories > 0 AND $$Allow:Alter:AccountsMasters Item : BLANK ;Indent : "Multiple City" ;Item : BLANK ;Key Item : @@locCreate : R : Create : Multi Cost Category : @Allowed AND $$Allow:Create:AccountsMasters ;Key Item : @@locDisplay : I : Display Collection : Multi Cost Category : @Allowed AND $$NumCostCategories > 0 AND $$Allowisplay:AccountsMasters ;Key Item : @@locAlter : T : Alter Collection : Multi Cost Category : @Allowed AND $$NumCostCategories > 0 AND $$Allow:Alter:AccountsMasters ;Item : BLANK Key Item : @@locQuit : Q Allowed : $$IsAccountingOn:$$CurrentSimpleCompany [#Collection : List of ExtractCostCategories] Title : $$LocaleString:"List of Cities" Filter : NoPrimary [#Collection : Cost Category] Title : $$LocaleString:"List of Cities" Filter : NoPrimary [System : Formula] NoPrimary : $Name <> $$PrimaryCostCategory [#Report : SCostCategory] Title : $$LocaleString:"Select City" Local : Field: MV Title : Info : $$LocaleString:"Name of City" [System : Formula] MultCostCatCreateModeFormat : $$LocaleString:"Multi City %s %s" [#Report : Cost Category] Title : $$LocaleString:"City" + @@ModeName + @@SubModeName [#Form : Cost Category] Delete : Top Parts : CSTCAT Behaviour [#Form : Multi Cost Category] Width : 100% Screen [#Part : MCSTCAT Body] Delete : Lines : MCSTCAT Secondary Titles [#Line : MCSTCAT Main Titles] Delete : Right Fields : MCSTCAT Allocation Title [#Field : MCSTCAT Name Title] Info : $$LocaleString:"Name of City" [#Line : MCSTCAT Body] Delete : Right Fields : CSTCAT ForRevenue, CSTCAT ForNonRevenue [Collection : MyCity] Type : Cost Category Fetch : * IsOdbcTable : Yes ; Ledger [#Part : LED Mailing Address] Add : Bottom Line : Before : LEDState : lnCityUDF [#Field : LED Mailing Address] Set Always : Yes [Line : lnCityUDF] Field : Medium Prompt,fldCityUDF Local : Field : Medium Prompt : Set as : "City" Local : Field : Medium Prompt : Inactive : NOT @@IsDebtorCreditor [Field : fldCityUDF] Use : Name Field Storage : udfLedCity Max : 40 Table : Cost Category,Not Applicable Show Table : Always Key : Create Cost Category Style : Small Bold Inactive : NOT @@IsDebtorCreditor
Code: [Collection:HsnCodesXmlCollection1] Data Source:File XML :"HsnData1.xml" XML Object Path : DATA : 1 :ROOT Client Only:Yes [#Field:GST ClassfnMst desc] Table:HsnTableColl1,NotApplicable Show Table:On Empty ;;if you dont want hsn codes then remove Hsntablecoll ;;if you dont sac codes then remove SacTableColl [Collection:HsnTableColl1] Title:$$LocaleString:"List of Hsn/Sac Descriptions" Align:Right Full Height:Yes Source Collection:HsnCodesXmlCollection1 Fetch :Hsn Format:$Hsn,25 dear teja verma sir, on basis of your code, i have created another code for hsn description , which is working fine, but now i want to co- relate both code for hsn description & hsn code , if are select particular hsc description than it should select pre assign hsc code from hsn code list & auto fill hsn code & go to next tab, so please help to link both code, my codes for hsn description is as follows :
dear teja verma sir, on basis of your code, i have created another code for hsn description , which is working fine, but now i want to co- relate both code for hsn description & hsn code , if are select particular hsc description than it should select pre assign hsc code from hsn code list & auto fill hsn code & go to next tab, so please help to link both code, my codes for hsn description is as follows , Download the HSNDATA1.xml files attached below, unzip the file and place them in tally folder (Working directory) You can create a collection to add HSN description ,If you want to add HSN code manually then add that collection to HSN description table. Code: [Collection:HsnCodesXmlCollection1] Data Source:File XML :"HsnData1.xml" XML Object Path : DATA : 1 :ROOT Client Only:Yes [#Field:GST ClassfnMst desc] Table:HsnTableColl1,NotApplicable Show Table:On Empty ;;if you dont want hsn codes then remove Hsntablecoll ;;if you dont sac codes then remove SacTableColl [Collection:HsnTableColl1] Title:$$LocaleString:"List of Hsn/Sac Descriptions" Align:Right Full Height:Yes Source Collection:HsnCodesXmlCollection1 Fetch :Hsn Format:$Hsn,25
first you need to link descriptions with hsn/sac codes in the xml files i provided add '<DESC>description</DESC>' under each corresponding <HSN> tag like below.. Code: <DATA> <HSN>12345678></HSN> <DESC>Description></DESC> </DATA> then you need desc also along with hsn and show description table at description field after entering description get the hsn code from collection by filtering out then desc collection with above entered description thats it....
you have two ways to do that: 1) you can write a script in any language to remove leading zero from hsc and sac from the xml files that i provided or 2) you can use $$StringReplace function in tally to remove leading zero from hsn code but first you have to check weather there is a zero at beginning or not for this you can use $$StringPart function in tally
HI I have updated the code with HSN/SAC code along with Description, Kindly download and copy the attached file into tally folder - Xl and Module File Kindly check and revert
As we entered hsn code from the table the description field should auto filed with description of that hsn code
dear Nirav, i have copy hsn excel file in tally working folder, but tdl is not working, so please check & revert back
i have copy hsndata.xml file in tally working folder, but tdl is not working, so please check & revert back[/QUOTE]
i hope all r tally developer i have posted 2 files one is zip file which u have to unzip and u will get xl file kindly copy the same in tally installed folder and add the add-on in tally product and feature it shd run even if any query i have shared the text file of add-on ? some body asking where is XML?
Auto description added.. http://tdlexpert.com/index.php?threads/hsn-code-list-with-description-autofill.7284/
I have 13000/ HSN with Desc but how to set this tipe if i set one by one so more time so tell plz any formula in xml so i can create minimum time
i want this type as not Nirav Merchant <DATA> <HSN>12345678></HSN> <DESC>Description></DESC> </DATA>[/CODE]