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...
;;; 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..
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
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
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
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
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
thanks all great work 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