Learn TDL and Customize Tally Accounting Software

Online Training Sessions

2012-01-10T09:23:00.000+05:30

Shweta Softwares now provides live (real time) online training sessions to enable users to use its products more effectively and easily.

For more details, please refer http://www.rtslink.com/online-training-sessions/

Change MENU Options in Tally

2011-09-19T17:18:00.002+05:30

How can I move the Stock Summary option from "Gateway of Tally" to DISPLAY menu ?

Here's the TDL code :-

;;Remove the Stock Summary option from Gateway of Tally
[#Menu : Gateway of Tally]
 Delete : Item : @@locStockSummary
 
;;Add the Stock Summary option in Display Menu
[#Menu : Display Menu] 
 Add : Item : Before : @@locQuit : @@locStockSummary

Walk Collection - Example 4

2011-09-10T18:04:00.000+05:30

Here's a sample TDL program to get the Ledger Name and Address using the WALK COLLECTION statement.

;;Adds a new option to Gateway of Tally[#Menu : Gateway of Tally] Add : Item : Before : @@locQuit : Walk Collection - Example4 : Call : MyWalkCollectionExample4;;Collection definition based on Tally Internal Object named LEDGER[Collection : MyLedgers] Type  : Ledger ;;Expose/fetch the Name field and Address Collection Fetch   : Name, Address.*[Function : MyWalkCollectionExample4] 00 : SET FILE LOG ON 01 : LOG : "***************************"  ;; Loop through the Collection 05 : WALK COLLECTION : MyLedgers  ;;   Check the address. If empty, then skip the following code. 10 :  IF : $$IsEmptyCollection:Address 11:   CONTINUE 12 :  ENDIF ;;  Display the Ledger name  14 :  LOG : $Name   ;;  Loop through the Address Collection and display all the address lines 15 :  WALK COLLECTION : Address 20 :   LOG : "=>" + $Address 25 :  END WALK  30 : END WALK 90 : SET FILE LOG OFF 100 : Exec Command  : Notepad  : "TDLFunc.Log"

Walk Collection - Example 3

2011-09-10T16:43:00.000+05:30

Here's a sample TDL program to get the Voucher details for a specific Ledger using the WALK COLLECTION statement

;;Adds a new option to Gateway of Tally[#Menu : Gateway of Tally] Add : Item : Before : @@locQuit : Walk Collection - Example3 : Call : MyWalkCollectionExample3;;This is a new Collection definition which is based on Tally Internal Object named VOUCHER.;;It is filtered using the CHILDOF attribute. In other words, only those Vouchers which contain ;;the specifed Ledger are available in the collection.[Collection : MyVouchers] Type  : Vouchers : Ledger ChildOf : ##MyLedger Fetch   : *, LedgerEntries.*;;Function to display the Voucher details for a specified ledger[Function : MyWalkCollectionExample3] Variable : MyLedger : String 00 : SET FILE LOG ON 01 : LOG : "***************************"  ;; ********** TO DO - CHANGE THE LEDGER NAME HERE ****** ;;****************************************************** ;; Assign value to the variable MyLedger 02 : SET : MyLedger : "ABC Softwares"  ;; Loop through the Voucher table and display the vouchers 05 : WALK COLLECTION : MyVouchers 10 :  LOG : $$String:$Date + "," + $VoucherTypeName + "," + $VoucherNumber  ;;  Loop through the ledgers and display the Ledger-name and amount 15 :  WALK COLLECTION : LedgerEntries 20 :   LOG : "=>" + $LedgerName + "," + $$String:$Amount 25 :  END WALK  30 : END WALK 90 : SET FILE LOG OFF 100 : Exec Command  : Notepad  : "TDLFunc.Log"

Walk Collection - Example 2

2011-09-10T16:38:00.001+05:30

Here's a sample TDL program to get the Voucher details with all ledgers using the WALK COLLECTION statement.

;;Adds a new option to Gateway of Tally[#Menu : Gateway of Tally] Add : Item : Before : @@locQuit : Walk Collection - Example2 : Call : MyWalkCollectionExample2;;This is a new Collection definition which is based on Tally Internal Object named Voucher which contains Voucher details[Collection : MyVouchers] Type  : Voucher Fetch   : *, LedgerEntries.*;;Function to display the Voucher details[Function : MyWalkCollectionExample2] 00 : SET FILE LOG ON 01 : LOG : "***************************"  ;; Loop through the Voucher table and display the vouchers 05 : WALK COLLECTION : MyVouchers 10 :  LOG : $$String:$Date + "," + $VoucherTypeName + "," + $VoucherNumber  ;;  Loop through the ledgers and display the Ledger-name and amount 15 :  WALK COLLECTION : LedgerEntries 20 :   LOG : "=>" + $LedgerName + "," + $$String:$Amount 25 :  END WALK  30 : END WALK 90 : SET FILE LOG OFF 100 : Exec Command  : Notepad  : "TDLFunc.Log"

Walk Collection

2011-09-09T18:27:00.000+05:30

Here's a sample TDL program to get the Voucher details using the WALK COLLECTION statement.

;;Adds a new option to Gateway of Tally[#Menu : Gateway of Tally]    Add    : Item    : Before : @@locQuit    : Walk Collection - Example1      : Call    : MyWalkCollectionExample1    ;;This is a new Collection definition which is based on Tally Internal Object named Voucher which contains Voucher details[Collection : MyVouchers]    Type     : Voucher    Fetch   : *, LedgerEntries.*;;Function definition ;;Displays the Voucher details[Function : MyWalkCollectionExample1]    00 : SET FILE LOG ON    01 : LOG : "***************************"    05 : WALK COLLECTION : MyVouchers    10 :     LOG : $$String:$Date + "," + $VoucherTypeName + "," + $$String:($LedgerEntries[1].LedgerName) + "," + $$String:$LedgerEntries[1].Amount    20 : END WALK    90 : SET FILE LOG OFF    100 : Exec Command        : Notepad     : "TDLFunc.Log"

Jan Lokpal Bill - How to get details of M.P in your Area

2011-08-21T17:52:00.000+05:30

Friends,

Here's the link to get the details of the Member of Parliament of your Area :-
http://india.gov.in/howdo/otherservice_details.php?service=23

Those you wish, may lodge their views / protest against the Government version of Lokpal bill by sending a simple letter to your M.P.

About Tally ERP

2011-04-12T19:12:00.000+05:30

We have started a new blog to discuss and disseminate information about Tally ERP.

For more information, please visit http://www.rtslink.com/tally-erp

India against Corruption

2011-03-26T10:15:00.000+05:30

India against corruption is a movement created by concerned citizens from all spheres, professions who have come together to fight corruption in India.

Anna Hazare sits on fast unto death from 5th April for strong anti-corruption laws.

Appeal to do what you can :-
1) If you can, spare some time and go through the site http://www.indiaagainstcorruption.org and do communicate to your friends.
2) If you can, provide your valuable comments....

Guidelines for Tally Customization Services Providers

2011-03-18T12:34:00.002+05:30

Tally Solutions has recently provided some useful guidelines for Tally Solution providers. This would be helpful both for the Solution providers and the End-Users (Customers).

Below are few key guidelines while engaging with the customers on Solution Business:

· AMC on Code Maintenance

Make sure that you state (in writing), the need for your customers to enter into an AMC on customization so that the code is maintained for future version & release compatibility. This is typically 30% (of customization cost) per year and is payable 90 days after go-live. Alternatively mention that code rework will cost INR 5,400/7,200 per man day in case customer does not want to go for AMC.

In case you have not made this clear for existing customizations, please ensure that you do so at the earliest to avoid conflicts.

· IP (Intellectual Property) of the Customization Code

The communication in the proposal has to be very clear on who owns the IP (Source Code) of the customization done: is it your customer or you.

· Testing Timelines

Proposal should contain clear timelines for the customer to test the customization and get back with any issues. This is typically 90 days from final implementation.

Solution Business engagement templates (listed below) are available in this link ‘Partner Portal (www.tallysolutions.com - use your login) > Resource Centre > Tally Integrator’

· Pre-Proposal Checklist

· Requirement Specification Template

· Commercial Proposal (2 formats)

· Customization Proposal

· Implementation – Project Plan

· Options for Service Agreement

· High-Level Design Template

· Low-Level Design Template

· Sample Data

· Web Integration POC

Tally ERP 9 to SQL Server

2011-01-01T16:12:00.000+05:30

Here's a VB6 program which allows you to get data from Tally ERP 9 into SQL Server database.

DX-Fusion - Tally to database

2010-10-09T09:56:00.000+05:30

DX-Fusion (Free Edition) is an utility that transfers data from Tally ERP 9 into your database. It transfers all masters and all vouchers without any restriction on date or voucher-type or number of records.

You can get more details about DX-fusion at http://www.rtslink.com/dx-fusion/index.html

The DX-fusion (Commercial Editions) supports transfer of all masters and vouchers from Tally into your database in Real-time (online mode).

Multi Account Printing option

2010-03-24T15:54:00.004+05:30

In Tally educational mode, the Multi Account Printing option does NOT appear. Here's the TDL code that allows you to get the same.

[#Menu: Gateway of Tally]
Add : Key Item : After : @@locDisplay : Multi Account Printing : M : Menu : RTSPrinting Menu

[Menu: RTSPrinting Menu]
Title : $$LocaleString:"Printing Menu"
Key Item : @@locAccountBooks : A : Menu : Print Account Books : $$IsAccountingOn:$$CurrentCompany
Key Item : @@locOutstandingStatements : O : Menu : Print Outstandings : $$IsAccountingOn:$$CurrentCompany AND $$IsBillWiseOn:$$CurrentCompany
Item : BLANK
Key Item : @@locInventoryBooks : I : Menu : Print Inventory Books : $$IsInventoryOn:$$CurrentCompany
Item :
Key Item : @@locDayBook : D : Print : Day Book : NOT $$IsEmpty:$$SelectedCmps
Item : BLANK
Key Item : @@locMultiVoucherPrinting : M : Print : Multi Voucher Print : NOT $$IsEmpty:$$SelectedCmps
Key Item : @@locMultiPayslipPrinting : P : Print : Multi Payslip Print : NOT $$IsEmpty:$$SelectedCmps AND $$IsPayrollOn:$$CurrentSimpleCompany
Item : BLANK
Key Item : @@locQuit : Q

Control : @@locOutstandingStatements : $$Allow:Print:Outstandings AND $$IsAccountingOn:$$CurrentCompany AND $$IsBillWiseOn:$$CurrentCompany
Control : @@locInventoryBooks : $$IsInventoryOn
Control : @@locDayBook : $$Allow:Print:DayBook
Control : @@locMultiPayslipPrinting : $$IsPayrollOn AND $$MODPayroll AND $$Allow:Print:PayrollReports

Download the file multi-accounting-printing.zip

To use this file, you must make changes in the Tally.ini file as shown below :-

User TDL = Yes
TDL = c:\tally\multi-account-printing.txt

Recycle bin for Tally ERP 9

2009-11-27T17:40:00.004+05:30

Recycle bin is now available for Tally ERP 9.

For more information visit Recycle Bin for Tally ERP 9

TDL Reference Manual

2009-11-17T11:10:00.002+05:30

Download the complete TDL Reference Manual (By Tally Solutions, Bangalore).

PS:
TDL, Tally definition language. Tally ERP are trademarks or registered trademarks of Tally Solutions, Bangalore

RTS-XQuery Freemium - A FREE add-on utility for Tally Software

2009-11-04T06:18:00.004+05:30

RTS-XQuery Freemium

Here's a FREE add-on utility for Tally Accounting Software that facilitates transfer of data from
a) Tally to Excel
b) Tally to Foxpro DBF
c) Tally to SQL-Server
d) Tally to MySQL
e) Tally to other popular databases.

More on RTS-XQuery Freemium
1) Get raw data (with or without Inventory details) from Tally into Excel or Tally to any other database (single or multiple tables).
2) Get Reports as per your requirement (Refer "party-and-stockitem-wise-sales" in the xquery samples)

Visit http://www.rtslink.com/rts-xquery-freemium/

Free TDL extensions to Tally ERP 9

2009-10-29T05:19:00.004+05:30

Here are some FREE TDL extensions for Tally ERP 9 which have provided by Tally Solutions, Bangalore.

Auto Backup
Auto Bank Reconciliation
Auto Manual Voucher Numbering
Automatic Cheque Number Generation
Auto Fill from PRN
Barcode Label Printing
Cheque Number Tracking
Cost Centre Wise Balance Sheet
Cost Centre Wise Profit & Loss
Credit Control on Days
Godown Security
Inter Company Data Transfer
Logo Print in Invoice
Multi Voucher Print
Negative Cash Control
Negative Stock Control
Print User Name in all the default Reports and VouchersPrice List Import from Excel
Purchase to Purchase Order
Stock Group wise Inventory total in Invoice printSynchronise as a consolidated Journal Voucher
Stock Items with Multi-line Description
Voucher Authorisation

Visit Tally Solutions to download the above.

You can alternatively download all the files in a single ZIP file from this link :-
Free-TDL-extensions.

Merge two Ledgers - UDIMagic TCP Source Code

2009-02-23T16:41:00.004+05:30

Those facing difficulties in using UDIMagic FREE Edition with some specific Tally versions can now use the UDIMAGIC.TXT file to solve the issue.

The UDIMagic TCP Source-code file is not provided separately but is available with the UDIMagic FREE Edition v1.0 Release 2.3. Hence, you must download and install the new version to get the source-code file (viz udimagic.txt)

Make changes in your Tally.ini to include the UDIMAGIC.TXT file as shown below :-

User TDL = Yes
tdl = c:\UDIMagicFreeEdition\udimagic.txt

Merge two Legders - Installing UDIMagic FREE Edition

2009-02-19T16:19:00.007+05:30

UDIMagic FREE Edition uses a TCP file. Before you use this utility, you need to make some changes in the Tally.ini (configuration file).

