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
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?
;;Jai Shree Janesh||Jai Shree Krishna||Jai Narayan||Jai Shree Ram|| ;******************************************************************* ;Objective ;Watch HSN code with Item name on Sales & Purchase entry Screen ;Authoreepak 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
[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
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.
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
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.
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).
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