List of TDL Functions

An Alphabetical-list of TDL functions (Partial list) is provided

herewith for your reference.
Return
Function Syntax Remarks
Value
Same as Returns the absolute
$$Abs $$Abs : <Expression> parameter (positive) value for the
type given expression
$$Alias returns alternate
value for the current
$$Alias $$Alias String
Object. Stock Item and
Ledger have Alias name.
Checks whether the
current user has
$$Allow : <mode> :
$$Allow Logical permission to access the
<family-report-name>
specified object or
report.
$$CollectionList: $$CollectionList function
Method/
<Method/Field> : is used to fetch
$$CollectionList Field
<PositionNumber> : the nthMethod/field of a
Datatype
<Collection> Collection.
Returns the Period
$$DateFrom $$DateFrom Date
starting date
Returns the Period
$$DateTo $$DateTo Date
ending date
$$FullList function is
used to fetch any
$$FullList : Method/
Method/Field of a
$$FullList <Collection> : Field
Collection. The
<FieldList> Datatype
Method/Field values are
separated by commas.
Returns true if the
$$InPrintMode $$InPrintMode Logical selected mode is Print,
otherwise false.
Checks whether the
$$IsContra :
$$IsContra Logical specified VoucherType is
<VoucherTypeName>
Contra
Checks whether the
$$IsCreditNote :
$$IsCreditNote Logical specified VoucherType is
<VoucherTypeName>
CreditNote
Checks whether the
$$IsDebitNote :
$$IsDebitNote Logical specified VoucherType is
<VoucherTypeName>
DebitNote
 Checks whether the
$$IsDelNote :
$$IsDelNote Logical specified VoucherType is
<VoucherTypeName>
Delivery Note
Checks whether the
parameter passed is
empty or not. Parameter
$$IsEmpty: type can be String;
$$IsEmpty Logical
<parameter> Numeric; Date; Logical

Example:-
$$IsEmpty:$$Value
Returns true if the
$$IsFirstObject $$IsFirstObject Logical current Object is the 1st
object of the Collection.
Checks whether the
$$IsJournal :
$$IsJournal Logical specified VoucherType is
<VoucherTypeName>
Journal
Checks whether the
$$IsMemo :
$$IsMemo Logical specified VoucherType is
<VoucherTypeName>
Memo
Checks whether the
$$IsPayment :
$$IsPayment Logical specified VoucherType is
<VoucherTypeName>
Payment Voucher
Checks whether the
$$IsPhyStock :
$$IsPhyStock Logical specified VoucherType is
<VoucherTypeName>
PhysicalStock Voucher
Checks whether the
$$IsPurchase :
$$IsPurchase Logical specified VoucherType is
<VoucherTypeName>
Purchase Voucher
Checks whether the
$$IsPurcOrder :
$$IsPurcOrder Logical specified VoucherType is
<VoucherTypeName>
Purchase Order Voucher
Checks whether the
$$IsRcptNote :
$$IsRcptNote Logical specified VoucherType is
<VoucherTypeName>
ReceiptNote Voucher
Checks whether the
$$IsReceipt :
$$IsReceipt Logical specified VoucherType is
<VoucherTypeName>
Receipt Voucher
Checks whether the
$$IsRejIn :
$$IsRejIn Logical specified VoucherType is
<VoucherTypeName>
RejectionIn Voucher
Checks whether the
$$IsRejOut :
$$IsRejOut Logical specified VoucherType is
<VoucherTypeName>
RejectionOut Voucher
 Checks whether the
$$IsRevJrnl :
$$IsRevJrnl Logical specified VoucherType is
<VoucherTypeName>
Reverse Journal Voucher
Checks whether the
$$IsSales :
$$IsSales Logical specified VoucherType is
<VoucherTypeName>
Sales Voucher
Checks whether the
$$IsSalesOrder :
$$IsSalesOrder Logical specified VoucherType is
<VoucherTypeName>
Sales Order Voucher
Checks whether the
$$IsStockJournal :
$$IsStockJournal Logical specified VoucherType is
<VoucherTypeName>
StockJournal Voucher
Return
Function Syntax Remarks
Value
Accepts a string parameter
$$LocaleString: Unicode and returns unicode string.
$$LocaleString
<string> string This is to provide multi-
lingual support to Tally
Checks whether the Field
value of the <Field> is
equal to the <ExpC>

Example:
$$IsVchTypeOfFamily:
$VoucherTypeName :
$$IsVchTypeOfFamily
$$IsVchTypeOf "Payment"
:<VoucherTypeName Logical
Family
>
Remarks:
The function
$$IsVchTypeOfFamily
returns true if the Field-
value of
$VoucherTypeName is
"Payment"
Returns the Date as per
your computer system
settings
$$MachineDate $$MachineDate Date
Example:-
Select $$MachineDate from
Company
Returns the Time as per
your computer system
settings
$$MachineTime $$MachineTime String
Example:-
Select $$MachineTime from
Company
 Returns the Miniimum