Here are the Steps for Installing UDIMagic FREE Edition utility and to make changes in the Tally.ini file.

PS:
UDIMagic FREE Edition has been tested with the following Tally versions viz
- Tally 9 Release 3 [BETA]
- Tally 9 Release 2.14
- Tally 7.2 Release 3.12

Merge two Ledgers

2009-02-17T17:51:00.002+05:30

Here's a FREE Tally utility that allows you to Merge two Ledgers.

How to convert Tally 9 TCP files to Tally 9 Release 3 [Beta] format ?

2008-12-13T06:08:00.002+05:30

Here are the steps to convert your existing TCP files to Tally 9 Release 3 [Beta] format

Recycle-bin TCP for Tally 9 Release 3 [Beta]

2008-12-08T21:47:00.000+05:30

Here's Recycle-bin TCP for Tally 9 Release 3 [Beta].

Usage:-
1) Download and copy the TCP file to the folder where Tally 9 Release 3 [Beta] is installed.
2) Make changes in the Tally.ini file as shown below:-

User TDL = Yes
tdl = c:\Tally9\rbin9v-release3.tcp

Learn Tally XML tags

2008-07-09T05:36:00.001+05:30

Learn "How to write XML tags to import data into Tally Software ?" at http://learn-tally-xml-tags.blogspot.com

Additional References:-
1) Excel to Tally
2) SQL to Tally
3) MySQL to Tally
4) DBF to Tally
5) MS-Access to Tally

Recycle-bin for Tally - Incorrect / Missing link

2008-02-24T17:36:00.000+05:30

While going through ApniTally, I noticed that the link given for Recycle bin for Tally was incorrect/missing. It seems that this might have happened some-time back as we had changed our Web-server .

For those who had problems in accessing / downloading the Recycle bin TCP, here's the correct link.

Download Recycle bin for Tally

Introducing udiMagic v3.0

2008-01-02T08:09:00.000+05:30

UDI-Magic in now available in two versions viz.

UDI-Magic v3.0 [Standard]
Supports transfer of data from Excel to Tally and vice versa. (i.e. push and pull Tally data from/to MS-Excel).

UDI-Magic v3.0 [Professional]
Supports transfer of data from external databases to Tally viz.
MySQL to Tally
MS-Access to Tally

The professional version is a superset of the standard version and includes all the features of the standard version.

Other new features in udiMagic version 3.0
Using separate file for XML tags
Using VBA macros with udi-Magic

Salesman UDF - User defined field

2007-12-15T17:55:00.000+05:30

TDL24.zip which creates a Salesman field had been put-up on this blog-site long back. As there have been some queries relating to this TDL recently, we are providing some more details about it :-

TDL24.zip contains the following files:-
a) tdl24.txt (TDL Source-code for Tally 7.2)
b) tdl24.tcp (Compiled TDL code for Tally 7.2)

c) tdl9v24.txt (TDL Source-code for Tally 9)
d) tdl9v24.tcp (Compiled TDL code for Tally 9)

Though most of the code for tdl24.txt and tdl9v24.txt is same, the main difference is given below:-

Tally 9 TDL code

[#Part: CMP AccFeat Left]
.... rest of the code

Tally 7.2 TDL code

[#Part: CMP Advanced Features]
.... rest of the code

For Tally 9 users
How to enable Salesman UDF and input master-records ?

a) In the Gateway of Tally, press F11 to change FEATURES.
b) Next, select option "Accounting features"
c) Next, set the option "Enable Salesman" to Yes and input the Salesman records.

After enabling the Salesman UDF feature, you shall be able to view/input the Salesman Name in the SALES voucher entry screen.

For Tally 7.2 users
How to enable Salesman UDF and input master-records ?

a) In the Gateway of Tally, press F11 to change FEATURES.
b) Next, set the option "Set/modify other Company features" to Yes
c) Next, set the option "Enable Salesman" to Yes and input the Salesman records.

After enabling the Salesman UDF feature, you shall be able to view/input the Salesman Name in the SALES voucher entry screen.

Download the TDL24.ZIP file

Using the $$FilterValue function

2007-10-18T18:53:00.000+05:30

$$FilterValue Function

Syntax :

$$FilterValue : ValueExpression : CollectionName : PositionSpecifier : FilterExpression

Remarks:-
1) The $$FilterValue function allows you to apply a filter (FilterExpression) on a specified Collection (CollectionName), and
2) Get the first or the last Object (PositionSpecifier) of that filtered list and
3) Retrieve the value of any field/method (ValueExpression) of the first or last object as specified by PositionSpecifier.

Example 45: Using the $$Table function to lookup values in a Table

2007-09-03T17:31:00.000+05:30

This program illustrates how to use the $$TABLE function to lookup records in a Table.

Herein, we shall create a Collection of STOCK ITEM's having two fields viz. Item-Name and Part-number. When the user selects an ITEM from the list, it's Part-Number must be automatically displayed.

Download TDL45

;;Program  :- TDL45.TXT
;;Author   :- Shweta Computers
;;Objective:- Using $$Table to lookup/fetch field values


[#Menu: Gateway of Tally]
    Item: TDL45 : Alter: My ItemReport


[Report: My ItemReport]
    Form: My ItemForm


[Form: My ItemForm]
    Part: My ItemPart


[Part: My ItemPart]
    Line: My Line1, Myline2


[Line: My Line1]
    Fields: Short Prompt, My ItemName
    Local: Field: Short prompt: Set as: "Item Name:- "


[Line: My Line2]
    Fields: Short Prompt, My ItemPartNo
    Local: Field: Short prompt: Set as: "Part Number:- "


[Field: My ItemName]
    Use: Name Field


    ;;Variable to hold the user-input
    Modifies: varItemName


    ;;Specify the Collection Name
    Table: My ItemList


    Show Table: Always


[Field: My ItemPartNo]
    Use: Name Field


    ;;Variable to hold the user-input
    Modifies: varItemPartNo


    Set as: $$Table:MyItemName:$PartNo


    ;;Required to assign value automatically on selection of ItemName
    Set Always: Yes

    
[System: Variables]
    varItemName: ""
    varItemPartNo: ""


[Variable: varItemName]
    Type: String


[Variable: varItemPartNo]
    Type: String


[Collection: My ItemList]
    Title: "Item List"
    ListName : $$SysName:EndOfList
    Objects: Item1,Item2,Item3,Item4,Item5


[Object: Item1]
    Name: "Bush"
    PartNo: "1001"


[Object: Item2]
    Name: "Piston"
    PartNo: "1002"


[Object: Item3]
    Name: "Gear Box"
    PartNo: "1003"


[Object: Item4]
    Name: "O-Ring"
    PartNo: "1004"


[Object: Item5]
    Name: "Camshaft"
    PartNo: "1005"

Notes:-

1) $$Table function accepts two arguments. 
   Syntax:-
   $$Table : <LookupExpr> : <LookupField>

   Herein, the $$Table function searches for <LookupExpr> and returns the value for field <LookupField>.

Tally Software TDL functions

2007-08-29T06:50:00.000+05:30

The following Tally Software TDL functions have been now included / covered :-

$$MonthOfDate
$$MonthStart
$$MonthEnd
$$SystemPeriodFrom
$$SystemPeriodTo
$$YearOfDate
$$YearEnd

Refer www.rtslink.com

Recycle bin for Tally Software with Source code

2007-08-27T07:10:00.000+05:30

Recycle bin is a FREE add-on utility for Tally Software.

It enables you to retrieve Voucher entries that you may have accidentally deleted in Tally Software. It is similar to the Windows recycle-bin and works with Tally 7.2 and Tally 9.

Supports Tally 7.2 and Tally 9 Software.

View/Download the Recycle bin TCP Source-code.

Example 44: Adding FILTER button to MyDaybook

2007-08-24T18:25:00.001+05:30

This program TDL44.TXT is an extension to my earlier program TDL43.TXT. It adds the FILTER button to My Daybook Report.

There are few minor modifications done to acheive the task:-
a) Add FILTER button to the FORM
b) Add few variables at the REPORT definition level

Download TDL44

The new code has been shown as highlighted.

;; PROGRAM: TDL44.TXT
;; AUTHOR : Shweta Computers
;;
;; Objective:- Adding Filter button to MyDaybook
;;======================================================================


;;Global Formula. Used to assign a simple text string to a Global constant.
[System: Formula]
    MYDBKTDL: $LocaleString:"Daybook"


;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]
    Item: @@MYDBKTDL : Display: My DBKTDL


    ;;Control whether the menu-option is displayed or not?
    Control: @@MYDBKTDL: $Allow:Display:Daybook


    ;; Syntax for $Allow
    ;; $Allow : <mode> : <family report name>
    ;; Return Value : Logical


[Report: MYDBKTDL]


    Family: $Translate:"Daybook"
    ;; The attribute FAMILY specifies that this Report (i.e. MYDBKTDL)
    ;; belongs to a Family (report) named Daybook.
    ;; DAYBOOK is a pre-defined report and here we are specifying that
    ;; MYDBKTDL report belongs to the same DAYBOOK family.
    ;; This will affect ACCESS to MYDBKTDL report.
    ;; Now, when we change the ACCESS to DAYBOOK report using option
    ;; "Gateway of Tally -> Alt+F3 -> Security Features".
    ;; it will automatically affect the report MYDBKTDL


    Title: $LocaleString:"Daybook"
    Form : My Form


    ;;Variables used in the Report
    Variables: SVFromDate,SVToDate,SVSortMethod
    Variables: ExplodeFlag, ExplodeNarrFlag
    Variables: OnlyAccVouchers,OnlyInvVouchers


    Set: SV SortMethod : @@Default
    Set: SVFromDate: $$MonthStart:##SVCurrentDate
    Set: SVToDate: $$MonthEnd:##SVCurrentDate


    ;;Required for F12 Configuration
    Repeat: SVColumntype, SVColumnName


    ;;PRINTSET affects the variables related to Printing, whereas
    ;;SET is used to assign values to variables used otherwise.
    PrintSet: ReportTitle: $LocaleString:"Daybook"
    PrintSet: PrintFileName: "Daybook"


[Form: My Form]


    ;;Pre-defined button. Adds the Print button
    Button: PrintButton


    ;;EXPLODEFLAG is a pre-defined button in Default Tally.
    ;;Try using KEY instead of BUTTON, Alt+F1 still works,
    ;;but the "Alt+F1" button is not displayed
    Button: ExplodeFlag


    ;;Pre-defined button. Required for F12 configuration
    Button: DYBKConfigure


    ;;Pre-defined button. Filter records using Alt+F12 key
    Button: FilterButton


    Space Top   : if $$InPrintMode then ##SVSpaceTop else 0.05 inches
    Space Bottom: if $$InPrintMode then 0.5 else 0.05 inches
    Space Left  : if $$InPrintMode then 0.5 else 0.05 inches
    Space Right : if $$InPrintMode then 0.25 else 0.05 inches


    Part: My DB Title,My DB Body


[Part: My DB Title]


    ;;Optional Parts
    Option: My DB PrntTitle  : $$InPrintMode
    Option: My DB ScrTitle   : NOT $$InPrintMode


[!Part: My DB PrntTitle]


    ;;This is a pre-defined part in default TDL
    Use: DSP AccTitles


[!Part: My DB ScrTitle]
    Line: My DB Title


[Line: My DB Title]
    Field : Name Field
    Local : Field : Name Field : Set as : $$LocaleString:"Daybook"


[Part: My DB Body]
    Line: My Line
    Scroll: Vertical
    Common Border: Yes
    Repeat : My Line: My Collection


[Line: My Line]
    Left Fields: Myfld1,MyFld2
    Right Fields: MyFld3,MyFld4


    ;;This Shows the Ledger details when Alt+F1 key is pressed
    Explode: MyExplodePart : ##ExplodeFlag


[Field: Myfld1]
    ;;TYPE attribute specifies the data-type of the field
    Type   : Date
    Set as : $Date


[Field: Myfld2]
    Use    : Name Field
    Set as : $$CollectionField:$LedgerName:1:AllLedgerEntries


[Field: Myfld3]
    Use    : Short Name Field
    Set as : $VoucherTypeName


[Field: Myfld4]
    Use    : Amount Field
    Set as : $Amount


;;Important:-
;;This PART is displayed when EXPLODEFLAG variable is set to Yes
;;i.e. When user presses Alt+F1 key
[Part: MyExplodePart]
    Line : MyExplodline
    Line : MyExplodeNarrLine


    ;;Repeats the line MyExplodeLine to display the AllLedgerEntries
    ;;Collection fields
    Repeat : MyExplodline : AllLedgerEntries


;; Specify the fields that you wish to display when the PART is Exploded
[Line: MyExplodline]

    ;;Show this field on the left side of the line
    Add: Left Fields: fldExplodeLedger,fldExplodeAmount


    ;;This skips the first object of Collection AllLedgerEntries
    Empty: $$IsFirstObj


;;Ledger Name field
[Field: fldExplodeLedger]
    Indent : 10
    Use    : Name Field
    Set as : $LedgerName
    Style  : Small Italic
    Width  : @@NameWidth


;;Amount field
[Field: fldExplodeAmount]
    Use    : Amount Field
    Set as : $Amount
    Style  : Small Italic
    Width  : @@ShortWidth


;; Line to Display Narration
[Line: MyExplodeNarrline]
    Add: Left Fields: fldExplodeNarration


;;Display Narration field
[Field: fldExplodeNarration]
    Indent : 12
    Use    : Name Field
    Set as : $Narration
    Style  : Small Italic
    Width  : @@NameWidth


;;Collection definition
[Collection: My Collection]
    Type: Voucher


Notes:-
1) This program is an extension of program TDL43.TXT
2) Herein, we have added Filter button to the MyDaybook Report.
To Filter records, press Alt+F12

TDL functions for Tally Software

2007-08-21T10:30:00.000+05:30

The following TDL functions have been now included / covered :-

$$Upper
$$String
$$StringLength
$$StringPart
$$StringRemWord
$$StringWord

