Tdl: For Tally Erp 9
Create StockMRP.tdl:
[Report: Stock Item MRP] Title : "Stock Items with MRP" Type : Report Collection : Coll_StockItems[Collection: Coll_StockItems] Type : StockItem Fetch : Name, MRP, OpeningBalance
[Part: Part_StockItemMRP] Line : Line_ItemMRP tdl for tally erp 9
[Line: Line_ItemMRP] Fields : Fld_Name, Fld_MRP
[Field: Fld_Name] Use : Name Field Set as : $Name Create StockMRP
[Field: Fld_MRP] Use : Numeric Field Set as : $MRP Title : "MRP"
After loading, you’ll find the report under Gateway of Tally → Display → Stock Item MRP.
The default "Ledger-wise Summary" might not show what your CEO wants. TDL allows you to create a custom "Top 10 Profitable Customers" report with drill-down functionality. After loading, you’ll find the report under Gateway
To master TDL for Tally ERP 9, memorize these keywords:
| Keyword | Purpose | Example |
| :--- | :--- | :--- |
| ##SV | Current Value (Screen Value) | ##SVAmount |
| $$ | System Function / Evaluation | $$LocaleString |
| ## | Variable/Field Access | ##PartyName |
| IF ... THEN ... ELSE | Conditional logic | IF ##VoucherType = "Sales" THEN ... |
| Role: | User access control (Admin vs. User) | Role: Admin |
| Collection: | Data fetching | Collection: Ledgers Where IsGroup = "Yes" |
| Field: | Input/Display UI element | Field: MyDateField |
| Key: | Keyboard shortcuts | Key: Ctrl+Alt+R |
| Alert | Pop-up message box | Alert "Invalid Entry" |