LEDGER CLOSING TDL

TDLs are very useful if you use Tally accounting software. With TDL (Tally Definition Language) files we can modified Tally software and it’s reporting according to our needs. So today I have something special for you.

Sometime when we take ledger print or mail to our debtors or creditors for outstanding collection or payments, we need to fill closing balance in word form also. So this Tally TDL file will help you to add party closing balances in words.

The code is as under : 


[System: Formulae]
IfAmtthenOnlystring : If @@VchClg = 0 Then “” Else $$String:” Only”

[#Line: DSP VchClAmt]
Add : Left Field : ClBalinWord
Local : Field : Default: Style: normal bold
Local : Field : Default: Background: lily white
Local : Field : Default: Color: Blue 
Border: Thin Top Bottom:($$LineNumber = $$LastLineNumber ) AND $$InPrintMode


[#Line: LV FCthree]
Add : Left Field:ClBalinWord1
Local : Field : Default: Style: normal bold
Local : Field : Default: Background: lily white
Local : Field : Default: Color: Blue 
Border: Thin Top Bottom:($$LineNumber = $$LastLineNumber ) AND $$InPrintMode

[Field: ClBalinWord]
Set as: $$InWords:@@VchClg + @@IfAmtthenOnlystring
Color: Blue
Style: Large Bold 

;;www.learnwells.com

[Field: ClBalinWord1]
Set as:$$InWords:@@BalanceVchDrCrAmt + ” Only “
Color: Blue
Style: Large Bold
Print FG:Red
Indent:10
Width:50% Screen
Lines:0



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.



Leave a Comment