value. The parameter type
Same as
$$Max : can be Numeric, Date or
$$Max parameter
<Expression> String
type
Example:-
$$Max:100:15 returns 100
Returns the Miniimum
value. The parameter type
Same as
can be Numeric, Date or
$$Min $$Min : <Expression> parameter
String
type
Example:-
$$Min:100:15 returns 15
Returns the ending date of
the specified month.
$$MonthEnd:
$$MonthEnd Date Example:-
<ExpD>
Select
$$MonthEnd:$$MachineDat
e from Company
Returns the Month
(example 12) of the
specified date
$$MonthOfDate:<Exp
$$MonthOfDate Numeric
D> Example:-
Select
$$MonthOfDate:$$Machine
Date from Company
Returns the starting date of
the specified month.
$$MonthStart:
$$MonthStart Date Example:-
<ExpD>
Select
$$MonthStart:$$MachineDa
te from Company
$$Round function is used to
round-off a value
$$Round : <ExpN> :
$$Round Numeric Example:-
<RoundLimit>
$$Round : 125.72 :
0.10 returns 125.70
$$Round function is used to
$$RoundDown : round-off a value
$$RoundDown <ExpN> : Numeric Example:-
<RoundLimit> $$Round : 125.72 :
0.10 returns 125.70
$$Round function is used to
$$RoundUp : <ExpN>
$$RoundUp Numeric round-off a value
: <RoundLimit>
Example:-
 $$Round : 125.72 :
0.10 returns 125.80
Returns the number of
$$SelectedCmps $$SelectedCmps Numeric companies currently open in
Tally Software.
Returns the Tally Serial
$$SerialNumber $$SerialNumber String
Number.
Converts numeric
expression into string.
$$String $$String: <ExpN> String Example:-
[Field: My Field]
Set as : $$String:500
Returns the length of the
string parameter
Example:-
$$stringLength:
$$StringLength Numeric [Field: My Field]
<ExpC>
Set as:
$$StringLength:"tally
Softwares"
Used to extract a sub-string
from another string.
Example:-
[Field: My Field]
Set as: $$StringPart:"Tally
Softwares":7:9
$$StringPart:
<expC>:
$$StringPart String Remarks:-
<StartPos>:
This will return
<Length>
"Computers".i.e. beginning
at the 8th character, it
returns the next 9
characters. Please note that
the 1st character is
numbered as 0.
Returns the remaining word
from the <ExpC> string
after the Index.

Example:-
$$StringRemWo $$StringRemWord:
String $$StringRemWord:2:"tally
rd <Index>: <ExpC>
Softwares bangalore"
This returns the word
"bangalore". i.e. the word
after 2 words as specified
by the Index
Returns the word specified
$$StringWord:
$$StringWord String by the Index.
<Index>: <ExpC>
 Example:-
$$StringWord:2:"tally
Softwares Gandhidham"
This returns the word
"Computers". i.e. the 2nd
word as specified by the
Index
$$SysName: Specifies the System-name
$$SysName String
<reserved-string> for the reserved string
Returns the value for the
System variable
SVFROMDATE

$$SystemPeriod Example:-
$$SystemPeriodFrom Date
From Select $$SystemPeriodFrom
from Company
or
Select ##SVFROMDATE
from Company
Returns the value for the
System variable SVTODATE

Example:-
$$SystemPeriod
$$SystemPeriodTo Date Select $$SystemPeriodTo
To
from Company
or
Select ##SVTODATE from
Company
Converts the string to
$$Upper $$Upper: <ExpC> String
upper-case
Returns the value of a
field/method.

Example:-
[Field: My Field]
Method/Fie Use: Name Field
$$Value $$Value ld data Validate: NOT
type $$IsEmpty:$$Value

In the above code, function

$$Value is used which
returns the value of the
field 'My Field'.
Returns the Year for the
specified Date.
$$YearOfDate:
$$YearOfDate Numeric
<ExpD> Example:-
Select
$$YearOfDate:$$MachineDa
 te from Company

The above returns the year

(.i.e 2007)
Returns the Year end-date
for the Current year (based
on the Date passed as
parameter)

Example:-
$$YearEnd $$YearEnd: <ExprD> Date Select
$$YearEnd:##SVTODATE
from Company

The above returns the year-

end date (ex. in my system
it returns 31-3-2008).
$$Zero pads the given
string with zeros.
$$ZeroFill : <ExpC> :
$$ZeroFIll String Example:-
<ExpN>
$$Zero : "525" :
5 returns "00525"