Refer www.rtslink.com

Example 43: Adding Narration line and F12 key functionality to My Daybook

2007-08-20T16:15:00.000+05:30

This program TDL43.TXT is an extension to my earlier program TDL42.TXT. It adds the following functionality to the program TDL42.TXT (i.e. My Daybook Report)

a) Display the Narration line
b) Add F12 Configuration button

Please note that pressing F12 key displays the Configuration screen that contains several options. This programs addresses only the Narration option (and Condensed/Detailed) in the Configuration screen.

Download TDL43

The new code has been shown as highlighted.

;; PROGRAM: TDL43.TXT
;; AUTHOR : Shweta Computers
;;
;;Objective:-
;;To display Narration line and provide F12 Configuration key functionality
;;in My Daybook
;;======================================================================


;;Global Formula. Used to assign a simple text string to a Global constant.
[System: Formula]
    MYDBKTDL: $LocaleString:"Daybook"


;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]
    Item: @@MYDBKTDL : Display: My DBKTDL


    ;;Control whether the menu-option is displayed or not?
    Control: @@MYDBKTDL: $Allow:Display:Daybook


    ;; Syntax for $Allow
    ;; $Allow :  : 
    ;; Return Value : Logical


[Report: MYDBKTDL]


    Family: $Translate:"Daybook"
    ;; The attribute FAMILY specifies that this Report (i.e. MYDBKTDL)
    ;; belongs to a Family (report) named Daybook.
    ;; DAYBOOK is a pre-defined report and here we are specifying that
    ;; MYDBKTDL report belongs to the same DAYBOOK family.
    ;; This will affect ACCESS to MYDBKTDL report.
    ;; Now, when we change the ACCESS to DAYBOOK report using option
    ;; "Gateway of Tally -> Alt+F3 -> Security Features".
    ;; it will automatically affect the report MYDBKTDL


    Form : My Form


    ;;Title of the Report
    Title: $LocaleString:"Daybook"


    ;;This variable is used in the current Report
    Variables: ExplodeFlag, ExplodeNarrFlag


      ;;Required for F12 Configuration
    Set : IsDaybook: Yes
    Repeat: SVColumntype, SVColumnName


    ;;PRINTSET affects the variables related to Printing, whereas
    ;;SET is used to assign values to variables used otherwise.
    PrintSet: ReportTitle: $LocaleString:"Daybook"
    PrintSet: PrintFileName: "Daybook"


[Form: My Form]


    Button: PrintButton
    ;;PrintButton is a pre-defined button. We just add is here.


    Button: ExplodeFlag
    ;;EXPLODEFLAG is a pre-defined button in Default Tally.
    ;;Try using KEY instead of BUTTON, Alt+F1 still works,
    ;;but the "Alt+F1" button is not displayed


      ;;Required for F12 configuration
    Button: DYBKConfigure


    Space Top   : if $InPrintMode then ##SVSpaceTop else 0.05 inches
    Space Bottom: if $InPrintMode then 0.5 else 0.05 inches
    Space Left  : if $InPrintMode then 0.5 else 0.05 inches
    Space Right : if $InPrintMode then 0.25 else 0.05 inches


    Part: My DB Title,My DB Body


[Part: My DB Title]


    ;;Optional Parts
    Option: My DB PrntTitle  : $InPrintMode
    Option: My DB ScrTitle   : NOT $InPrintMode


[!Part: My DB PrntTitle]


    Use: DSP AccTitles
    ;;This is a pre-defined part in default TDL


[!Part: My DB ScrTitle]
    Line: My DB Title


[Line: My DB Title]
    Field : Name Field
    Local : Field : Name Field : Set as : $LocaleString:"Daybook"


[Part: My DB Body]
    Line: My Line


    Repeat : My Line: My Collection
    ;;Syntax:-
    ;;Repeat :  : 


    Scroll: Vertical


    ;;Shows border
    Common Border: Yes


[Line: My Line]
    Left Fields: Myfld1,MyFld2
    Right Fields: MyFld3,MyFld4


    ;;This Shows the Ledger details when Alt+F1 key is pressed
    Explode: MyExplodePart : ##ExplodeFlag


[Field: Myfld1]
    ;;TYPE attribute specifies the data-type of the field
    Type   : Date
    Set as : $Date


[Field: Myfld2]
    Use    : Name Field
    Set as : $CollectionField:$LedgerName:1:AllLedgerEntries


[Field: Myfld3]
    Use    : Short Name Field
    Set as : $VoucherTypeName


[Field: Myfld4]
    Use    : Amount Field
    Set as : $Amount


;;Important:-
;;This PART is displayed when EXPLODEFLAG variable is set to Yes
;;i.e. When user presses Alt+F1 key
[Part: MyExplodePart]
    Line : MyExplodline
    Line : MyExplodeNarrLine


    ;;Repeats the line MyExplodeLine to display the AllLedgerEntries
    ;;Collection fields
    Repeat : MyExplodline : AllLedgerEntries


;; Specify the fields that you wish to display when the PART is Exploded
[Line: MyExplodline]

    ;;Show this field on the left side of the line
    Add: Left Fields: fldExplodeLedger,fldExplodeAmount


    ;;This skips the first object of Collection AllLedgerEntries
    Empty: $IsFirstObj


;;Ledger Name field
[Field: fldExplodeLedger]
    Indent : 10
    Use    : Name Field
    Set as : $LedgerName
    Style  : Small Italic
    Width  : @@NameWidth


;;Amount field
[Field: fldExplodeAmount]
    Use    : Amount Field
    Set as : $Amount
    Style  : Small Italic
    Width  : @@ShortWidth


;; Line to Display Narration
[Line: MyExplodeNarrline]
    Add: Left Fields: fldExplodeNarration


;;Display Narration field
[Field: fldExplodeNarration]
    Indent : 12
    Use    : Name Field
    Set as : $Narration
    Style  : Small Italic
    Width  : @@NameWidth


;;Collection definition
[Collection: My Collection]
    Type: Voucher


Notes:-
1) This program is an extension of program TDL42.TXT
2) We have added functionality to display the Narration line
3) We have added functionality for F12 Configuration key

TDL functions for Tally Software

2007-08-20T11:41:00.000+05:30

The following TDL functions have been now included / covered :-

$$Alias
$$Allow
$$SerialNumber
$$SelectedCmps
$$SysName

Refer www.rtslink.com

TDL Functions

2007-08-18T02:52:00.000+05:30

The following TDL functions have been now included / covered :-

$$Abs
$$Max
$$Min
$$Round
$$RoundDown
$$RoundUp
$$ZeroFill

Refer www.rtslink.com

TDL Functions

2007-08-16T12:08:00.000+05:30

The following TDL functions have been now included / covered :-

$$LocaleString
$$InPrintMode
$$IsFirstObject
$$Value
$$IsEmpty

Refer www.rtslink.com

Example 40: Accessing fields of an Object

2007-08-15T10:02:00.000+05:30

This post illustrates how to access fields (i.e. Internal methods) of "Ledger" object. You can similary access other objects also.

Download TDL40

;; PRODUCT: TDL40.TXT
;; AUTHOR: Shweta Computers

;;Objective:-
;;Accessing fields (Internal Methods) of an Object
;;======================================================================

;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]

;;The ACTION used here is DISPLAY
Item: Example 40: Display: My Report

[Report: My Report]
Form : My Form
Title: $$LocaleString:"Accessing Fields of an Object"

[Form: My Form]
Part: My Part

[Part: My Part]
Line: My Line1,My Line2

;;Shows border
Common Border: Yes

[Line: My Line1]
Left Fields: Short Prompt,Myfld1
Local: Field: Short Prompt : Set as : "Ledger Balance"

[Line: My Line2]
Left Fields: Short Prompt,Myfld2
Local: Field: Short Prompt : Set as : "Group Name"

[Field: Myfld1]
Use    : Name Field
Set as : $ClosingBalance:Ledger:"Cash"

[Field: Myfld2]
Use    : Name Field
Set as : $Parent:Ledger:"Cash"


NOTES:
1) Accessing fields of an Object
Syntax:-
<FieldName> : <Object> : <Filter Value>

Example:-
$Closingbalance : Ledger : "Cash"

Explanation:
a) $Closingbalance is a field of Object LEDGER. It is also called Internal Method
b) The 2nd parameter is the LEDGER Object
c) The 3rd parameter is the LEDGER Name ("Cash") whose field
   value is to be retrieved.

2) Short Prompt is a pre-defined field. Herein, we are using LOCAL attribute
to modify the definition of the field Short Prompt which is effective only
in this Report.

Example 42: Adding Access-control functionality to menu-options

2007-08-15T06:42:00.000+05:30

This post illustrates how to add Access-control functionality to menu-option MyDBKTDL (MyDaybook). This program (i.e TDL42) is an extension to our earlier program TDL41.

To understand this program, you must enable the Security features in your Company. It is advised to try out this program in a Dummy Company.

Steps enable Security Control:-
1) Open any Company (say Dummy)
2) Press Alt+F3 in the "Gateway of Tally" menu. This will bring forth "Company Info" screen.
3) Select option "Alter" and select the Company Name.
4) In the "Company Alteration" screen, set "Security Control" to YES and enter the ADMIN-name and password. Save the Company details.

Steps to Create new User:-
1) Press Alt+F3 in the "Gateway of Tally" menu and then select "Security Control" option.
2)Next, select option "Users and passwords" to create a user. Enter any Username (say ABC) and password and then set the "Security Level" to DATA ENTRY.

Steps to Assign rights to the new User:-
1) Press Alt+F3 in the "Gateway of Tally" menu and then select "Security Control" option.
2)Next, select option "Types of Security" and then disallow access to Report DAYBOOK to the User that you have created.

Summary
In the above mentioned steps, we have
a) Enabled "Security Control" in the Company Alteration screen
b) Created a new user.
c) Disallowed Access-rights to DAYBOOK report to the new User (ABC).

As you can see, we have restricted the newly created USER from Accessing the DAYBOOK Report. Now, in program TDL42, we create a new report MYDBKTDL which belongs to the DAYBOOK family. As a result, the ACCESS-CONTROL for DAYBOOK applies to MYDBKTDL also.

Download TDL42

;; PROGRAM: TDL42.TXT
;; AUTHOR : Shweta Computers

;;Objective:-
;;Allow/Disallow Access-control to Menu option that we have added in
;;Gateway of Tally
;;======================================================================

;;Global Formula. Used to assign a simple text string to a Global constant.
[System: Formula]
MYDBKTDL: $$LocaleString:"Daybook"

;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]
Item: @@MYDBKTDL : Display: My DBKTDL

;;Control whether the menu-option is displayed or not?
Control: @@MYDBKTDL: $$Allow:Display:Daybook

;; Syntax for $$Allow
;; $$Allow : <mode> : <family report="" name="">
;; Return Value : Logical

[Report: MYDBKTDL]

Family: $$Translate:"Daybook"
;; The attribute FAMILY specifies that this Report (i.e. MYDBKTDL)
;; belongs to a Family (report) named Daybook.
;; DAYBOOK is a pre-defined report and here we are specifying that
;; MYDBKTDL report belongs to the same DAYBOOK family.
;; This will affect ACCESS to MYDBKTDL report.
;; Now, when we change the ACCESS to DAYBOOK report using option
;; "Gateway of Tally -> Alt+F3 -> Security Features".
;; it will automatically affect the report MYDBKTDL

Form : My Form

;;Title of the Report
Title: $$LocaleString:"Daybook"

;;This variable is used in the current Report
Variables: ExplodeFlag

;;PRINTSET affects the variables related to Printing, whereas
;;SET is used to assign values to variables used otherwise.
PrintSet: ReportTitle: $$LocaleString:"Daybook"
PrintSet: PrintFileName: "Daybook"

[Form: My Form]

Buttons: PrintButton
;;PrintButton is a pre-defined button. We just add is here.

Space Top   : if $$InPrintMode then ##SVSpaceTop else 0.05 inches
Space Bottom: if $$InPrintMode then 0.5 else 0.05 inches
Space Left  : if $$InPrintMode then 0.5 else 0.05 inches
Space Right : if $$InPrintMode then 0.25 else 0.05 inches

Part: My DB Title,My DB Body

Button: ExplodeFlag
;;EXPLODEFLAG is a pre-defined button in Default Tally.
;;Try using KEY instead of BUTTON, Alt+F1 still works,
;;but the "Alt+F1" button is not displayed

[Part: My DB Title]

;;Optional Parts
Option: My DB PrntTitle  : $$InPrintMode
Option: My DB ScrTitle   : NOT $$InPrintMode

[!Part: My DB PrntTitle]

Use: DSP AccTitles
;;This is a pre-defined part in default TDL

[!Part: My DB ScrTitle]
Line: My DB Title

[Line: My DB Title]
Field : Name Field
Local : Field : Name Field : Set as : $$LocaleString:"Daybook"

[Part: My DB Body]
Line: My Line

Repeat : My Line: My Collection
;;Syntax:-
;;Repeat : <line> : <Collection>

Scroll: Vertical

;;Shows border
Common Border: Yes

[Line: My Line]
Left Fields: Myfld1,MyFld2
Right Fields: MyFld3,MyFld4

;;This Shows the Ledger details when Alt+F1 key is pressed
Explode: MyExplodePart : ##ExplodeFlag

[Field: Myfld1]
;;TYPE attribute specifies the data-type of the field
Type   : Date
Set as : $Date

[Field: Myfld2]
Use    : Name Field
Set as : $$CollectionField:$LedgerName:1:AllLedgerEntries

[Field: Myfld3]
Use    : Short Name Field
Set as : $VoucherTypeName

[Field: Myfld4]
Use    : Amount Field
Set as : $Amount

;;Important:-
;;This PART is displayed when EXPLODEFLAG variable is set to Yes
;;i.e. When user presses Alt+F1 key
[Part: MyExplodePart]
Line   : MyExplodline

