Best of Tally Prime TDL Reports | Way to use SQL for Tally reports | Use Narration to get Best Tally Reports

by with One Comment Tally Prime TDLTDL 2019TDL 2020TDL 2021TDL for Tally

Yes! you are in right place if you use Tally software. In this post we will understand, how to collect best Tally reports and export it into tally with the help of SQL query. We can use SQL query in Tally Narration and collect reports as per our requirement. It is very simple process for all type report collection from tally.

We can retrieve information from Tally ERP9 and Tally Prime by using below SQL method in Tally narration:

1. Press Ctrl+N to go to Tally Calculator

2. In Tally Calculator write SELECT and SQL command to get information.

The syntax to write SQL Query in Tally is:

SELECT [<Method Name/s> / <*>] FROM <Collection/Table> WHERE <Condition> ORDER BY <Method Name/s>

For Example collect name from Ledgers copy below SQL and paste in Narration then press enter to get ledger name details:

SELECT $Name FROM Ledger

or

SELECT $Name FROM ODBCTables
    Method names always will start with $ (dollar) sign – as in above example we used $Name

Report Examples:

We can collect below type reports with SQL query by type below texts in Narration field of Tally and press enter:

1. Collect All Information of Ledgers:

SELECT * FROM Ledger

2. Collect All Information of Stock Items:

SELECT * FROM StockItem

3. Collect All Information of Units:

SELECT * FROM Unit

4. Collect All Information of Voucher Types:

SELECT * FROM VoucherType

5. Collect All Information of Cost Centre:

SELECT * FROM CostCentres

6. Collect All Information of Godown:

SELECT * FROM Godown

7. Collect All Information of Stock Group:

SELECT * FROM StockGroup

8. Collect All Information of Stock Category:

SELECT * FROM StockCategory


NOW WE KNOW ALL METHOD NAMES OF LEDGERS, ITEMS ETC. SO CAN TRY BELOW COLLECTIONS ALSO:

9. To retrieve more than one method from a collection, separate the method names with a comma. For example, to retrieve $Name and $ClosingBalance of Ledger collection

SELECT $Name, $ClosingBalance FROM Ledger


10. Also we can use WHERE method to retrieve Debit Credit or other reports

SELECT $Name FROM Ledger WHERE $$IsDr: $ClosingBalance

11. to get Credit closing balance can use below method with NOT $$IsDr

SELECT $Name FROM Ledger WHERE NOT $$IsDr: $ClosingBalance


12. Get closing balance between two amounts as between 10000 and 11000

SELECT $Name FROM Ledger WHERE $ClosingBalance BETWEEN 10000 AND 11000

13. Collect ledger names that contain names like Sales (As Sales Account, GST Sales etc.)

SELECT $Name FROM ledger WHERE $name LIKE ‘%sales%’


14. Also we can collect reports with sort in order by order keyword : (in below example DESC for descending order) 

SELECT $Name, $ClosingBalance FROM Ledger WHERE $$IsDr: $ClosingBalance ORDER BY $ClosingBalance DESC

Also we can collect information with the help of TDL Collections: (click the below link)

Select Alias at Billing Time – Free TDL Code | Best Tally TDL Codes 2021

by with No Comment Tally Prime TDLTDL 2020TDL 2021TDL for Tally
With this free TDL code we can select stock Alias name instead of Stock item name and also can see alias in item scroll bar with all alias and items. And in invoice print show full description of Item.
 
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 work with stock item alias at invoice time.

HOW TO USE:

        1. Load below Tally Prime Item Alias TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go for invoicing in sales voucher / purchase voucher and select Item to bill.
        3. Now we can see all alias list with item, and also we can choose alias instead of item name.
        4. No changes in invoice printing.


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 : 

