List of TDL Functions

An Alphabetical-list of TDL functions  (Partial list) is provided herewith  for your reference.  

Function	Syntax	Return Value	Remarks
$$Abs	$$Abs : <Expression>	Same as parameter type	Returns the absolute (positive) value for the given expression
$$Alias	$$Alias	String	$$Alias returns alternate value for the current Object. Stock Item and Ledger have Alias name.
$$Allow	$$Allow : <mode> : <family-report-name>	Logical	Checks whether the current user has permission to access the specified object or report.
$$CollectionList	$$CollectionList: <Method/Field> : <PositionNumber> : <Collection>	Method/ Field Datatype	$$CollectionList function is used to fetch the nthMethod/field of a Collection.
$$DateFrom	$$DateFrom	Date	Returns the Period starting date
$$DateTo	$$DateTo	Date	Returns the Period ending date
$$FullList	$$FullList : <Collection> : <FieldList>	Method/ Field Datatype	$$FullList function is used to fetch any Method/Field of a Collection. The Method/Field values are separated by commas.
$$InPrintMode	$$InPrintMode	Logical	Returns true if the selected mode is Print, otherwise false.
$$IsContra	$$IsContra : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Contra
$$IsCreditNote	$$IsCreditNote : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is CreditNote
$$IsDebitNote	$$IsDebitNote : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is DebitNote
$$IsDelNote	$$IsDelNote : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Delivery Note
$$IsEmpty	$$IsEmpty: <parameter>	Logical	Checks whether the parameter passed is empty or not. Parameter type can be String; Numeric; Date; Logical Example:- $$IsEmpty:$$Value
$$IsFirstObject	$$IsFirstObject	Logical	Returns true if the current Object is the 1st object of the Collection.
$$IsJournal	$$IsJournal : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Journal
$$IsMemo	$$IsMemo : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Memo
$$IsPayment	$$IsPayment : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Payment Voucher
$$IsPhyStock	$$IsPhyStock : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is PhysicalStock Voucher
$$IsPurchase	$$IsPurchase : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Purchase Voucher
$$IsPurcOrder	$$IsPurcOrder : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Purchase Order Voucher
$$IsRcptNote	$$IsRcptNote : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is ReceiptNote Voucher
$$IsReceipt	$$IsReceipt : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Receipt Voucher
$$IsRejIn	$$IsRejIn : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is RejectionIn Voucher
$$IsRejOut	$$IsRejOut : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is RejectionOut Voucher
$$IsRevJrnl	$$IsRevJrnl : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Reverse Journal Voucher
$$IsSales	$$IsSales : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Sales Voucher
$$IsSalesOrder	$$IsSalesOrder : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is Sales Order Voucher
$$IsStockJournal	$$IsStockJournal : <VoucherTypeName>	Logical	Checks whether the specified VoucherType is StockJournal Voucher

