Prevent Master duplication TDL | 2022 Best Tally Prime and Tally ERP9 TDL to Prevent Duplicate Ledger and Item

 

Tally is a most usable business software in India because of it’s simplicity and reporting system. If you maintain your masters and vouchers correctly in Tally then it will become life saving tool for business. But sometime by mistake we create some duplicate masters with another name and by repeating this mistake we make our Tally Data a garbage and can not create a proper reports. So we need to avoid this type mistakes if we want to do proper accounting. 
To avoid this type mistakes I have something special for our Tally. We can create a TDL to avoid master duplication so we can do all things in proper way. 
So today in this post we will create a TDL for our Tally prime and also for Tally ERP9 to prevent duplicate masters. In this TDL we will add a Master list in Tally Master creation screen so when we go to create masters first we track the name of Ledger or Item that we want to create then after searching we can create unique masters.
This is must have Tally TDL for Tally Prime and Tally ERP9 to prevent master duplication.
With this Free Tally Prime TDL, we can add ledgers and item lists in our master creation screen that can be tracked by typing present names in Tally master.

In this code we do two steps – one for Ledger master and another for Item masters. Please watch above video to understand more about TDL code.

TDL Code:


[#Part:MST Basic]
Option:LearnwellMaster:@@IfLedger
Option:LearnwellMaster2:@@IfItem

[!Part:LearnwellMaster]
Add:Line:At Beginning:LWMstLine
[Line:LWMstLine]
Field:ShortPrompt,LwmstF
Local:Field:ShortPrompt:info:”Master List”
Local:Field:ShortPrompt:Width:8% page
[Field:LwmstF]
use:Name Field
Table:LWCollectionLed, End of List
[Collection:LWCollectionLed]
Type:Ledger
Add:Format:$Name,20
Filter:IfLedger
Fetch:*.*

[!Part:LearnwellMaster2]
Add:Line:At Beginning:LWMstLine2
[Line:LWMstLine2]
Field:ShortPrompt,LwmstF2
Local:Field:ShortPrompt:info:”Master List”
Local:Field:ShortPrompt:Width:8% page
[Field:LwmstF2]
use:Name Field
Table:LWCollectionItem, End of List
[Collection:LWCollectionItem]
Type:Stockitem
Add:Format:$Name,25
Filter:IfItem
Fetch:*.*

[System:Formula]
IfLedger:$$IsLedger
IfItem:$$IsStockItem

HOW TO USE:
 
        1. Copy the above code and make a text file
        2. Load in Tally ERP9 or in Tally Prime (Method provided below) 
        3. Now go to generate Ledger or Item master
     4. There you will find ledger list or item list and can search the name before creating new master.

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 perfectly work with Tally Prime.

Watch above video to learn :
1. How to add item master list and ledger master list table.
2. How to modify fields of master creation screen.
3. And Many More…….

HOW TO USE TDL CODE:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and make a text file.
2. Save into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecPreventDuplicateMaster.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.  


Leave a Comment