rtslink.com
Home / RTSlink DLL / More on Tally Integration / TDL Functions

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.
Example:-
Fetch Ledger-Alias using SQLRequest()
$$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 nth Method/field of a Collection.
Sample program using $$CollectionList  function
$$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.
Refer program TDL42
$$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

Refer program TDL34
$$IsFirstObject $$IsFirstObject Logical Returns true if the current Object is the 1st object of the Collection. Refer program TDL42
$$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. Refer Example at
www.rtslink.blogspot.com
$$SerialNumber $$SerialNumber String Returns the Tally Serial Number. Refer example at
www.rtslink.blogspot.com
$$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:"Shweta Softwares"
$$StringPart $$StringPart: <expC>: <StartPos>: <Length> String Used to extract a sub-string from another string.
Example:-
[Field: My Field]
  Set as: $$StringPart:"Shweta 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:"Shweta Softwares Gandhidham"
This returns the word "Gandhidham". 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:"Shweta 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'.
Refer program TDL34
$$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"


You can test check the TDL functions by writing TDL code or by using WRAPPER.EXE provided with RTSlink DLL.

STEPS for using WRAPPER.EXE to try out the TDL functions:-
1) Create a plain text file (say SQL1.TXT) using notepad which contains the following text:-
     SELECT  $$Max:100:15  from Company

2) Save the file in C:\RTSlink folder.

3) Go to DOS prompt and change to C:\RTSlink folder.
    (It is assumed that you have already downloaded and installed RTSlink DLL)

4) Type the following command:-
    Wrapper  <FileName>   /SQL

5) This will generate response in a file named RESPONSE.LOG

Tags:

Tally Developer, Tally Definition Language, Tally Customization, Tally 7.2, Tally 9, Free Tally Training, Download Tally 9 TDL
Tally is a registered trademark of Tally Solutions FZ LLC.

Valid HTML 4.01 Transitional