;;Repeats the line MyExplodeLine to display the AllLedgerEntries
;;Collection fields
Repeat : MyExplodline : AllLedgerEntries

;; Specify the fields that you wish to display when the PART is Exploded
[Line: MyExplodline]

;;Show this field on the left side of the line
Add: Left Fields: fldExplodeLedger,fldExplodeAmount

;;This skips the first object of Collection AllLedgerEntries
Empty: $$IsFirstObj

;;Ledger Name field
[Field: fldExplodeLedger]
Indent : 10
Use    : Name Field
Set as : IF NOT $$IsFirstObj then $LedgerName else ""
Style  : Small Italic
Width  : @@NameWidth

;;Amount field
[Field: fldExplodeAmount]
Use    : Amount Field
Set as : $Amount
Style  : Small Italic
Width  : @@ShortWidth

;;Collection definition
[Collection: My Collection]
Type: Voucher


Notes:-
1) This program is an extension of program TDL41.TXT
2) ACCESS-CONTROL functionality is added to the menu-option MYDBKTDL using the $$Allow function.

Example 41: Adding Print functionality to MyDaybook

2007-08-14T16:10:00.000+05:30

This post illustrates how to add Print functionality to the report MyDaybook. This program (i.e TDL41) is an extension to our earlier program TDL38.

Download TDL41

;; PRODUCT: TDL41.TXT
;; AUTHOR: Shweta Computers

;;Objective:-
;;Adding Print functionality to MyDaybook
;;======================================================================

;;Global Formula. Assign a text string to MYTDL41
[System: Formula]
  MYTDL41: $$LocaleString:"Daybook"

;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]

  ;;ACTION used here is DISPLAY
  Item: @@MYTDL41 : Display: My Report

[Report: My Report]

  Form : My Form
  Title: $$LocaleString:"Daybook"
  Variables: ExplodeFlag

  ;;This is used to set the variables which will affect Printing only.
  PrintSet: ReportTitle: $$LocaleString:"Daybook"
  PrintSet: PrintFileName: "Daybook"

[Form: My Form]

  ;;PrintButton is a pre-defined button. We are just adding it here.
  ;;This will display a PRINT button on the right-hand side of Tally screen.
  Buttons: PrintButton

  Space Top   : if $$InPrintMode then ##SVSpaceTop else 0.05 inches
  Space Bottom: if $$InPrintMode then 0.5 else 0.05 inches
  Space Left  : if $$InPrintMode then 0.5 else 0.05 inches
  Space Right : if $$InPrintMode then 0.25 else 0.05 inches

  Part: My DB Title,My DB Body

  ;;Pre-defined button in Default Tally. Try using KEY instead of BUTTON,
  ;;Alt+F1 still works, but the "Alt+F1" button is not displayed
  Button: ExplodeFlag

[Part: My DB Title]
  Option: My DB PrntTitle  : $$InPrintMode
  Option: My DB ScrTitle   : NOT $$InPrintMode

[!Part: My DB PrntTitle]
  Use: DSP AccTitles

[!Part: My DB ScrTitle]
  Line: My DB Title

[Line: My DB Title]
  Field : Name Field
  Local : Field : Name Field : Set as : $$LocaleString:"Daybook"

[Part: My DB Body]
  Line: My Line

  Repeat : My Line: My Collection
  ;;Syntax:-
  ;;Repeat :  : 

  Scroll: Vertical

  ;;Shows border
  Common Border: Yes

[Line: My Line]
  Left Fields: Myfld1,MyFld2
  Right Fields: MyFld3,MyFld4

  ;;This Shows the Ledger details when Alt+F1 key is pressed
  Explode: MyExplodePart : ##ExplodeFlag 

[Field: Myfld1]
  ;;TYPE attribute specifies the data-type of the field
  Type   : Date
  Set as : $Date

[Field: Myfld2]
  Use    : Name Field
  Set as : $$CollectionField:$LedgerName:1:AllLedgerEntries

[Field: Myfld3]
  Use    : Short Name Field
  Set as : $VoucherTypeName

[Field: Myfld4]
  Use    : Amount Field
  Set as : $Amount

;;Important:-
;;This PART is displayed when EXPLODEFLAG variable is set to Yes
;;i.e. When user presses Alt+F1 key
[Part: MyExplodePart]
  Line   : MyExplodline

  ;;Repeats the line MyExplodeLine to display the AllLedgerEntries
  ;;Collection fields
  Repeat : MyExplodline : AllLedgerEntries

;; Specify the fields that you wish to display when the PART is Exploded
[Line: MyExplodline]

  ;;Show this field on the left side of the line
  Add: Left Fields: fldExplodeLedger,fldExplodeAmount

  ;;This skips the first object of Collection AllLedgerEntries
  Empty: $$IsFirstObj

;;Ledger Name field
[Field: fldExplodeLedger]
  Indent : 10
  Use    : Name Field
  Set as : IF NOT $$IsFirstObj then $LedgerName else ""
  Style  : Small Italic
  Width  : @@NameWidth

;;Amount field
[Field: fldExplodeAmount]
  Use    : Amount Field
  Set as : $Amount
  Style  : Small Italic
  Width  : @@ShortWidth

;;Collection definition
[Collection: My Collection]
  Type: Voucher


Notes:
1) This program is a extension to program TDL38.TXT

2) This program adds a button called PrintButton which is a
   pre-defined button. This will add the Printing functionality
   in our Report.

3) We have defined OPTIONAL parts "My DB PrntTitle" and "My DB ScrTitle"
   as we want to have different titles for Printing and Screen.

4) We have added SPACE(s) to our Form for formatting purpose.
   Example:-
   Space Bottom: if $$InPrintMode then 0.5 else 0.05 inches

5) $$InPrintMode is a Internal function that returns logical true
   if the report is being printed.

Example 39: Accessing fields of Company Object

2007-08-14T15:21:00.000+05:30

This post illustrates how to access fields (i.e. Internal methods) of "Company" object.

Download TDL39


;; PRODUCT: TDL39.TXT
;; PRODUCT-ID: de535cfa-1r7f-3h7a-31h3-a5r55a984e6e
;; AUTHOR: Shweta Computers

;;Objective:-
;;Accessing fields of Company Object
;;======================================================================

;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]

  ;;The ACTION used here is DISPLAY
  Item: Example 39: Display: My Report

[Report: My Report]
  Form : My Form

[Form: My Form]
  Part: My Part

[Part: My Part]
  Line: My Line1,My Line2

  ;;Shows border
  Common Border: Yes

[Line: My Line1]
  Left Fields: Short Prompt,Myfld1
  Local: Field: Short Prompt : Set as : "Company Number" 

[Line: My Line2]
  Left Fields: Short Prompt,Myfld2
  Local: Field: Short Prompt : Set as : "Owner Name" 

[Field: Myfld1]
  Use    : Short Name Field
  Set as : $CompanyNumber:Company:##SVCurrentCompany

[Field: Myfld2]
  Use    : Short Name Field
  Set as : $OwnerName:Company:##SVCurrentCompany


NOTES:

1) Accessing fields of Company Object
   Syntax:-
    : Company : 

   Example:-
   $BooksFrom : Company : ##SVCurrentCompany

   Explanation:
   a) $BooksFrom is a field of Object Company. It is also called Internal Method
   b) The 2nd parameter is the Company Object
   c) The 3rd parameter is the Company Name (##SVCurrentCompany) whose field
      value is to be retrieved.

  2) Short Prompt is a pre-defined field. Herein, we are using LOCAL attribute
     to modify the definition of the field Short Prompt which is effective only
     in this Report.

Example 38: Using EXPLODE attribute to display Daybook in detailed format

2007-08-13T06:49:00.000+05:30

This post illustrates how to use "EXPLODE" attribute at LINE-definition level.

TDL38 is an extension of program TDL30 in which we created a simple Daybook-style report. TDL38 adds new functionality to display the Daybook-report in Detailed format

Download TDL38

;;Objective:-
;;Using the EXPLODE attribute to display Ledgers details in
;;MY DAYBOOK format
;;======================================================================

;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]

 ;;The ACTION used here is DISPLAY
 Item: Example 38: Display: My Report

[Report: My Report]
 Form : My Form

[Form: My Form]
 Part: My Part

 ;;Pre-defined button in Default Tally. Try using KEY instead of BUTTON,
 ;;Alt+F1 still works, but the "Alt+F1" button is not displayed
 Button: ExplodeFlag

[Part: My Part]
 Line: My Line

 Repeat : My Line: My Collection
 ;;Syntax:-
 ;;Repeat : <line> : <collection>

 Scroll: Vertical

 ;;Shows border
 Common Border: Yes

[Line: My Line]
 Left Fields: Myfld1,MyFld2,MyFld3,MyFld4

 ;;This Shows the Ledger details when Alt+F1 key is pressed
 Explode: MyExplodePart : (##ExplodeFlag or $$KeyExplode)

[Field: Myfld1]
 ;;TYPE attribute specifies the data-type of the field
 Type   : Date
 Set as : $Date

[Field: Myfld2]
 ;;The USE keyword inherits the functionality/properties of the specified object
 Use    : Short Name Field
 Set as : $VoucherTypeName

[Field: Myfld3]
 Use    : Name Field
 Set as : $$CollectionField:$LedgerName:1:AllLedgerEntries

[Field: Myfld4]
 Use    : Amount Field
 Set as : $Amount

;;Important:-
;;This PART is displayed when EXPLODEFLAG variable is set to Yes
;;i.e. When user presses Alt+F1 key
[Part: MyExplodePart]
 Line   : MyExplodline

 ;;Repeats the line MyExplodeLine to display the AllLedgerEntries
 ;;Collection fields
 Repeat : MyExplodline : AllLedgerEntries

;; Specify the fields that you wish to display when the PART is Exploded
[Line: MyExplodline]

 ;;Show this field on the left side of the line
 Add: Right Fields: fldExplodeLedger,fldExplodeAmount

 ;;This skips the first object of Collection AllLedgerEntries
 Empty: $$IsFirstObj

;;Ledger Name field
[Field: fldExplodeLedger]
 Use    : Name Field
 Set as : IF NOT $$IsFirstObj then $LedgerName else ""
 Style  : Small Italic
 Width  : @@NameWidth

;;Amount field
[Field: fldExplodeAmount]
 Use    : Amount Field
 Set as : $Amount
 Style  : Small Italic
 Width  : @@ShortWidth

;;Collection definition
[Collection: My Collection]
 Type: Voucher

Notes:-
1) EXPLODE attribute is used at LINE definition level to display (i.e explode)
   additional details.

2) When the user presses Alt+F1 key, the ledger details are shown.

3) The attribute EMPTY is used at LINE definition level as shown below:-

   Empty: $$IsFirstObj

   Syntax:-  Empty : <condition>
   The EMPTY attribute is used at the LINE definition level to skip the line,
   if the condition is true. Herein, we have specified that 1st Object of the
   Collection "AllLedgerEntries" must be skipped.

4) $$IsFirstObj
   Return value: Logical
   Checks whether the object is the 1st object or not in the given collection
     
5) CollectionField is a Tally Internal Function. It returns the Method/Field
   data of the specified Collection as applied on the "nth" object of the
   Collection. In the above code, it fetches the 1st LedgerName from the
   Collection "AllLedgerEntries".

   Syntax:  $$CollectionField: <method field=""> : <positionnumber> : <collection>
   Return Value: Method/Field value as specified as the 1st argument

6) AllLedgerEntries is a pre-defined Collection that contains Ledger details
   for the VOUCHER object. $LedgerName is a method/Field of this collection.

7) Date,VoucherTypeName,VoucherNumber,Amount are methods/fields of
   VOUCHER object.

8) NameWidth, ShortWidth, Small Italic are pre-defined Global formulaes.

Example 37: Using "Control" attribute at Menu definition level

2007-08-11T11:43:00.000+05:30

This post illustrates how to use "Control" attribute at menu-definition level.

Download TDL37


;;Objective:-
;;Using "Control" attribute at Menu level
;;=========================================================================

;;Global formula definition
[System: Formula]
locSR : $$LocaleString:"Sales Register"
locPR : $$LocaleString:"Purchase Register"

;;Add a new menu-item to the Gateway of Tally
[#Menu:Gateway of Tally]
Item : Example 37: Menu : My Menu

[Menu: My Menu]

;;1st Menu option
Item: @@locSR : Display : Sales Register

;;2nd Menu option.
Item: @@locPR : Display : Purchase Register

Item: Blank
Key Item: @@locQuit

Control  : @@locSR : ##ShowSR
Control  : @@locPR : ##ShowPR

[System: Variable]
ShowSR : Yes

;;This will hide the 2nd menu-option
ShowPR : No

[Variable: ShowSR]
Type : Logical

[Variable: ShowPR]
Type : Logical


Notes:-
1) We are using ITEM to define menu-items rather than using KEY ITEM
 This is because KEY ITEM is supported in only Tally 9, whereas
 ITEM is supported in both Tally 7.2 and Tally 9

Example 36: Disabling menu-options in Tally 7.2

2007-08-10T12:41:00.001+05:30

This post illustrates how to disable a menu-option in Tally 7.2.

Download TDL36


;;Objective:-
;;Disabling Menu options in Tally 7.2
;;=========================================================================

;;Global formula definition
[System: Formula]
  locSR : $$LocaleString:"Sales Register"
  locPR : $$LocaleString:"Purchase Register"