Function	Syntax	Return Value	Remarks
$$LocaleString	$$LocaleString: <string>	Unicode string	Accepts a string parameter and returns unicode string. This is to provide multi-lingual support to Tally
$$IsVchTypeOf Family	$$IsVchTypeOfFamily :<VoucherTypeName>	Logical	Checks whether the Field value of the <Field> is equal to the <ExpC> Example: $$IsVchTypeOfFamily: $VoucherTypeName : "Payment" Remarks: The function $$IsVchTypeOfFamily returns true if the Field-value of $VoucherTypeName is "Payment"
$$MachineDate	$$MachineDate	Date	Returns the Date as per your computer system settings Example:- Select $$MachineDate from Company
$$MachineTime	$$MachineTime	String	Returns the Time as per your computer system settings Example:- Select $$MachineTime from Company
$$Max	$$Max : <Expression>	Same as parameter type	Returns the Miniimum value.  The parameter type can be Numeric, Date or String Example:- $$Max:100:15  returns 100
$$Min	$$Min : <Expression>	Same as parameter type	Returns the Miniimum value.  The parameter type can be Numeric, Date or String Example:- $$Min:100:15  returns 15
$$MonthEnd	$$MonthEnd: <ExpD>	Date	Returns the ending date of the specified month. Example:- Select $$MonthEnd:$$MachineDate from Company
$$MonthOfDate	$$MonthOfDate:<ExpD>	Numeric	Returns the Month (example 12) of the specified date Example:- Select $$MonthOfDate:$$MachineDate from Company
$$MonthStart	$$MonthStart: <ExpD>	Date	Returns the starting date of the specified month. Example:- Select $$MonthStart:$$MachineDate from Company
$$Round	$$Round : <ExpN> : <RoundLimit>	Numeric	$$Round function is used to round-off a value Example:- $$Round : 125.72 : 0.10   returns 125.70
$$RoundDown	$$RoundDown : <ExpN> : <RoundLimit>	Numeric	$$Round function is used to round-off a value Example:- $$Round : 125.72 : 0.10   returns 125.70
$$RoundUp	$$RoundUp : <ExpN> : <RoundLimit>	Numeric	$$Round function is used to round-off a value Example:- $$Round : 125.72 : 0.10   returns 125.80
$$SelectedCmps	$$SelectedCmps	Numeric	Returns the number of companies currently open in Tally Software.
$$SerialNumber	$$SerialNumber	String	Returns the Tally Serial Number.
$$String	$$String: <ExpN>	String	Converts numeric expression into string. Example:- [Field: My Field]   Set as : $$String:500
$$StringLength	$$stringLength: <ExpC>	Numeric	Returns the length of the string parameter Example:- [Field: My Field]   Set as: $$StringLength:"tally Softwares"
$$StringPart	$$StringPart: <expC>: <StartPos>: <Length>	String	Used to extract a sub-string from another string. Example:- [Field: My Field]   Set as: $$StringPart:"Tally Softwares":7:9 Remarks:- This will return "Computers".i.e. beginning at the 8th character, it returns the next 9 characters. Please note that the 1st character is numbered as 0.
$$StringRemWord	$$StringRemWord: <Index>: <ExpC>	String	Returns the remaining word from the <ExpC> string after the Index. Example:- $$StringRemWord:2:"tally Softwares bangalore" This returns the word "bangalore". i.e. the word after 2 words as specified by the Index
$$StringWord	$$StringWord: <Index>: <ExpC>	String	Returns the word specified by the Index. Example:- $$StringWord:2:"tally Softwares Gandhidham" This returns the word "Computers". i.e. the 2nd word as specified by the Index
$$SysName	$$SysName: <reserved-string>	String	Specifies the System-name for the reserved string
$$SystemPeriod From	$$SystemPeriodFrom	Date	Returns the value for the System variable SVFROMDATE Example:- Select $$SystemPeriodFrom from Company or Select ##SVFROMDATE from Company
$$SystemPeriodTo	$$SystemPeriodTo	Date	Returns the value for the System variable SVTODATE Example:- Select $$SystemPeriodTo from Company or Select ##SVTODATE from Company
$$Upper	$$Upper: <ExpC>	String	Converts the string to upper-case
$$Value	$$Value	Method/Field data type	Returns the value of a field/method. Example:- [Field: My Field]   Use: Name Field   Validate: NOT $$IsEmpty:$$Value In the above code, function $$Value is used which returns the value of the field 'My Field'.
$$YearOfDate	$$YearOfDate: <ExpD>	Numeric	Returns the Year for the specified Date. Example:- Select $$YearOfDate:$$MachineDate from Company The above returns the year (.i.e 2007)
$$YearEnd	$$YearEnd: <ExprD>	Date	Returns the Year end-date for the Current year (based on the Date passed as parameter) Example:- Select $$YearEnd:##SVTODATE from Company The above returns the year-end date (ex. in my system it returns 31-3-2008).
$$ZeroFIll	$$ZeroFill : <ExpC> : <ExpN>	String	$$Zero pads the given string with zeros. Example:- $$Zero : "525" : 5   returns  "00525"

UDF In Ledger Creation

;;Create a Single UDF in Ledger Master to store the value of ECC Number.

[system : UDF]
 LedCustomField : String : 100

