TDL to view running balance in ledger in Tally 7.2/9.0

This is a guest post by Mr. Manoj who is a researcher in Tally and Excel. He has developed some useful utility related to Tally and excel.For more details, please read his profile.

In this article, Mr. Manoj will show you how to write a TDL program to view the running balance in ledger in Tally 7.2 or 9

if you wish to write for Free Learning Tally 0 and Accountancy then you can register yourself  and start writing.

Many tally users are very much interested to learn about TDL and the programming articles to  learn TDL fetched a good response from the readers of tallynine.com.

Learning Tally  TDL is relatively simple however you need to configure your tally.erp for TDL to active. If you are using an older version of tally e.g. Tally 9 or tally 7.2, then you can configure TDL by the below way.

Steps to configure Tally for TDL  set up

Open the Tally.ini in Tally folder,

Add line after user TDL=Yes

TDL=RunningBalance.txt

Copy and paste the below codes in a text file.

Rename it to RunningBalance.txt

save the file in your Tally Folder

Run Tally

view any ledger and you will find the new option of balance after the debit credit

Enjoy

The code  for TDL program for Running Balance is as below:

;;Sri Ganeshji Maharaj : Sri Balaji Maharaj : Sri Pitreshwarji Maharaj : Sri Durgaji : Sri Venkateshwara
;;——————————————————————————————————
;;Customer    -  Self
;;Tdl Type    – Auto Narration for Purchase, Journal Voucher, Running Balance, GRN Register
;;Date of Completion  – 1st Aug 2007
;;Last Modification    – 1st Aug 2006 – Manoj Garg
;;——————————————————————————————————-