;;Add a new menu-item to the Gateway of Tally
[#Menu:Gateway of Tally]
  Item : Example 35: Menu : My Menu

[Menu: My Menu]
  ;;1st Menu option
  Item: @@locSR : Display : Sales Register : ##ShowSR

  ;;2nd Menu option
  ;;This option is disable as variable ShowPR is set to NO
  Item: @@locPR : Display : Purchase Register : ##ShowPR

  Item: Blank
  Key Item: @@locQuit 

[System: Variable]
  ShowSR : Yes
  ShowPR : No

[Variable: ShowSR]
  Type : Logical

[Variable: ShowPR]
  Type : Logical

Example 35: Disabling menu-options in Tally 9

2007-08-10T12:37:00.000+05:30

This post illustrates how to disable a menu-option in Tally 9.

Download TDL35


;;Objective:-
;;Disabling Menu Options in Tally 9
;;=========================================================================

;;Global Formula
[System: Formula]
  locSR : $$LocaleString:"Sales Register"
  locPR : $$LocaleString:"Purchase Register"

;;Add a new menu-item to the Gateway of Tally
[#Menu:Gateway of Tally]
  Item : Example 35: Menu : My Menu

[Menu: My Menu]
  ;;KEY ITEM works with Tally 9 only.
  ;;Refer TDL36.TXT for Tally 7.2 
  Key Item: @@locSR : S : Display : Sales Register : ##ShowSR
  Key Item: @@locPR : P : Display : Purchase Register : ##ShowPR
  Item: Blank
  Key Item: @@locQuit : Q

[System: Variable]
  ShowSR : Yes
  ShowPR : No

[Variable: ShowSR]
  Type : Logical

[Variable: ShowPR]
  Type : Logical

Example 34: Using Validate Attribute at FIELD definition level

2007-08-09T09:07:00.000+05:30

This post illustrates how to use "Validate" Attribute at FIELD definition level.

Download TDL34


;;Objective:-
;;Using "Validate" attribute at FIELD definition level
;;=========================================================================

;; Add a new menu-item to the Gateway of Tally. Note that the Action is
;; ALTER (and not display)

[#Menu:Gateway of Tally]
 Item : Example 34 : Alter : My Report

[Report: My Report]
 Form: My Form

[Form: My Form]
 Part: My Part

[Part: My Part]
 Line: My Line

[Line: My Line]
 Fields: My Field1

[Field: MyField1]
 Use: Name Field

 ;;Validates that the Field Value must not be Empty.
 ;;Similar to the "Control" attribute but does not display any message
 Validate : NOT $$IsEmpty:$$Value

Notes:-
1) $IsEmpty checks whether the parameter passed is Empty or not.
Syntax: $$IsEmpty:
2) $$Value
Returns the value of the current field

Example 33: Using "Control" Attribute at FIELD definition level

2007-08-09T08:42:00.000+05:30

This post illustrates how to use "Control" Attribute at FIELD definition level.

Download TDL33

;; PRODUCT: TDL33.TXT
;;=========================================================================
;; Add a new menu-item to the Gateway of Tally. Note that the Action is
;; ALTER (and not display as used generally)


[#Menu:Gateway of Tally]
    Item : Example 33 : Alter : My Report


[Report: My Report]
    Form: My Form


[Form: My Form]
    Part: My Part


[Part: My Part]
    Line: My Line


[Line: My Line]
    Fields: My Field1


[Field: MyField1]
    Use: Name Field


    ;;Display a message if the Field Value is Empty
    Control  : EmptyValueMsg : $$IsEmpty:$$Value


;;Global formula
[System: Formula]
    EmptyValueMsg : $$LocaleString:"Cannot be empty.\nPlease enter some value."

Notes:-
1) $$IsEmpty checks whether the parameter passed is Empty or not.
Syntax: $$IsEmpty:
2) $$Value
Returns the value of the current field
3) \n is used for line-feed

Exporting a user-defined Report

2007-07-04T18:03:00.001+05:30

This post illustrates how to create a Report and Export it.

TDL32 displays a menu-option "Export Report" in the "Gateway of Tally ". On selecting this option it displays Vouchers details like Date, Ledger; VoucherType etc. You can now EXPORT this Report by pressing ALT+E key.

Download TDL32

;; PRODUCT: TDL32.TXT
;; PRODUCT-ID: dr334cfa-2r7f-3f7a-51h3-a3r54a994e6w
;; AUTHOR: Shweta Computers
;;=========================================================================

;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]
  Item: Report Export: Display: My Report

[Report: My Report]
  Form : My Form

  ;;Export the Report
  Export : Yes

[Form: My Form]

  ;;Displays the Export button. Use Alt+E to Export the Report.
  Button: ExportButton

  Part: My Part
  Full Width: Yes
  Full Height: Yes
  XMLTag: ENVELOPE

[Part: My Part]
  Line: My Line
  Repeat : My Line: My Collection
  Scroll: Vertical
  Common Border: Yes
  XMLTag: MyVoucher

[Line: My Line]
  Left Fields: Myfld1,MyFld2,MyFld3,MyFld4

[Field: Myfld1]
  ;;TYPE attribute specifies the data-type of the field
  Type: Date
  Set as : $Date
  XMLTag: Date

[Field: Myfld2]
  ;;The USE keyword inherits the functionality/properties of the specified object
  Use    : Short Name Field
  Set as : $VoucherTypeName
  XMLTag: VoucherType

[Field: Myfld3]
  Use    : Name Field
  Set as : $$CollectionField:$LedgerName:1:AllLedgerEntries
  XMLTag : LedgerName

[Field: Myfld4]
  Use    : Amount Field
  Set as : $Amount
  XMLTag : Amount

;;Collection definition
[Collection: My Collection]
  Type: Voucher

Notes:-
1) Export attribute at the Report level makes the Report exportable.
2) XMLTag attribute is used to specify the XML-Tag-name for the Report fields.
3) ExportButton is a predefined button definition.
4) You can fetch the above Report data manually (using Alt+E) or programmatically using RTSlink DLL, like you fetch data of other pre-defined reports.

Passing parameters to TDL procedures

2007-07-04T17:33:00.000+05:30

This post illustrates how to pass parameters to TDL procedures. TDL31 program retreives Payment Vouchers

Download TDL31

;; PRODUCT: TDL31.TXT
;; PRODUCT-ID: cr405yfa-3e7f-5d9a-52h6-acr80a55436e
;; AUTHOR: Shweta Computers
;;=========================================================================

;; Collection-name that begins with an underscore is a Procedure
[Collection: _MyVouchers]

  ;;Based on the Voucher Object
  Type         : Voucher

  ;;Requires ONe parameter i.e. VoucherType Name
  SQLParms     : pVchType

  ;;Data that is returned to the calling program
  SQLValues    : Voucher Date      : $Date
  SQLValues    : Voucher Number    : $VoucherNumber
  SQLValues    : Voucher Reference : $VoucherReference
  SQLValues    : Voucher Amount    : $Amount
  SQLValues    : Voucher Type      : $VoucherTypeName

  ;;Filters out the Collection for Object that match the given condition
  Filters       : MyVchTypeFilter


[System: Formula]
  ;;Used as Filter condition
  MyVchTypeFilter : $VoucherTypeName = #pVchType

[Variable: pVchType]
  Type: String

[System: Variable]
  pVchType: ""

Notes:-
Procedures can be invoked using SQLRequest() function of RTSlink DLL
as given below:

Syntax:-
SQLRequest("Call _MyVouchers('Payment')")

Creating Procedures in TDL

2007-07-01T18:33:00.000+05:30

This post illustrates how to create Procedures in TDL.

TDL Procedures are different from the procedures/functions used in other programming languages. A TDL proceedure is basically a collection of SQL-Columns that is returned to the calling program.

To create a Procedure, you define a Collection that starts with an underscore. Next, SQLValues attribute defines the columns that you require to be returned to the calling program.

Download TDL29

;; PRODUCT: TDL29.TXT
;; PRODUCT-ID: dr205cfa-1e7f-3f9a-32h8-acr50a55436e
;; AUTHOR: Shweta Computers
;;=========================================================================

;; Procedures must begin with _ (underscore) in TDL
;; Procedures return data to the calling program
[Collection: _MyVouchers]
 ;;This collection is based on the pre-defined type Voucher
 Type         : Voucher

 SQLValues    : Voucher Date           : $Date
 SQLValues    : Voucher Type           : $VoucherTypeName
 SQLValues    : Voucher Number      : $VoucherNumber
 SQLValues    : Voucher Reference  : $VoucherReference
 SQLValues    : Voucher Amount       : $Amount

Notes:-
1) SQLValues is an attribute that can be used with Collection
definition
2) SQLValues requires TWO parameters
1st Parameter : Column Name
2nd Parameter : Column Value (usually this is a Method/Field Name)

3) Procedures can be invoked using SQLRequest() function of RTSlink DLL
as given below:

Syntax:-
SQLRequest("Call _MyVouchers")

4) For more information on how to use the SQLRequest() function, refer link www.rtslink.com

Using $$FullList function

2007-07-01T07:44:00.000+05:30

$$FullList is a Tally Internal Function. It fetches and returns the specified Method/Field values from the given Collection.
Syntax : $$FullList : <CollectionName> : <Method/FieldName>
Return Value : Method/Field type

The $$FullList function is basically used to fetch all the values for a specified Method/Field from a given Collection. For more information and sample program, refer article "Fetch Tally Voucher Data including Stock-Item details"

Using $$CollectionField Function

2007-07-01T07:18:00.001+05:30

This post illustrates how to use the $$CollectionField Tally Internal Function.

Download program TDL30

;; PRODUCT: TDL30.TXT
;; PRODUCT-ID: br535cfa-1r7f-3h7a-31h3-a5r55a994e6w
;; AUTHOR: Shweta Computers
;;=========================================================================

;;Add a new menu-item to the Gateway of Tally
[#Menu: Gateway of Tally]
Item: CollectionField Example: Display: My Report

[Report: My Report]
Form : My Form

[Form: My Form]
Part: My Part
Full Width: Yes
Full Height: Yes

[Part: My Part]
Line: My Line
Repeat : My Line: My Collection
Scroll: Vertical
Common Border: Yes

[Line: My Line]
Left Fields: Myfld1,MyFld2,MyFld3,MyFld4

[Field: Myfld1]
;;TYPE attribute specifies the data-type of the field
Type: Date
Set as : $Date

[Field: Myfld2]
;;The USE keyword inherits the functionality/properties of the specified object
Use    : Short Name Field
Set as : $VoucherTypeName

[Field: Myfld3]
Use    : Name Field
Set as : $$CollectionField:$LedgerName:1:AllLedgerEntries

[Field: Myfld4]
Use    : Amount Field
Set as : $Amount

;;Collection definition
[Collection: My Collection]
Type: Voucher

;; Notes:-
1) $$CollectionField is a Tally Internal Function. It returns the Method/Field
data of the specified Collection as applied on the "nth" object of the
Collection. In the above code, it fetches the 1st LedgerName from the
Collection "AllLedgerEntries".

Syntax: $$CollectionField: <Method/Field> : <PositionNumber> : <Collection>
Return Value: Method/Field value as specified as the 1st argument

2) AllLedgerEntries is a pre-defined Collection that contains Ledger details
for the VOUCHER object. $LedgerName is a method/Field of this collection.

3) Date,VoucherTypeName,VoucherNumber,Amount are methods/fields of
VOUCHER object.

Report Inheritance : How to Create new Reports based on existing Reports?

2007-06-30T16:08:00.000+05:30

Program TDL28 illustrates the concept of Report Inheritance. i.e. creating a new Report based on a existing Report. Download TDL28

;; PRODUCT: TDL28.TXT
;; PRODUCT-ID: cd205cfa-1d7f-4f9a-92h8-ace40a5943be
;; AUTHOR: Shweta Computers
;;=========================================================================

;;Modify the Gateway of Tally menu to add a new Menu item
[#Menu: Gateway of Tally]
  Add: Item: My Daybook: Display: My Daybook

;;Report Definition
[Report: My Daybook]

  ;;This inherits the functionality of existing (pre-defined) Report
  Use : Voucher Register

  ;;Change the default Period
  Set : SVFROMDATE: $$DateFrom
  Set : SVTODATE  : $$DateTo

;; Notes:-
;; 1) $$DateFrom function returns the date from which the period begins
;; 2) $$DateTo function returns the date with which the period ends
;; 3) SVFROMDATE is a pre-defined Global variable
;; 4) SVToDATE is a pre-defined Global variable

Voucher Statistics using $$IsPayment, $$IsReceipt etc

2007-06-23T06:54:00.000+05:30

You can fetch Voucher statistics using $$IsPayment, $$IsReceipt and others similar functions. For more information on these TDL functions, refer www.rtslink.com

Syntax:-
$$IsPayment: <VoucherTypeName>

Return Value:
Logical

Download TDL27 program.

This TDL program creates a Collection/table which contains Voucher statistics data. To view the Collection data, you can use SQLRequest() function of RTSlink DLL. Refer, rtslink.blogspot.com for more information.

;; PRODUCT: TDL27
;; PRODUCT-ID: ad157cfa-2s7f-4g9a-52f8-ade40a2983be
;; AUTHOR: Shweta Computers
;;==========================================================================
;;This program defines a Collection called VCHStatistics.
;;This collection can be accessed using SQLRequest() function of RTSlink DLL
;;==========================================================================

;;****** Collection definition ******
;;VCHStatistics is a collection that contains a single Object (record) called MyObjects.
;;IsODBCTable is set as YES so that this collection is accessible to external programs

[Collection: VCHStatistics]
  Object: MyObjects
  IsODBCTable: Yes

;;******* Object Definition *********
;;Herein we are defining an Object called "MyObjects" which comprises of THREE fields
;;1st: PaymentVouchers - Number of Payment Vouchers
;;2nd: ReceiptVouchers - Number of Receipt Vouchers
;;3rd: AllVouchers - Total Number of Vouchers

;;The FilterCount function requires a Formula (i.e. condition) as the 3rd parameter.
[Object: MyObjects]
  PaymentVouchers  : $$FilterCount:RTSAllVouchers:HasPaymentVouchers
  ReceiptVouchers  : $$FilterCount:RTSAllVouchers:HasReceiptVouchers
  AllVouchers      : $$FilterCount:RTSAllVouchers:AlwaysTrue

;;******* Global Formula definition ********
;;$VoucherTypeName refers to the Field NAME of Voucher Collection