[#Part : Led Other Details]
Add : Line : LedCustomField 

[Line:LedCustomField ]
Field : Short Prompt, LedCustomField
Local : Field: Short Prompt:Set as: "Custom Field"

[Field: LedCustomField ]
Use : Short Name Field
Storage : LedCustomField 

Address Book From Tally

;; How to Create Address Book in Tally

[#Menu: Gateway Of Tally]
Add : Item : After : ~Balance Sheet : Address Book : Menu : AddressBookMenu

[Menu: AddressBookMenu]
Add : Item : Sundry Debtors Details : Display : TMSD Address Book
Add : Item : Sundry Creditors Details : Display : TMSC Address Book

[Report: TMSD Address Book]
Use : DSP Template
Form : TMSD Address Book

[Form: TMSD Address Book]
Use : DSP Template
Part : TMSD Address Book Title, TMSD Address Book


[Part : TMSD Address Book Title]
Line : TMSD Address Book Title

[Line : TMSD Address Book Title]
Use : TMSD Address Book
Local : Field : SD Sr No : Set as : "SNo"
Local : Field : SD Name : Set as : "Name"
Local : Field : SD Contact No: Set as : "Contact Person"
Local : Field : SD Phone : Set as : "Phone"
Local : Field : SD Address : Set as : "Address"
Border : Column Titles

[Part : TMSD Address Book]
Line : TMSD Address Book
Repeat : TMSD Address Book : TM Sundry Debtors
Scroll : Vertical
Common Border : Yes

[Line : TMSD Address Book]
Field : SD Sr No, SD Name
Right Field : SD Contact No, SD Phone, SD Address

[Field : SD Sr No]
Use : Short Name Field
Set as : $$Line
Style : Normal
Width : 4
Align : Centre

[Field : SD Name]
Use : Name Field
Set as : $Name
Full Width : Yes
Style : Normal
Border : Thin Left

[Field : SD Contact No]
Use : Short Name Field
Set as : $LedgerContact
Style : Normal
Border : Thin Left

[Field : SD Phone]
Use : Short Name Field
Set as : $LedgerPhone
Style : Normal
Border : Thin Left

[Field : SD Address]
Use : Short Name Field
Set as : $$FullList:Address:$Address
Style : Normal
Border : Thin Left
Lines : 0

[Collection: TM Sundry Debtors]
Type : Ledger
Child of : $$GroupSundryDebtors
Belongs To : Yes


[Report : TMSC Address Book]
Use : TMSD Address Book
Local : Collection : TM Sundry Debtors : Child Of : $$GroupSundryCreditors

How to type Multiple Iines In Narration?

How to Type Multiple Lines In Narration?

After typing each Line Press Ctrl+Enter instead of Enter, Tally will allow Multi Line typing Options

Tally Hidden Keys

How to Copy from Tally ?
Press Ctrl+Alt+C

How to Paste in Tally ?
Press Ctrl+Alt+V

How to Undo In Tally ?
Press Alt+Backspace

Change MENU Options in Tally

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

;;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

Tips on Implementaion of Tally.ERP 9: Your Weekly Refresher...!

New Rupee Symbol

Did you know that the new Indian Rupee Symbol is supported by Tally.ERP 9? This Tally Tip will help you get the symbol? and make you an early adopter of the new standard.

Bill Settlement

Did you know that the Tally.ERP 9 system lets you settle several outstanding bills for a party at one go? Bills for which the actual transfer of goods or services has occurred, but the financial payment is still pending are called outstanding bills. Now you have a faster method to clear a party’s bulk payments for many pending bills together, by simultaneously nullifying the same in your Book of Accounts.

Multiple Addresses

Did you know that the Tally.ERP 9 system enables you to save multiple addresses for your company and ledgers based on your individual requirement?

Logo Printing

Did you know that you can now print your company’s logo on all your reports and invoices generated by the Tally.ERP 9 system?

Mass e-mailing

Did you know that you could send various reports and Pay Slips to multiple recipients right from your Tally.ERP 9 system? Communicating with hundreds of your business partners or customers and sending out individual Confirmation of accounts, Outstanding Reminder Letters and Pay Slips to thousands of partners, customers and employees can’t get any simpler than this.

Multiple Bill of Materials

Did you know that in Tally.ERP 9 you can define multiple bill of materials (BoM) for the same product? You can define the different ratios and combinations of components/materials to be used to manufacture a product. This is a practice that manufacturers follow to create variants in a single product category, for example, different versions of Dettol soap, which differ based on colour, fragrance, etc.

Pre-Closure of Orders

Did you know that Tally.ERP 9 offers a simple and intuitive Pre-closure of orders process eliminating the need to go through a time consuming order adjustment procedure?