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