Business Control – Tally TDL

TDL (Tally Definition Language) are nerves system of Tally. With TDL files we can modify tally asper our requirement. In this segment I have something very special for you. 

With this Tally ERP9 TDL you can control your business by adding selling and purchase price amount in stock item and prevent billings beyond this..
Also can see last purchase and last selling price at voucher entry time.

[#Part: STKI Batch]
    Add:Line:At End:LWminprice,LWmaxprice
[Line:LWminprice]
    Space Top:0.1
    Field:Medium Prompt,LWminprice
    Local:Field:Medium Prompt:Set as:”Min Purc Price”
[Field:LWminprice]
    Use:Rate Price Field
    Set Always:Yes
    Width:10
    Storage:iteminsaleprice
[Line:LWmaxprice]
    Space Top:0.1
    Field:Medium Prompt,LWmaxprice
    Local:Field:Medium Prompt:Set as:”Max Sell Price”
[Field:LWmaxprice]
    Use:Rate Price Field
    Set Always:Yes
    Width:10
    Storage:itemaxsaleprice
[System:UDF]
    itemaxsaleprice:Rate:5628
    iteminsaleprice:Rate:6523
[#Field:VCHBATCH rate]
    Control:ValidityofPrice:if  ($$Value < $iteminsaleprice:Stockitem:$StockItemName or $$Value > $itemaxsaleprice:StockItem:$StockItemName)then Yes else No
[#Field: VCH rate]
    Control:ValidityofPrice:if  ($$Value < $iteminsaleprice:Stockitem:$StockItemName  or $$Value > $itemaxsaleprice:StockItem:$StockItemName) then Yes else No
[System:Formulae]
    ValidityofPrice:”Please enter rate between minimum and maximum  price as mentioned in stock item”

[*Collection: Vch Stock Item Extract]

Use : ExtractAlias Collection
Source Collection : Stock Item Src
Collection : StockItem PartNo With Closing
Title        : $$LocaleString:”List of Items                                     Stock Qty     LastSale Price  LastPurc Price”
Fetch        : Name, VchStkItmBalance,LastSalePrice,LastPurcPrice 
Set as : $FirstName
Keep Source : ().
Client Only : Yes
Format  : $VchStkItmBalance   : “Base”
Format  : $LastSalePrice: “Base”
Format  : $LastPurcPrice: “Base”
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.



Tags # TDL 2020 # TDL for Tally

     

Leave a Comment