Thursday, 13 July 2017

Display HSN Code on Sales/Purchase Screen



Now you can directly download following code text file below this post
  
Please Read Note Also that is written below the code. 

Aware:-Don't share your Numbers and Mail id's to anyone for getting this code.



If you want to discuss privately with me you can leave message for me on my facebook Page https://www.facebook.com/Aasan-Solution-2330593887165740/

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






Copy & Paste following code into Notepad

;;Jai Shree Janesh||Jai Shree Krishna||Jai Narayan||Jai Shree Ram||
;*******************************************************************
;Objective
;Watch HSN code with Item name on Sales & Purchase entry Screen
;Author:Deepak 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].hsncode
Alignment:Right

[#Field: GSTTaxHistoryHSN]
Use : Name Field
Storage : HSNCode
Storage : dpk
Width : 10
Border : Thin Right
Inactive: $$IsEmpty:$ApplicableFrom
Skip : $$IsSysNameEqual:Undefined:#GSTTaxHistoryTypeofSupply

Note:- If above code not working then Replace above highlited line with follwoing line

Set as:$(Stockitem,$stockitem).GstDetails[Last].dpk

If file not working for you then

1.Make sure that you saved notepad file with .txt extension.
2.In tally write proper Location of file with .txt extension.


Now you can Download Above text File

Click Here For download


Download Item with HSn & GST %


For More info watch this video
https://www.youtube.com/watch?v=C4RTRhs8dk0

40 comments:

  1. Replies
    1. its working, use it in release 6.0.1 and don't miss bit of code when you paste

      Delete
    2. check again this post.. i solved the problem

      Delete
    3. hello sir
      ..........yeh tdl expiry ho gya h plz new tdl send kr do plzz

      Delete
    4. I like it, Very useful TDL file for Eway Bill
      Thanks & Regards

      Delete
  2. What is the TDL code of GST Tax Detail, which is below part of INVOICE.
    Please Help.

    ReplyDelete
  3. in my tally this is not working and not show, kindly hepl my contact no 9958511633

    ReplyDelete
  4. we enter hsn code in stock group level.

    hsn code in not show with this code.

    ReplyDelete
  5. We can't found TDL File on your site

    ReplyDelete
  6. We are entering HSN in Stock Group level and not Stock item level and hence, HSN code is not showing...
    Kindly edit the code accordingly to show hsn entered in group level..
    9819413371

    ReplyDelete
    Replies
    1. Please wait.. I am very busy. But i will edit the code if not working later.

      Delete
  7. Great Job...
    Can u also manage to add GST% in voucher...

    Also please upload TDL code for import Inventory items along with category, group HSN Code, Description and Tax from excel sheet

    ReplyDelete
  8. hello sir,
    gst code not show in 6.0.2 tally virsion i have try above both way ...

    ReplyDelete
    Replies
    1. esa nahi ho sakta aapne kuch na kuch mistake ki hai, i checked it in all latest versions. By the way what error?

      Delete
  9. In 6.0.3 though it is shows the hsn column but it is not picking up the code.

    ReplyDelete
    Replies
    1. Sorry my fault I have corrected it. But now the HSN code that it is showning is not readable. The black Box is too small for the code to be read. Please help.

      Delete
    2. I have done -yes- to- "show turn over with customer achived"- when I mark this to "No" then the code is displayed ok and is readable. Please recommend changes for this.

      Delete
  10. its not working in the Tally ERP9 Series A Release 6.0.3
    Please Rectify the Code.

    ReplyDelete
  11. sir,thanks for your kind donate,but not working in voucher class,pls rectify in work from voucher class
    n.srinivasan, erode tamilnadu,netprostally@gmail.com

    ReplyDelete
  12. Please tdl for stock item rate showing on display
    My email. amitkumarchaudhary083@gmail.com

    ReplyDelete
  13. Thanks a lot, cant believe it actually works......

    ReplyDelete
  14. report for Party Name / Address / Pan / GSTin No. with TDL

    ReplyDelete
  15. Sir your work is wonderful. I want to add my logo on purchases bills i print while i print self purchases bills, in tally its not comming.

    ReplyDelete
  16. sir plz arenj recycle bin for tally . mbl no 9300410042

    ReplyDelete
  17. sir plz your contact mbl no . my mbl no 9300410042

    ReplyDelete
  18. CAN I PURCHAE EXCEL UTILITY TO CONVERT TALLY

    ReplyDelete

  19. how much rate of excel utility to purchase

    ReplyDelete
  20. HSN CODE COLUMN IS SHOWN EMPTY...I HAVE ALREADY EDITED TXT FILE AS U HAVE INSTRUCTED, TALLY 6.4

    ReplyDelete
  21. If I have set HSN code for item group then HSN code is not showing.

    ReplyDelete
  22. I have made group of items of different HSN Code and i have assigned group with hsn code and percentage. I am not getting HSN code and percentage display using your tdl. Please help

    ReplyDelete