Breaking

EXCEL TO TALLY - AUTOMATION 10.0 | BEST EXCEL TO TALLY DATA TRANSFER UTILITY | EXCEL TO TALLY PRIME IMPORT | EXCEL TO TALLY ERP9 IMPORT

This is Excel to Tally Automationto automate your Data Entry with Tally. It is very helpful to import Excel Datainto Tally, easy and quickly...

Friday, 12 February 2021

HSN and GST Rate in Stock Summary | Free TDL Code 2021


With this free TDL code we can add Item HSN code and Item GST Rate in Stock summary detail. Yes! now with this tally tdl we can use hsn and gst in stock summary and export details in excel or any other format from tally.

We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple code to see stock summary with HSN and GST rate of Stock Items

HOW TO USE:

        1. Load below Tally Prime stock summary with HSN and GST Rate TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go to Stock summary, here we can see stock summary details with hsn and gst rates.
      3. Now we can export stock summary report into excel sheet to do our work easily. 


This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#Field:DSPQ QTYTitle]
add:fields:after:DSP DispTitle:LearnwellSHsnT,LearnwellSRT
invisible:##DSPShowInwards
[Field:LearnwellSHsnT]
Set as :"HSN"
color:blue
style:bold
[Field:LearnwellSRT]
Set as :"GSTRate"
color:blue
style:bold

[#Field:DSP CLQty]
add:fields:after:DSP DispName:LearnwellSHsn,LearnwellSR
invisible:##DSPShowInwards
[Field:LearnwellSHsn]
Set as :$GSTHSNCode
width:20
color:red
[Field:LearnwellSR]
Set as :$GSTIGSTRate
width:20
color:red



HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as - C:\Users\HP\Desktop\rec\Party Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup - Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

2 comments:

  1. YES ITS WORKING BUT NOT SHOWING HSN CODE AND GST RATE DESPITE HAVING HSN CODE ASSIGNED TO ITEMS. ITS SHOWING ONLY NOT FOUND IN RED AND BLANK GST RATE COLUMN

    ReplyDelete
  2. YES ITS WORKING BUT NOT SHOWING HSN CODE AND GST RATE DESPITE HAVING HSN CODE ASSIGNED TO ITEMS. ITS SHOWING ONLY NOT FOUND IN RED AND BLANK GST RATE COLUMN

    ReplyDelete