[System: Formula]
  HasPaymentVouchers  : $$IsPayment:$VoucherTypeName
  HasReceiptVouchers  : $$IsReceipt:$VoucherTypeName
  AlwaysTrue          : $$IsWindows


;;******* Collection Definition ********
;;This makes the pre-defined Voucher Collection accessible to external programs
;;and also to the user-defined collection VCHStatistics
;;
[Collection: RTSAllVouchers]
  Type: Voucher
  IsODBCTable: Yes

;;Notes
;;=====
;; $$IsPayment is a Tally Interenal Function that is used to check whether a Voucher is 
;; Payment Voucher or not
;; Syntax      :-  $$IsPayment: 
;; Return Value:-  Logical
;;
;; $$IsReceipt is a Tally Interenal Function that is used to check whether the Voucher is 
;; Receipt Voucher or not
;; Syntax      :-  $$IsReceipt: 
;; Return Value:-  Logical
;;
;; $$IsWindows is a Tally Internal Function which checks whether the OS is Windows or not.
;; Syntax      :-  $$IsWindows
;; Return Value:-  Logical

Example 26: Using $$FilterCount function

2007-06-22T10:39:00.000+05:30

FilterCount is a Tally (Internal) function that allows you to count records of a Collection/table based on a filter condition.

Syntax:-
$$FilterCount: <CollectionName> : <Condition>

Return Value:
Numeric

Download TDL26 program.

This TDL program creates a Collection/table which contains some statistics data. However, this data is not displayed directly in Tally. To view the Collection data, you can use SQLRequest() function of RTSlink DLL. Refer, rtslink.blogspot.com for more information.

;; PRODUCT: TDL26
;; PRODUCT-ID: cd387cfa-1d7f-4g9a-52f8-ace40a2983be
;; AUTHOR: Shweta Computers
;;==========================================================================
;;This program defines a Collection called MyStatistics.
;;This collection can be accessed using SQLRequest() function of RTSlink DLL
;;==========================================================================

;;****** Collection definition ******
;;MyStatistics is a collection that contains a single Object (record) called MyObjects.
;;IsODBCTable is set as YES so that this collection is accessible to external programs

[Collection: MyStatistics]
  Object: MyObjects
  IsODBCTable: Yes

;;******* Object Definition *********
;;Herein we are defining an Object called "MyObjects" which comprises of THREE fields
;;1st: DebtorsLedgers - Number of Ledgers falling under group Sundry Debtors
;;2nd: CreditorsLedgers - Number of Ledgers falling under group Sundry Creditors
;;3rd: AllLedgers - Total Number of Ledgers 

;;The FilterCount function requires a Formula (i.e. condition) as the 3rd parameter.
;;which is defined below
[Object: MyObjects]
  DebtorsLedgers  : $$FilterCount:Ledger:HasSundryDebtors
  CreditorsLedgers: $$FilterCount:Ledger:HasSundryCreditors
  AllLedgers      : $$FilterCount:Ledger:AlwaysTrue

;;******* Global Formula definition ********
;;$Name refers to the Field NAME of Ledger Collection

[System: Formula]
  HasSundryDebtors  : $$IsLedOfGrp:$Name:$$GroupSundryDebtors
  HasSundryCreditors: $$IsLedOfGrp:$Name:$$GroupSundryCreditors
  AlwaysTrue        : $$IsWindows

;;Notes
;;=====
;; $$IsLedOfGroup is a Tally Interenal Function that is used to check whether a Ledger falls under a 
;; specific Group or not.
;; Syntax      :-  $$IsLedOfGroup: <LedgerName>: <GroupName>
;; Return Value:-  Logical
;;
;; $$IsWindows is a Tally Internal Function which checks whether the OS is Windows or not.
;; Syntax      :-  $$IsWindows
;; Return Value:-  Logical
;;
;; $$GroupSundryDebtors is a Tally Internal Function 
;; Syntax      :-  $$GroupSundryDebtors
;; Return Value:-  String: The Group-Name for pre-defined Tally Group "Sundry Debtors"
;;
;; $$GroupSundryCreditors is a Tally Internal Function 
;; Syntax      :-  $$GroupSundryCreditors
;; Return Value:-  String: The Group-Name for pre-defined Tally Group "Sundry Creditors"

Example 25: Adding Voucher-Creation-Date/Time

2007-06-18T17:47:00.000+05:30

This program TDL25 adds FOUR (invisible) fields to the Voucher entry screen. The fields are as follows:-
a) Voucher-Creation-Date
b) Voucher-Creation-Time
c) Voucher-Alteration-Date
d) Voucher-Alteration-Time

The basic idea of adding these fields is to keep track of "Vouchers that have been added or modified during a specific period ?"

Create a plain text file that contains the following Code. For those who have joined now, please note that you can use plain TXT files to customize Tally even without Tally Developer. For more information, refer post "How to Customize Tally Software using TXT files ?"

CODE

;; PRODUCT: 
;; PRODUCT-ID: cc307cfa-1d7f-4f9a-92f8-ace40a2943be
;; AUTHOR: Shweta Computers
;;=====================================================================

;;UDF's declaration. New fields declaration
;;=====================================================================
[System: UDF]
  fldVCHCreationDate  : Date  : 1025
  fldVCHCreationTime  : String: 1026
  fldVCHAlterationDate: Date  : 1027
  fldVCHAlterationTime: String: 1028

;;This will expose the newly added fields through Voucher Object so 
;;that it can be accessed elsewhere
;;=====================================================================
[#Object: Voucher]
  VCHCreationDate  : $fldVCHCreationDate
  VCHCreationTime  : $fldVCHCreationTime
  VCHAlterationDate: $fldVCHAlterationDate
  VCHAlterationTime: $fldVCHAlterationTime

;;The Voucher Object is modified to include optional definitions
;;a) In case of Voucher Creation, the prtVchNarrationInCreateMode replaces 
;;   the existing VoucherNarration Part definition
;;b) In case of Voucher Altertion, the prtVchNarrationInAlterMode replaces 
;;   the existing VoucherNarration Part definition
;;=====================================================================
[#Part: VCH Narration]
  Option: prtVCHNarrationInCreateMode : $$InCreateMode AND NOT $$InDuplicateMode
  Option: prtVCHNarrationInAlterMode  : $$InAlterMode  OR $$InDuplicateMode

;;Optional Part definition
[!Part: prtVCHNarrationInCreateMode]
;;  Local: Line : VCH NarrPrompt: Add: Fields: Short Prompt
;;  Local: Field: Short Prompt  : Set as: "Create mode: "
  Add: Line: LnVCHNarrationInCreateMode

;;Line definition 
[Line: lnVCHNarrationInCreateMode]
  Add  : Fields: VCHCreationDate
  Add  : Fields: VCHCreationTime  

;;Optional Part definition
[!Part: prtVCHNarrationInAlterMode]
;;  Local: Line : VCH NarrPrompt: Add: Fields: Short Prompt
;;  Local: Field: Short Prompt  : Set as: "Alter mode: "
  Add: Line: LnVCHNarrationInAlterMode

;;Line definition 
[Line: lnVCHNarrationInAlterMode]
  Add  : Fields: VCHAlterationDate
  Add  : Fields: VCHAlterationTime  

;;Field definition for Voucher Creation Date
;;=====================================================================
[Field: VCHCreationDate]
  Use: Short Date Field
  Storage: fldVCHCreationDate
  Set as: $$MachineDate
  Set Always: Yes 
  ;;Try changing Invisible to NO
  Invisible: Yes

;;Field definition for Voucher Creation Time
;;=====================================================================
[Field: VCHCreationTime]
  Use: Short Name Field
  Storage: fldVCHCreationTime
  Set as: $$MachineTime
  Set Always: Yes
  ;;Try changing Invisible to NO
  Invisible: Yes

;;Field definition for Voucher Alteration Date
;;=====================================================================
[Field: VCHAlterationDate]
  Use: Short Date Field
  Storage: fldVCHAlterationDate

  ;;This will forcefully store the $$MachineDate (i.e. CurrentDate in field)
  Type: Date: Forced

  Set as: $$MachineDate
  Set Always: Yes

  ;;Try changing Invisible to NO
  Invisible: Yes

;;Field definition for Voucher Alteration Time
;;=====================================================================
[Field: VCHAlterationTime]
  Use: Short Name Field
  Storage: fldVCHAlterationTime

  ;;This will forcefully store the $$MachineTime (i.e. CurrentTime in field)
  Type: String: Forced

  Set as: $$MachineTime
  Set Always: Yes

  ;;Try changing Invisible to NO
  Invisible: Yes

Download the TDL25 sample program.

TDL programs 16 to 20

2007-06-15T06:09:00.000+05:30

TDL programs 16 to 20 have been re-checked/verified for Tally 9/Tally 7.2.

You can now use/or modify these programs even without having Tally Developer software.

For more information on using TXT files to customize Tally or to download these programs, visit "How to use TXT files to customize Tally Accounting Software"

TDL programs 11 to 15

2007-06-09T11:05:00.000+05:30

TDL programs 11 to 15 have been re-checked/verified for Tally 9/Tally 7.2.

You can now use/or modify these programs even without having Tally Developer software.

For more information on using TXT files to customize Tally or to download these programs, visit "How to use TXT files to customize Tally Accounting Software"

TDL programs 6 to 10

2007-06-08T06:20:00.000+05:30

TDL programs 6 to 10 have been re-checked/verified for Tally 9/Tally 7.2.

You can now use/or modify these programs without having Tally Developer. For information or to download these programs, visit "How to use TXT files to customize Tally Accounting Software"

How to Customize Tally Accounting Software using TXT files ?

2007-06-07T06:53:00.000+05:30

Yes. You can customize Tally Accounting Software (Tally 7.2 / Tally 9) using TXT files. No need of Tally Developer for compiling files.

For more information visit How to customize Tally Accounting Software at www.rtslink.com

Tally 7.2 Release 1 - UDF's not working

2007-05-25T17:28:00.000+05:30

Many of the sample programs that use UDFs (User-defined fields) do not work in Tally 7.2 Release 1 as there are bugs in Tally 7.2 Release 1.

This has been confirmed by Tally Solutions, Bangalore the email text is reproduced herewith:-

"This is with reference to your below email, regarding code is not working in Tally 7.2 Release 1

Please suggest the customer to upgrade the Tally 7.2 Release 3.13, if the customer is using hard lock then please suggest the customer to use Tally 7.2 Release 1.42

Please note : Some bugs which was there in Tally 7.2 Release 1 that's has been rectified in Tally 7.2 Release 1.42 to 3.13"

Correction in TDL9v24 file (for Tally 9)

2007-04-09T06:55:00.000+05:30

Corrections have been made in the "Salesman Master" (i.e. tdl9v24.tcp for Tally 9) which are as follows:-

Tally 9 TDL code

[#Part: CMP AccFeat Left]
.... rest of the code

Tally 7.2 TDL code

[#Part: CMP Advanced Features]
.... rest of the code

Download the tdl9v24.tcp and tdl24.tcp file with source-code.

Creating Masters in Tally using TDL: Part 1

2007-03-20T08:42:00.000+05:30

View the article Creating Masters in Tally using TDL: Part 1

Example 23: 'Discount Amount' field instead of 'Discount Percentage' in Sales entry

2007-03-17T01:04:00.000+05:30

This program modifies the Sales Voucher entry screen to accept "Discount" in Amount instead of Percentage.

View the TDL source-code.
Download source-code (zip) file.

Tally programmers group

2007-03-15T10:16:00.000+05:30

Join the Tally programmers group and send in your questions/answers relating to Linking your software with Tally, Tally customization and Tally Definition Language (TDL).

Visit Yahoo Tally programmers Group

Recycle-bin for Tally

2007-03-11T12:09:00.000+05:30

Enables you to retrieve Voucher entries that you may have accidentally deleted in Tally. It is similar to the Windows recycle-bin and works with Tally 7.2 and Tally 9. The ZIP file contains a readme.txt file which contains steps for configuring Tally.ini in order to use RBIN.TCP file.

ZIP file contents
RBIN.TCP for Tally 7.2
RBIN9v.TCP for Tally 9
Readme.txt

Download Recycle-bin for Tally [Freeware]

Bugs fixed:
Recycle-bin now works using option "GatewayOfTally - Balance Sheet @Drill down to Voucher level and use Alt+D to delete any Voucher]

Example 22: Popup-list with pre-defined choices

2007-03-09T08:04:00.000+05:30

This program shows how you can create a Popup-List with pre-defined choices.

View the TDL source-code.
Download source-code (zip) file.

Example 21: Add Cheque Number Field

2007-03-07T03:28:00.000+05:30

This program adds a field 'ChequeNumber' in the Receipt & Payment Voucher entry screen.

Click here to download the Example 21 compiled file and the source-code.

Example 20: Single UDF Vs Repeat UDF

2007-03-05T09:35:00.000+05:30

Earlier in Example 19, we have seen how to add a UDF (Single UDF) in the Ledger Master. Now, we shall see how to add a REPEAT UDF.

A Single UDF allows you to enter ONE value, whereas a Repeat UDF allows you to enter several/multiple VALUES.

Syntax:-
<FieldName> : <FieldType> : <Index> : <RepeatYesNo>

Example:-
[System: UDF]
MyRepeatUDF: String: 1000: Yes

Click here to download the Example 20 compiled file and the source-code.

Example 19: Adding field in the Ledger Master

2007-03-03T07:33:00.000+05:30

This TDL program adds a field (named MyField) in the Ledger Master. This new field appears in the section "Mailing and Related details" when you create Ledger under "Sundry Debtors" or "Sundry Creditors" group.

In case, if you require any other field in Ledger Master, you can send in you Queries to tdlplayground@rtslink.com.

Click here to download the Example 19 compiled file and the source-code.

Example 18: Trial Balance - A Top-to-Bottom view

2007-02-28T07:22:00.000+05:30

This is a modified version of our earlier Trial Balance TDL program. It shows how you can use 'Collection' defintion and the 'ChildOf' attribute to display the Trial-balance with Top-to-bottom (drill-down) feature.

Click here to download the Example 18 compiled file and the source-code.

Example 17: Using Ledger Object to display Ledger help-list

2007-02-26T03:20:00.000+05:30

This program shows how you can display Ledger Name and Closing balances in HELP facility in a your TDL forms.

;; Modify the "Gateway of Tally" menu and Add a new option "Ledger Help"
[#Menu: GatewayOfTally]


    ;;Please note that the actions used here is CREATE and not DISPLAY as 
    ;;User-input has to be enabled
    Add: Item : Ledger Help : Create : rptLedger


;;Report definition
[Report: rptLedger]
    Form: frmLedger


;;Form definition
[Form: frmLedger]
    Part: prtMyPart1
    Width: 70% screen
    Height: 50% screen


;;Part definition
[Part: prtMyPart1]
    Line: lnMyLine1


;;Line definition
[Line: lnMyLine1]
    ;;Short Prompt is a field defined in default TDL. Hence, it is just added to this line
    ;;but is not defined in this TDL. 
    Fields: Short Prompt, fldLedgerName


    ;;Modifies the field 'Short Prompt' locally
    Local: Field: Short Prompt: Set As: "Ledger Name:"


;;Field definition
[Field: fldLedgerName]

    
    ;;Inherit from the default TDL field 'Name Field'
    Use: Name Field


    ;;Field type
    Type: String


    ;;This displays the Ledger help-list in a Table format
    Table: My Ledgers


    ;;Display the Help-list Table always
    ShowTable: Always


    ;;Variable to hold user-input
    Variable: varLedgerName


;;Define a Collection named 'My Ledgers' which is used in the 'fldLedgerName' field 
;;definition wherein the Table attribute displays the Collection data.
[Collection: My Ledgers]

    
    ;;Collection is based on Internal Object LEDGER which is defined in default TDL
    Type: Ledger


    ;;Specify the format/width of Columns required in Help-List
    Format: $Name, 30
    Format: $ClosingBalance,15


    ;;This will display Phone Number
    ;;Format: $LedgerPhone


;;Local Variable definiton
[Variable: varLedgerName]
    Type: String

Click here to download the Example 17 compiled file and the source-code.

Corrections

2007-02-26T03:12:00.000+05:30

1) TDL-0014 is now available for download.
2) Group Master (GROUP.ZIP) and Ledger Master (LEDGER.ZIP) files are now available for download from FTP site. Due to the large file-size (appx 2MB each), there was problem sending these files by email to certain email accounts. There shouldn't be any problems now as you can get it via FTP directly.

Example 16: Fetch Address of Sundry Debtors/Creditors

2007-02-24T09:07:00.000+05:30

This program displays the addresses of Ledgers created under "Sundry Debtors" and "Sundry Creditors" Group. It shows how you can retreive values of Internal Object/Table Ledger.

Click here to download the Example 16 compiled file and the source-code.

Example 15: Add Salesman field in "Sales Voucher" entry screen

2007-02-23T07:36:00.000+05:30

Objective:-
Add a Salesman field in the default Voucher Entry screen. This field should appear
only when the Voucher type is Sales

    
;;User-defined field definition
[System: UDF]
    ;;Syntax: <Field>: <FieldType>: <Index>
    ;;<Index> can be any value between 1000 to 9000. It relates to the Index order
    ;;while arranging fields in a Report. This is not relevant at present, so we
    ;; shall use any value between 1000 to 9000.
    Salesman: String: 1001


;;This Modifies the default Voucher Entry screen. You need to mention which part of 
;;the Voucher entry screen is to be modified. "EI BaseInfo" is a Part defined 
;;in the default Tally TDL
;;===================================================================================

[#Part: EI BaseInfo]


    ;; IF the VoucherType is Sales, then the Optional Part EI SALESMAN is activated
    ;; $$IsSales is an Internal Function defined in the default TDL
    ;; ##SVVoucherType is a Global Variable defined in the default TDL
    ;;=============================================================================
    Option: EI Salesman: $$IsSales:##SVVoucherType


;;This is how we define the Optional Part. 
[!Part: EI Salesman]
    Add: Line: lnSalesman


[Line: lnSalesman]
    Add: Field: lblSalesman
    Add: Field: fldSalesman


;;This is the label (text)
[Field: lblSalesman]
    Info: "Salesman: "
    Width: 15


;;This is where the User will input the "Salesman"
[Field: fldSalesman]
    Use: Short Name Field
    Storage: Salesman
    Width: 20

Click here to download the Example 15 compiled file and the source-code.

Example 14: Colorful Trial Balance

2007-02-22T08:50:00.000+05:30

Example 14 Illustrates how you can use the "Option" keyword to display different colors in our sample Trial Balance.

This example is an extension to Example 12a. It display Ledgers in RED color if the Ledger balance is greater than 1000.

Click here to download the Example 14 compiled file and the source-code.

Example 12a: Attributes ChildOf; BelongsTo; Filter

2007-02-20T02:27:00.000+05:30

ChildOf attribute
The ChildOf attribute is used with Collections. It controls how the Collection is displayed. Example:-

[Collection: My Collection]
    Type: Ledger
    ChildOf: $$GroupSundryDebtors

The above TDL code returns all the Ledgers directly falling under Group "Sundry Debtors".

BelongsTo attribute
The BelongsTo attribute returns all the objects directly or indirectly falling under the specified Collection. Example:-

[Collection: My Collection]
    Type: Ledger
    ChildOf: $$GroupSundryDebtors
    BelongsTo: Yes

The above TDL code returns all the Ledgers falling under Group "Sundry Debtors" and its sub-groups.

Filter attribute
The Filter attribute is used to set a filter on the Collection. Example:-

[Collection: My Collection]
    Type: Ledger
    ChildOf: $$GroupSundryDebtors
    BelongsTo: Yes
    Filter: MyFilter


[System: Formula]
    MyFilter: $ClosingBalance > 0

The above TDL code returns all the Ledgers falling under Group "Sundry Debtors" and its sub-groups where the ClosingBalance is greater than Zero.

A TDL program illustrating the above attributes is given herewith for your reference. Click here to download the Example 12a compiled file and the source-code.

Example 12: More on Collections

2007-02-19T05:15:00.000+05:30

This program creates a Collection of Objects which store Employee data viz (Name; Birthdate etc). It illustrates how you can use User-Defined-Collections and display the data in Report. Also uses TDL Internal date functions viz a) $$YearofDate b) $$ MonthofDate c) $$ DayofDate