[#Collection: Vch Stock Item Extract]
Fetch : Aliasname
Add : Format : $Aliasname,20

[#Object : Stockitem]
Aliasname : $$Alias



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:UsersHPDesktoprecParty 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.

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

by with 2 Comments Tally Prime TDLTDL 2020TDL 2021TDL for Tally
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:UsersHPDesktoprecParty 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.

Last Purchase Rate Notification for Every Item | Tally TDL Free Code

by with No Comment Tally Prime TDLTDL 2020TDL 2021TDL for Tally
We sale product and go to invoice for customer and forgot purchase rate of item and put wrong amount in sale bill. Oh! that’s horrible thing stop it. Yes now we can stop inputting  wrong selling price with this Tally Prime and Tally ERP 9 free TDL code. This TDL code will notify for purchase rate of item when goto sell.
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 for Last purchase rate notification.

HOW TO USE:

        1. Load below Tally Prime rate notification TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go for invoicing , when you select item and go for enter rate detail it will popup a last purchase rate of item.
      3. Now we can prevent wrong invoicing with this TDL code. 


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:VCHBatchRate]
On:Focus:Yes:Set:LstPurRate:$$Number:$LastPurcPrice:StockItem:#VCHStockItem
Notify:MSGNotice:@@IsSales
[System:Formula]
MSGNotice:$LastPurcPrice:StockItem:#VCHStockItem

[#Field:VCHBatchRateUnits]
On:Focus:Yes:Set:LstSaleRate:$$Number:$LastSalePrice:StockItem:#VCHStockItem
Notify:MSGNotice:@@IsSales
[System:Formula]
MSGNotice:$LastSalePrice:StockItem:#VCHStockItem



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:UsersHPDesktoprecParty 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.

Tally Prime Color TDL | Free Tally Prime TDL Code

by with No Comment Tally Prime TDLTDL 2020TDL 2021TDL for Tally
Tally Prime has less color, come today we will color it. Yes with this amazing Tally Prime TDL code we can color Tally Prime Ledger view.
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 color Tally Prime. Enjoy!

HOW TO USE:

        1. Load below Tally Prime Color TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go to any ledger (short cut- Key- D,A,L). Look ledger detail in detailed format with narration.
      3. Now colorful Ledger detail in front of us, that increase visibility and working. 


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:DSP VCHLedAccount]
Fields:Name Field
Local:Field:Name Field:Set As:#LedgerName
Style:Normal Bold
Color:Dark Green
Background:Surf Green
Border:Thin Bottom

[#Field:VCH LedNarr Explosion]
Fields:Name Field
Local:Field:Name Field:Set As:$Narration
Color:White
Background:Grey

[#Field:VCH BillName]
Fields:Name Field
Local:Field:Name Field:Set As:$Reference
Color:Blue


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:UsersHPDesktoprecParty 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.

Registers with Batch and Godown details | Best Free TDL Code 2021

by with 2 Comments Tally Prime TDLTDL 2020TDL 2021TDL for Tally
With this amazing free TDL code we can get columnar registers ( like Sales Register, Purchase Register, Stock Journal and Manufacturing Journal register that content stock Items ) with there item batches and item godowns. So now you can get reports with Item batch and godown.
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. May be it is best trick to get data from Tally according to our need.

HOW TO USE:

        1. Load below Register with Batch and Godown TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now Goto Sales register or Purchase register or Stock Journal Register etc. and goto Columnar Report (Press F8) and enable all details for Items also.
      3. Now you will get sales report with every detail like GST Detail , Voucher Number, Voucher Type, References, Item Name etc. along with Item Batch and Godown Details.
      4. So now we can export it into Excel and 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 : 

[#Collection:Columnar Filtered Vouchers of Company]
Fetch:AllinventoryEntries.BatchAllocations.BatchName
Fetch:AllinventoryEntries.BatchAllocations.GodownName
Fetch:AllinventoryEntries.*

[#Line:DSP ColVCHTitle]
Local:Field:LearnwellBT:info:”Batch / Godown Name”

[#Line:DSP ColVCHDetail]
Add:Field:After:DBC VCHNo:LearnwellBT
[Field:LearnwellBT]
Use:ShortName Field
Width:@@DSPNameWidth
Set As:$$FullList:BatchAllocations:$BatchName + ” / ” + $$FullList:BatchAllocations:$GodownName
Style:Small
Border: Thin Left Right


HOW TO USE ABOVE CODE:

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:UsersHPDesktoprecParty 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.

GET DETAILED GST SUMMARY WITH ONE CLICK | BEST TALLY TDL 2021 | BEST TALLY PRIME TDL

by with No Comment Tally Prime TDLTDL 2020TDL 2021TDL for Tally
With this amazing free TDL code we can get GST detailed summary as we want with one click.
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. May be it is best trick to get data from Tally according to our need.
HOW TO USE:

        1. Load below GST Summary TDL code in Tally ERP9 or Tally Prime (Method provided below the code)
        2. Paste this line in Narration : Select $Date, $VoucherTypeName,$VoucherNumber, $Reference, $Narration,$LWL1, $LWA1, $LWL2, $LWA2, $LWL3, $LWA3, $LWL4, $LWA4, $LWL5, $LWA5,$Amount from LearnWellColl where $VoucherTypeName=”Sales”
       3. Now you will get sales report with every detail like GST Detail , Voucher Number, Voucher Type, References, Narration, Ledgers and there amount.
        4. So after getting detailed summary of sales report, we can export it into Excel and 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 : 

[Collection:LearnWellColl]
Type:Voucher
Fetch:Date, VoucherNumber, Reference, VoucherTypeName,LedgerName,PartyLedgerName,Narration,Amount
Compute:LWL1:$$CollectionField:$LedgerName:1:AllLedgerEntries
Compute:LWA1:$$CollectionField:$Amount:1:AllLedgerEntries
Compute:LWL2:$$CollectionField:$LedgerName:2:AllLedgerEntries
Compute:LWA2:$$CollectionField:$Amount:2:AllLedgerEntries
Compute:LWL3:$$CollectionField:$LedgerName:3:AllLedgerEntries
Compute:LWA3:$$CollectionField:$Amount:3:AllLedgerEntries
Compute:LWL4:$$CollectionField:$LedgerName:4:AllLedgerEntries
Compute:LWA4:$$CollectionField:$Amount:4:AllLedgerEntries
Compute:LWL5:$$CollectionField:$LedgerName:5:AllLedgerEntries
Compute:LWA5:$$CollectionField:$Amount:5:AllLedgerEntries


HOW TO USE ABOVE CODE:

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:UsersHPDesktoprecParty 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.



Add own terms and Important lists in Invoice | Free TDL code for Tally 2021

by with One Comment Tally Prime TDLTDL 2020TDL 2021TDL for Tally

With this free TDL code we can add our own fields, our own lists like websites details and also can add another terms and conditions in invoice print. With this Terms TDL our invoice looks professionally.  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. 

It will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[Collection:LearnWellsTerms]
List Name: “www.Learnwells.com”
List Name: “E2T.in”
List Name: “Youtube/Learnwell”

[#Part:EXPINV ExciseDetails]
Option:LWInvDetails:@@IsSales
[!Part:LWInvDetails]

add:Lines:EXPINV SubTitle, LearnWellD
Local:Field:EXPINV SubTitle:info:”Websites”
Local:Field:EXPINV SubTitle:Border:Thin Bottom
Repeat:LearnWellD:LearnWellsTerms
Invisible:Not @@IsInvoice

[line:LearnWellD]
Option:Small size line
Fields: Simple Field, NameField
Local:Style:Default:Bold:No
Local:Field:Simple Field:Set As:$$String:$$Line+”.”
Local:Field:NameField:Set As:$Name
Local:Field:NameField:Width:45% page

HOW TO USE ABOVE CODE:

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:UsersHPDesktoprecParty 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.

Item Sale and Purchase rate in voucher at Invoice time – Best Free Tally TDL 2021

by with One Comment Tally Prime TDLTDL 2020TDL 2021TDL for Tally

With this TDL code we can add sales and purchase rate of item in voucher , It will help us to prevent taking wrong amount at invoice time .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. 

It will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#line:EI ColumnOne]
Add:Right Field:Before:VCH QtyTitle:LearnwellsRate
[Field:LearnwellsRate]
Setas:$$LocaleString:”Purchase Rate”
Width:15
Skip:Yes

[#line:EI invinfo]
Add:Right Field:Before:VCH ActualQty:LearnwellsRD
[Field:LearnwellsRD]
use:Short Prompt
Setas:$StandardCost:StockItem:$StockItemName
Widht:15
Skip:Yes

[#line:EI ColumnOne]
Add:Right Field:Before:VCH QtyTitle:LearnwellsRateS
[Field:LearnwellsRateS]
Setas:$$LocaleString:”Sales Rate”
Width:15
Skip:Yes

[#line:EI invinfo]
Add:Right Field:Before:VCH ActualQty:LearnwellsRDS
[Field:LearnwellsRDS]
use:Short Prompt
Setas:$StandardPrice:StockItem:$StockItemName
Widht:15
Skip:Yes

HOW TO USE ABOVE CODE:

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:UsersHPDesktoprecParty 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.

LISTEN TALLY VOICE | NOW TALLY SOFTWARE SPEAK – TALLY TDL

by with No Comment Tally Prime TDLTDL 2020TDL 2021TDL for Tally

With this TDL code we can talk with tally and can listen tally software voice. Try this tdl code and amazed everyone  .  TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

It will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#Field: EI Consignee]
    Add : Option: EI ConsigneeSales: ($$IsSales:##SVVoucherType)

[#Field: ACLSLed]
    Add : Option: EI ConsigneePayment: ($$IsPayment:##SVVoucherType)

[!Field: EI ConsigneeSales]
    On: Accept: Yes : Exec COM Interface : Voice Interface :@@TomClsAmt

[!Field: EI ConsigneePayment]
    On: Accept: Yes : Exec COM Interface : Voice Interface :@@TomClAmt

[COM Interface: Voice Interface]
    Project : Sapi
    Class : SpVoice
    Interface : Speak
    Parameter : P1 : String
   
[System:Formulas]
    TomClsAmt : “Current Closing Balance Amount is ”  + $$InWords:@@EIConBal + “Rupees Only”
    TomClAmt  : “Current Total Payables Amount is”  + $$InWords:@@LedgerTotal  + “Rupees Only”

HOW TO USE ABOVE CODE:

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:UsersHPDesktoprecParty 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.