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

Latest Comments
  1. Rajiv Kumar Jain September 18, 2010
  2. prakash chhajed October 26, 2010
  3. Gagandeep Singh October 28, 2010
    • Mahendra October 28, 2010
  4. C MUTHU KUMAR October 10, 2011
  5. vishesh November 30, 2011

Leave a Reply

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

Optimization WordPress Plugins & Solutions by W3 EDGE