Click here to download the Example 12 compiled file and the source-code.

Example 11: Objects & Collections

2007-02-17T01:27:00.000+05:30

OBJECTS
Objects in TDL are classified as Internal Objects and External Objects.

Internal Objects
There are several pre-defined Internal Objects in TDL viz. Company, Group, Ledger, Stock Group, Stock Item, Voucher, Voucher Type etc.

External Objects or User-defined Objects
You can define your own Objects in TDL. Example:-

[Object: Contact1]
    Name: "Dinesh Shukla"
    Email: abc@mycompany.com
    Phone: "9987654321"


[Object: Contact2]
    Name: "Aakash Choudhary"
    Email: xyz@mycompany.com
    Phone: "123456"

We shall be using Internal and External Objects quite frequently in the succeeding sections of this tutorial.

Collections
A Group of Objects is referred as a Collection. You can create a collection of the Objects as follows:-

[Collection: My Collection]
    Object: Contact1
    Object: Contact2

A Program illustrating the use of Objects and Collection is provided for your reference. Click here to download the Example 11 compiled file and the source-code.

Retrieving Value of Internal Objects & Internal Functions

2007-02-17T01:08:00.000+05:30

Symbol '$'
The symbol '$' is used to retrieve the value of Internal Objects. For example, '$' can be used to fetch the ClosingBalance or Name field-value of the Internal Object LEDGER.

[Field: My Field]
    Set as: $Name

Symbol '$$'
The symbol '$$' is used to retrieve the Function Values in TDL. For example, '$$' can be used to fetch the Date as shown below.

[Field: My Date]
    Set as: $$MachineDate

There are several Internal functions in TDL which shall be discussed in the forth coming sessions.

Local and Global Formulae

2007-02-17T00:35:00.000+05:30

A Formulae is like a macro used in other programming languages. It allows you to define a NAME for a value.

Local Formulae

[Field: My Field]
    Set as: @Company
    Company: "ABC PVT LTD"


In the above field definition, the "Set as" attribute is used to set the value of the field using a local formulae "Company" To access local formulae, "@" symbol is used.

Global Formulae

[System: Formula]
    MyBackgroundColor: "Yellow"


[Field: MyField]
    Set as: "www.tdlplayground.blogspot.com"
    Background: @@MyBackgroundColor


When you require a formula in more than one fields, you need to create a Global formula. To access Global formula value, the symboll "@@" is used.

Example 10: UDFs

2007-02-15T23:04:00.000+05:30

You can add new fields in any Master entry screen or Voucher entry screen by creating UDFs (User-defined Fields). UDFs can be of type String, Number, Date, Logical, Amount, Quantity or Rate.


Syntax:-
[System: UDF]
    <UDF Name>: <UDF Type>: <Index>: <Is Repeatable>


Example:-
[System: UDF]
    MyUDF: String: 1000

Notes:-
1) UDFs are to be defined at the System level.
2) Each UDF must be given a Unique Name.
3) As Index number is to be provided for evey UDF which must be between 1 to 9999.
4) Is Repeatable specifies whether the UDF holds single or multiple values. By default, it is NO, meaning the UDF can store a single value only.

Example:- Adding a new field in the Ledger Master

;;UDF definition
[System: UDF]
    MyUDF: String: 1000


;;Modify the Ledger Master entry screen and add a new line
[#Part: Led Other Details]
    Add: Line: MyLine


[Line: My Line]
    Field: Short Prompt,My Field
    ;;Display Text 
    Local: Field: Short Prompt: Set as: "UDF field: "


[Field: My Field]
    Use: Short Name Field
    Storage: MyUDF

Click here to download the Example 10 compiled file and the source-code.

Example 9: The power of Inheritance

2007-02-14T02:21:00.000+05:30

The keyword "USE" allows you to inherit from other Objects. Example:-


;;This defines a style named "MyStyleBold"
[Style: MyStyleBold]
    Font: Verdana
    Bold: Yes
    Height: 8


;;This defines a style named "MyStyleBoldLarge" that inherits from style "MyStyleBold"
[Style: MyStyleBoldLarge]
    Use: MyStyleBold
    Height: 15

You may define Objects that inherit from any other User-defined Object or even from the default TDL Objects. In simple words, you can define a report which inherits from the default TDL report "Balance Sheet" and then you may customize it as per your requirement.

Click here to download the Example 9 compiled file and the source-code.

Example 8: Display a small dialog-box and accept user-input

2007-02-14T01:21:00.000+05:30

This programs displays a small dialog-box and prompts the user to input Yes or No. The objective of this program is to teach how to create simple dialog-boxes and accept input from the user.

Click here to download the Example 8 compiled file and the source-code.

Example 7: Local and Global Variables

2007-02-13T03:25:00.000+05:30

Local Variables
The scope of Local variables is restricted to the Report in which they are defined. Before you can use a local variable, you need to define it. To access the value of a local variable, you must prefix the variable name with symbol #


Local Variable definition
[Variable: myVar]
    Type: String


Using the Local variable in your Report
[Report: My Report]
    Form: MyForm
    Variable: myVar
    Set as: "Learn TDL at www.tdlplayground.blogspot.com"


Accessing the Local Variable value
[Field: My Field]
    Set as: #myVar


Global Variables
Global variables can be used globally (i.e. in all Reports). A Global variable must be declared in the [System: Variable] section. To access a Global variable, you must prefix the variable name with ##.


Global Variable definition
[System: Variable]
    myVar: "Initial Value"


Accessing the Global Variable value
[Field: My Field]
    Set as: ##myVar


Other Variable types supported by Tally
1) Logical
2) Date
3) Number
4) Amount
5) Quantity
6) String
7) Rate of Exchange

A sample TDL program (with source-code) has been provided which illustrates the use of Variables. Click here to download the Example 7 compiled file and the source-code.

TDL basics - An overview

2007-02-10T07:20:00.000+05:30

Tally Definition is a proprietory language of "Tally Solutions FZ LLC". It is used to customize the Tally sofware.

TDL is not a full-fledged programming language, but it is a Definition's language. It has its own pros and cons. Using TDL, you can add new menu-options, new reports, new entry screens in Tally 7.2 or Tally 9. However, the programmer does not have any control over the event-driven functionality of Tally.

TDL Basics - An Overview

1. Names are neither case-sensitive nor space-sensitive.
[Report: MyReport] is the same as [Report: MYREPORT]
[Report: My Trial Balance] is the same as [Report: MyTrialBalance]

2. Names should not start with numerals.

3. Comments in TDL are written using double semi-colon (i.e. ;;)

4. A TDL program comprises of TDL statements / definitions and can be written using any text editor (example:- Notepad)