[#Menu : Gateway of Tally]
;Delete: Item: Inven~tory Vouchers

[#Part: LV Body]
Total : MGDrCrTotal

[#Line : DSP VchAccTitles]
Add : Right Field : MGTitle

[Field: MGTitle]
Use       : Amount Title Field
Info      : “Balance”
Align     : Right
Style     : Normal Bold
Invisible : NOT ##IsLedgerReport

[#Field : DSP VchNumberTitle]
Invisible : ##BankRecMode OR $$InDraftMode OR NOT ##DBKDispVchYesNo

[#Field: DSP VchTypeTitle]
Invisible : ##BankRecMode OR $$InDraftMode OR NOT ##DBKDispVchTYesNo

[#Line : DSP VchAccDetail]
Add : Right Fields : MGDrCrTotal,MGTotal

[Field : MGTotal]
Use        : Amount Field
widtth   : @ @ amountwidtth
Set as     : $$NettAmount: @ @ LedOpening:$$SubTotal:MGDrCrTotal
Style  : if $$InPrintMode then “Normal” else “Normal Bold”
Format     : “DrCr”
Inactive   : $$IsVoucher AND NOT ##IsCCReport AND @ @ ShowForex
Invisible  : NOT ##IsLedgerReport

[Field : MGDrCrTotal]
Use        : Amount Field
widtth   : @ @ amountwidtth
Set as     : $$NettAmount:#DSPVchCrAmt:#DSPVchDrAmt
Invisible  : Yes

[#Field : DSP VchNumber]
Invisible : ##BankRecMode OR $$InDraftMode OR NOT ##DBKDispVchYesNo

[#Field: DSP VchType]
Invisible : ##BankRecMode OR $$InDraftMode OR NOT ##DBKDispVchTYesNo

;;—————— Print —————————————————————-

[#Line: LV OpeningBalance]
Add : Right Fields : MGTotal
Local : Field : MGTotal : Set As : “”

[#Line: LV FCOne]
Add : Right Fields : MGTotal
Local : Field : MGTotal : Set As : “”
Local : Field : MGTotal : Border : Full Thin Top
Local : Field : MGTotal : Indent : 0 mms

[#Line: LV FCTwo]
Add : Right Fields : MGTotal
Local : Field : MGTotal : Set As : “”

[#Line: LV FCThree]
Add : Right Fields : MGTotal
Local : Field : MGTotal : Set As : “”
Local : Field : MGTotal : Border : Flush Totals

;;——————Display————————————————-

[#Line: DSP VchOpAmt]
Add : Right Fields : MGTotal
Local : Field : MGTotal : Set As : “”

[#Line: DSP VchCurTotalAmt]
Add : Right Fields : MGTotal
Local : Field : MGTotal : Set As : “”

[#Line: DSP VchClAmt]
Add : Right Fields : MGTotal
Local : Field : MGTotal : Set As : “”

;;——————————————————————————————-

[System: Variables]
DBKDispVchYesNo : No
DBKDispVchTYesNo : No

[Variable : DBKDispVchYesNo]
Type       : Logical
Persistent : Yes

[Variable : DBKDispVchTYesNo]
Type       : Logical
Persistent : Yes

[#Part: LEDVCHCFG Common]
Add : Lines : Before : DBKExplodeBill : DBKDispVchNo,DBKDispVchtype
[Line : DBKDispVchNo]
Fields  : Medium Prompt, DBKDispVchNo
Local   : Field : Medium Prompt : Info : “Show Voucher No. ?”
[Field: DBKDispVchNo]
Use      : Logical Field
Modifies : DBKDispVchYesNo

[Line : DBKDispVchtype]
Fields  : Medium Prompt, DBKDispVchtype
Local : Field : Medium Prompt : Info : “Show Voucher Type ?”
[Field: DBKDispVchtype]
Use      : Logical Field
Modifies : DBKDispVchTYesNo

;;*************************************************************************************
[#Menu: Gateway of Tally]
Add: Item : BLANK
Add: Item :  support by Data~Cure : Display : Supportinfo
[#Menu: Company Info.]
Add : Item :  supp~ort by DataCure : Display :Supportinfo
[Report: Supportinfo]
Title :””
Forms :SupportForm
[Form : SupportForm]
Space Top : 0 inches
Add: Part : InvoiceTitle
Add: Part : InvoicePart
[Part: InvoiceTitle]
Border : Full Thin Bottom
Background : Light Petal Pink,Light Petal Pink
Add : Line : InvLineTitle
[Line : InvLineTitle]
Add : Field : InvFieldTitle
[Field : InvFieldTitle]
Set As:”Support Info.”
Style: Normal Bold
Align: Centre
Width: 50
[Part: InvoicePart]
Add: Line: InvoiceLine1
Add: Line: InvoiceLine3
Add: Line: InvoiceLine4
Add: Line: InvoiceLine5
Add: Line: InvoiceLine8
[Line : InvoiceLine1]
Add : Field : InvField3
[Line : InvoiceLine4]
Add : Field : InvField4
[Line : InvoiceLine8]
Add : Field : InvField9
[Line : InvoiceLine5]
Add : Field : InvField10
[Line : InvoiceLine3]
Add : Field : InvField13
[Field: InvField3]
Set As : “For Training / Support / Customisation / Implementation”
Style: Normal Bold
Align : Center
Width: 50
[Field: InvField4]
Set As :”Manoj Garg”
;Style: Large Bold
Style : Vtit
Align: Center
Width: 50
[Field: InvField9]
Set As :”Email : datacure @ gmail.com”
Align: Center
Width: 50
[Field: InvField10]
Set As :”Mobile : +91-9927199217″
Align: Center
Width: 50
[Field: InvField1]

[Style : Vtit]
Font : “Times New Roman”
Height : 20
Bold : Yes

[Field: InvField13]
Set As :”Contact”
Align: Center
Width: 50
Align: Center
Width: 50
;EOF

IF you are using Tally.erp 9, then you don’t need this TDL because in Tally.erp 9 this facility is already available by default. Trying to  use this code in Tally.erp 9  may result in an error in running your Tally like ‘Duplicate definition’ etc. But the coding surely will help to understand how to write proper code in Tally TDL

If you have any query on the TDL , then please post it on support forum only

  • http://fastworking.blogspot.com Rajiv Kumar Jain

    I have tried to do as suggested above, but it is showing some error in tally 9 whereas it is not working in tally 7.2. What is problem, I have also email to you for this solution

  • prakash chhajed

    i got this error when try to open any ledger
    bed formula
    Style : if $$InPrintMode then “Normal” else “Normal Bold”

  • Gagandeep Singh

    The same error as Mr. Prakash Chhajed is being noticed by me also.

    i.e. Style : if $$InPrintMode then “Normal” else “Normal Bold”
    Cannot understand formula.

    • http://www.tallynine.com Mahendra

      Gangdeep,
      Default tdl do not work with each and every release of tally!
      It has been already written in the article that it will work only with tally 7.2 and tally 9

  • C MUTHU KUMAR

    Above TDL is not working in my Tally 7.2 version 1.13.

  • vishesh

    not working on my tally 7.2.. :(

Optimization WordPress Plugins & Solutions by W3 EDGE