Tally ERP9 TDL | Unwanted Masters

Rate this post

[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 Features
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.

Also you can download it with below Button:


  

Tags: No tags

Add a Comment

Your email address will not be published. Required fields are marked *