5. To compile TDL program, you require Tally Developer which can be purchased from Tally Solutions or any Tally authorised Dealer. [If you don't have Tally Developer, you may send your TDL programs to mailto:tdlplayground@rtslink.com.

6.All reports in Tally Accounting software have been created using TDL.

7.You can modify existing Menu's in Tally and add your own menu-options. Example:-
[#Menu: Gateway of Tally]
Add: Item: My Reports: Display: rptMyReport

The above code modifies the "Gateway of Tally" menu, and adds a new menu-option "My Reports". When the user clicks on "My Reports" menu-option, it display a report named "rptMyReport". The "#" symbol is used to modify existing definitions.

8.Normally, forms are used in programming languages like VB, VFP, Delphi etc to display text and accept user input. In TDL, you have to use the Report definition which uses the following:-
Report uses Form
Form uses Parts
Part uses lines
Line uses Fields
Field is the real-container where text is displayed.

Remarks:- ratta laga le bhai. Isme samajne jaissa kuch bhi nahi hai.

9.Actions are used to implement/activate the definitions. Example, Display action is used below.
[#Menu: Gatway of Tally]
Add: Item: My Reports: Display: rptMyReport

10. Attributes are like properties. Example, Width and Style
[Field: My Field]
Width: 30
Style: Normal Bold

11. Dimensions in TDL can be expressed in different ways
.
[Form: My Form]
;; This specifies the dimension of the form in centimeters
Width: 15 cms
Height: 25 cms

[Form: My Form]
;; This specifies the dimension of the form in Inches
Width: 2 Inches
Height: 2 Inches

[Form: My Form]
;; This specifies the dimension of the form in screen percentage
Width: 15% screen
Height: 25% screen

12. Some of the important attributes that we shall be using with different Definitions are:-

Width: 30% screen
Height: 30% screen
BackGround: Yellow
Invisible: No
Inactive: No
Set as: "Welcome to TDL"
Space Top: 2
Space bottom: 2
Space Left: 2
Space Right: 2

The above attributes are to be used with their appropriate Definitions only.

13. Button is an attribute of Menu and Form definition and is used to intiate actions.

[Button: My Button]
Title: "My Balance Sheet"
Key: F4
Action: Display: Balance sheet

[#Menu: Gateway of Tally]
Button: My Button

The above code is used to display button "My Balance Sheet" in the "Gateway of Tally" menu. It is invoked by pressing F4 function key.

14.Optional defintions
A TDL program mainly comprisely of definitions and actions. Actions are performed on Definitions to implement/activate them.

TDL allows you to use Optional definitions. In simple words, Optional definition is a definition that is activated/executed if specified condition evaluates to be true. Example:-

;;This is an a regular Form definition
[Form: My Form]
Width: 10% screen
Height: 10% screen
Option: TestForm1: #myVariable

;;This is an optional definition
[!Form TestForm1]
Width: 30% screen
Height: 30% screen

Notes:
a) If the value of variable "myVariable" evaluates to be true, then the optional definition "TestForm1" becomes part of the original definition "My Form".
b) In other words, the original definiton is over-ridden by the Optional definition .

FINAL WORDS
Please send in your views/comments to mailto:tdlplayground@rtslink.com. Please mention whether you found this article to be useful or not. Your valuable suggestions are solicited.

From
Shweta Computers Team

Example 6: Adding BUTTONs in TDL Form

2007-02-07T22:21:00.000+05:30

This programs illustrates the use of BUTTON definition and OPTION attribute

[#Menu: GatewayOfTally]
    Add: Item: MyOption : Display: rptReport


;;This report uses a Local variable lChooseHeight which is initially set to "No" 
[Report: rptReport]
    Add: Form: frmForm
    Add: Variable: lChooseHeight 
    Set: lChooseHeight : No


;;When the logical condition is true, the modified definition becomes the part of the original definition
[Form: frmForm]
    Add: Part: prtPart
    Add: Button : btnButton1
    Option : Small HelloWorld Form: Not #lChooseHeight
    Option : Full HelloWorld Form: #lChooseHeight


;;Optional Definitions start with exclamation sign !
[!Form: Small HelloWorld Form]
    Background: Yellow
    Set: fldField1: This is Yellow
    Width: 50% screen
    Height: 50% screen


;;Optional Definitions start with exclamation sign !
[!Form: Full HelloWorld Form]
    Background: Green
    Set: fldField1: This is Green
    Width: 100% screen
    Height: 100% screen


;;Local Variable definition
[Variable: lChooseHeight]
    Type: Logical


[Part: prtPart]
    Add: Line : lnLine1


[Line: Lnline1]
    Add: Field: fldField1


[Field: fldField1]
    Set as: "Press F4 key to change the Form-size and color"


;;Defining a Button with F4 as the shortcut key. 
;;When user presses F4 key, the value of variable lChooseHeight changes
;;This will replace the original Form definition with the modified definition
;;===========================================================================
[Button: btnButton1]
    Key: F4
    Action: Set: lChooseHeight: Not #lChooseHeight

Notes:
1) The form "frmForm" uses a button which is displayed in the Button panel on the right-side of the screen.
2) The Option Attribute provides a means to substitue the original definition with modified definition. In the above code, two optional definitions have been used. The syntax of Option keyword is :-
Syntax: Option : <Modified Definition>: <Logical condition>

Click here to download the Example 6 compiled file and the source-code.

Example 5: Using Font-styles, Colors in TDL

2007-02-07T19:10:00.000+05:30

This program shows how you can use different font-styles, colors in TDL

;;Modifies the "Gateway of Tally" menu, and adds a new menu-option 
[#Menu: Gateway of Tally]
    Add: Item: Fonts Style,Colors: Display: rptMyReport


;;Report definition
;;==========================================
[Report : rptMyReport]
    Form : frmMyForm


;;Form definition: Size is 50% of the screen
;;Margins kept at TOP and BOTTOM
;;==========================================
[Form : frmMyForm]
    Space Top:2
    Space Bottom: 2
    Part : prtMyPart
    Height: 50% screen
    Width: 50% screen
 

;;Part definition - Contains 8 lines
;;==========================================
[Part : prtMyPart]
    Line : lnMyLine1
    Line : lnMyLine2
    Line : lnMyLine3
    Line : lnMyLine4
    Line : lnMyLine5
    Line : lnMyLine6
    Line : lnMyLine7
    Bottom Line: lnMyLine8


;;Line definitions
;;==========================================
[Line: lnMyLine1]
    Field : My Field1


[line : lnMyLine2]
    Field : My Field2


[line : lnMyLine3]
    Field : My Field3


[line : lnMyLine4]
    Field : My Field4


[line : lnMyLine5]
    Field : My Field5


[line : lnMyLine6]
    Field : My Field6


[line : lnMyLine7]
    Field : My Field7


[line : lnMyLine8]
    Field : My Field8


;;Field definitions
;;==========================================
[Field: My Field1]
    Space Left: 5 
    Space Right: 5
    Set as: "This line is BOLD"
    Style: styMyStyle1


[Field: My Field2]
    Space Left: 5 
    Space Right: 5
    Set as: "This line is Italics"
    Style: styMyStyle2


[Field: My Field3]
    Space Left: 5 
    Space Right: 5
    Set as: "This line is BOLD and ITALICS"
    Style: styMyStyle3


[Field: My Field4]
    Space Left: 5 
    Space Right: 5
    Set as: "This line is right-aligned"
    Width:60
    Alignment:Right


[Field: My Field5]
    Space Left: 5 
    Space Right: 5
    Set as: "This line is center-aligned"
    Width:60
    Alignment:Center


[Field: My Field6]
    Space Left: 5 
    Space Right: 5
    Set as: "This line is left-aligned"
    Width:60
    Alignment:left


[Field: My Field7]
    Space Left: 5 
    Space Right: 5
    Set as: "This line appears in Red color with Yellow Background"
    Background: Yellow
    Color: Red


[Field: My Field8]
    Space Left: 5 
    Space Right: 5
    Set as: "This line appears at bottom in 15-pt font size"
    Style: styMyStyle4


;;Style definitions
;;==========================================
[Style: styMyStyle1]
    Font: Verdana
    Bold: Yes
    Height: 10


[Style: styMyStyle2]
    Font: Verdana
    Italic: Yes
    Height: 10


[Style: styMyStyle3]
    Font: Verdana
    Bold: Yes
    Italic: Yes
    Height:10


[Style: styMyStyle4]
    Font: Verdana
    Height:15

Click here to download the Example 5 compiled file and the source-code.

NEWFONTS .TCP

2007-02-07T04:56:00.000+05:30

This TCP file has been provided by Mr Vikas Thapar, Ludhiana, Punjab. You can reach him at akshitthapar@yahoo.com

Functionality
NEWFONTS.TCP file changes the Invoice Fonts in the neat-mode printing.

Steps to use NEWFONTS.TCP
1) Include NEWFONTS.TCP in the Tally.ini file as described in the Introduction blog section.
2) Try-out printing any Sales Invoice.

Click here to download the Newfonts compiled file.

BUYCON.TCP

2007-02-07T04:10:00.000+05:30

This TCP file has been provided by Mr Vikas Thapar, Ludhiana, Punjab. You can reach him at akshitthapar@yahoo.com

Functionality
BUYCON.TCP displays Ledger help-list in the "Supplementary Details" section of Sales Voucher (in EDIT mode).

Steps to use BUYCON.TCP
1) Include BUYCON.TCP in the Tally.ini file as described in the Introduction blog section.
2) Use option "Gateway of Tally -> F12 -> Invoice/Order Entry" and enable the "Accept Supplementary details" option.
3) Modify any existing Sales Voucher. Move on to the Buyer's details section (yellow-color window) and press spacebar in the BUYER field. This will bring forth the Ledger help-list.

Click here to download the Buycon compiled file.

Example 4: Display a Sub-Menu with Indentation

2007-02-05T23:37:00.000+05:30

[#Menu: Gateway of Tally]
    Add: Item: Before: ~Quit: MySoftware: Menu: MySoftware


[Menu: MySoftware]


    ;;Masters section menu-items
    Indent: Masters
    Item: BLANK
    Item: Ledger Master
    Item: Item Master
    Item: BLANK


    ;;Reports section menu-items
    Indent: Reports
    Item: BLANK
    Item: MyReport1
    Item: MyReport2


    ;;Don't use "Add: Item: Ledger Master" as this will add the Item to the end of the list

Notes:-
1) The above program displays a Sub-Menu with Indentation

Click here to download the Example 4 compiled file and the source-code.

Example 3: Display a Form

2007-02-05T22:45:00.000+05:30

[#Menu: Gateway of Tally]
    ;; This will add a Menu-option before the Balance Sheet 
    Add: Item: Before: ~Balance Sheet: MyOption: Display: rptMyReport
 

    ;; Remarks
    ;; To add menu-option after Balance Sheet, use keyword After
    ;; Example:-
    ;; Add: Item: After:~Balance Sheet: MyOption: Display: rptMyReport
    ;; or
    ;; Add: Item: At Beginning: MyOption: Display: rptMyReport
    ;; or
    ;; Add: Item: At End: MyOption: Display: rptMyReport


[Report: rptMyReport]
    Add: Form: frmMyForm


[Form: frmMyForm]
    Add: Part: prtMyPart


    ;; This specifies that the width of the form must be 40% of the screen width
    Width: 40% screen

    ;; This specifies that the height of the form must be 50 of the screen height
    Height: 50% screen


[Part: prtMyPart]
    Add: Line: lnMyLine

[Line: lnMyLine]
    Add: Field: fldMyField


[Field: fldMyField]
    Set as : "Here's a Sample FORM"

Notes:-
1) The above program defines a menu-option "MyOption" in the "GateWay of Tally" screen before Balance Sheet. Note the tidle character ~ in front of Balance Sheet which highlights the next letter after it.
2) When the user selects this option "MyOption", it displays a Form.

Click here to download the Example 3 compiled file and the source-code.

Example 2: Add a Sub-Menu option

2007-02-04T13:43:00.000+05:30

[#Menu: Gateway of Tally]
    Item: MyOption: Menu: MySubMenu


[Menu: MySubMenu]
    Item: MyOption1
    Item: MyOption2
    Item: MyOption3

Notes:-
1) The above program defines a menu-option "MyOption" in the "GateWay of Tally" screen
2) When the user selects this option "MyOption", it displays a sub-menu with three options

Click here to download the Example 2 compiled file and the source-code.

Example 1: Add a Menu-option

2007-02-04T01:58:00.000+05:30

[#Menu: Gateway of Tally]
    Item: MyOption: Display: rptMyReport
 

[Report: rptMyReport]
    Form: frmMyForm


[Form: frmMyForm]
    Part: prtMyPart


[Part: prtMyPart]
    Line: lnMyLine


[Line: lnMyLine]
    Field: fldMyField


[Field: fldMyField]
    Set as : "Learn, Play and have fun with TDL"

Notes:-
1) Comments in TDL are written using double semi-colon ;;
2) The above TDL code contains several definitions viz. Menu,Report, Form, Part, Line, Field
3) Definitions are always written in square brackets
4) The # symbol modifes the default TDL menu "Gateway of Tally"

Click here to download the Example 1 compiled file and the source-code.

Introduction to Tally Definition Language (TDL)

2007-02-04T01:46:00.000+05:30

Tally Definition Language (TD) is a proprietary language of "Tally Solutions FZ LLC" and is specific to Tally only. You can use TDL for customizing Tally software as per your requirements.

READ our sample programs to know more about progamming with Tally Definition Language. We shall be posting sample programs regularly on this blogspot. Initially, we shall start with some basic features of TDL and later-on move to more advanced topics.

You can create your own TDL programs using any text-editor (like NOTEPAD). To compile these program, you need Tally Developer 2.7 which can purchased from Tally Solutions or any other Tally Authorised Dealer or Service centre.

Please note that we don't sell Tally Developer 2.7.

When you compile your TDL program using Tally Developer, a TCP (Tally Compiled Program) file is generated. To use this TCP file, you need to do certain changes in the Tally.ini file. The Tally.ini file is located in the directory where Tally Software is installed.

Changes required in Tally.ini
USER TDL = YES
TDL = C:\TALLY\TDL1.TCP

Remarks:-
a) You are required to copy your TCP file to the Tally directory.
b) Use NOTEPAD to open and modify the Tally.ini file.

Create your own TDL programs
As mentioned earlier, TDL programs are simple text files that contain TDL statements. You can easily create TDL programs using Notepad. Next, you need to compile it. In case, if you don't have the Tally Developer software, you can send us your TDL file (i.e. simple text file with TDL statements) to us. We shall compile it and send it back to you. You can mail your TDL programs to TDLplayground@rtslink.com. However, we cannot give you 100% commitment that all such requests will be entertained because of the large number of emails that we receive.

If your program is worth its salt, we shall publish it in this blogspot (of-course with your prior-permission).

You can visit us at www.rtslink.com