[CLICK ON IMAGE TO WATCH THE VIDEO]
With This Tally ERP 9 TDL file You can delete unwanted masters that are useless or unused without transactions. You can excess Ledger Master, Ledger Groups, Stock masters, stock Groups, Employee Masters, CostCenterMasters.
This TDL is very helpfull and must have TDL file for Tally.
COPY THE FOLLOWING CODE AND FOLLOW INSTRUCTION
[Menu : LWS Report]
Title : ” Delete Master”
Item : Blank
Item : Ledger : Display : LW Ledger
Item : Group : Display : LW Group
Item : Blank
Item : Employess : Display : LW Employess
Item : Cost Centre : Display : LW Cost Centre
Item : Blank
Item : Stock Item : Display : LW Stock Item
Item : Stock Group : Display : LW Stock Group
[Report : LW Ledger]
Title : “Ledger Master”
Use : LWS Report
[Report : LW Group]
Title : “Group Master”
Use : LWS Report
Local : Collection : My mastercoll : Delete : Type
Local : Collection : My mastercoll : Add : Type: Group
[Report : LW Employess]
Title : “Employess Master”
Use : LWS Report
Local : Collection : My mastercoll : Delete : Type
Local : Collection : My mastercoll : Add : Type: Cost Centre
Local : Collection : My mastercoll : Add : Filter : EmployeesFilter
[Report : LW Cost Centre]
Title : “Cost Centre Master”
Use : LWS Report
Local : Collection : My mastercoll : Delete : Type
Local : Collection : My mastercoll : Add : Type: Cost Centre
;; Uncommented
Local : Collection : My mastercoll : Add : Filter :CostCentreFilter
[Report : LW Stock Item]
Title : “Stock Item”
Use : LWS Report
Local : Collection : My mastercoll : Delete : Type
Local : Collection : My mastercoll : Add : Type: StockItem
[Report : LW Stock Group]
Title : “Stock Group”
Use : LWS Report
Local : Collection : My mastercoll : Delete : Type
Local : Collection : My mastercoll : Add : Type: Stock Group
;;www.learnwells.com
[Collection: Payroll Employees11]
Use : Alias Collection
Type : Cost Centre
Title : $$LocaleString:”List of Employees”
Filter : EmployeesFilter
Filter : PayrollBelongsToCategory
Filter : PayrollEmployeesFilter
Format : $Parent
[Report : LWS Report]
Form : LWS Report
[Form : LWS Report]
Height : 100% Page
Width : 100% Page
Part : LWS Report
Bottom Part : LW Note
Button : Gr DeleteSelected
Button : Gr Btn Select All,Gr DeleteAll
Key : Gr Shift Down Select
[Part : LWS Report]
line :LWS Report Title , LWS Report
Repeat : LWS Report : My mastercoll
Scroll : vertical
Common border : yes
[Line : LWS Report Title]
Field : LWS Report sl, LWS Report, LWS Report g
Border : thin Top Bottom
Local : Field : Default : Style : Normal bold
Local : Field : LWS Report sl : Set as : “SR.”
Local : Field : LWS Report : Set as : “Particulars”
Local : Field : LWS Report g : Set as : “Group”
[Line : LWS Report]
Field : LWS Report sl, LWS Report, LWS Report g
[Field : LWS Report Sl]
set as : $$line
Width : 5
Align : Right
Border : Thin Left Right
[Field : LWS Report]
set as : $Name
Width : 35
[Field : LWS Report g]
set as : $Parent
Width : 40
Border : Thin Left Right
[Part : LW Note]
Line : LW Note
[Line : LW Note]
Field : LW Note
[Field : LW Note]
Set as : “Always Take Backup – www.Learnwells.com”
Color : Red
Style : Large bold
Fullwidth : yes
[Collection : My mastercoll]
Type : Ledger
Compute : IsEmptyObject : $$IsEmptyObject
Filter : ONlyempty
[Button: gr DeleteSelected]
Title : “Delete Selected”
Key : Alt + D
Action : Delete Object
Mode : Display
Scope : Selected Lines
[Button: Gr DeleteUnselected]
Title : “Delete All”
Key : Ctrl + E
Action : Delete Object
Mode : Display
Scope : Unselected Lines
[Button: Gr DeleteAll]
Title : “Delete All”
Key : Ctrl + D
Action : Delete Object
Mode : Display
Scope : All Lines
[Button: GR Btn Select All]
Title : “Select All”
Key : Ctrl+A
Action : Select All
Mode : Display
[Button: Gr Btn Select None]
Title : “Select None”
Key : Ctrl + 8
Action : Unselect All
Mode : Display
[Key: Gr Shift Down Select]
Title : “Select”
Key : Shift + Down
Action : Toggle Select
Mode : Display
[System : Formula]
ONlyempty : $$IsEmptyObject
[#Menu: Gateway of Tally]
Add : Item : before : @@locaccountInfo : Unwanted Masters : Menu : LWS Report
Control : Master Delete : NOT ##SVEducationalMode
;;www.learnwells.com
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 5. Press F12 and goto Product and Features5. Press F4 (to open a Box)6. Load TDL file on Startup – Yes7. Paste The path in blank space8. Press enter and save
Now your TDL is ready to use.
Also you can download it with below Button: