User Defined Fields

On this page

Creating a UDF

Storing values in UDF

Retrieve UDF value from Object

UDF classification

In Tally.ERP 9, the structure of an object, the data type and storages required in order to store the data are all predefined by the platform. All the data is stored in the Tally database. By default, data is always stored in predefined storages only.

There may be instances when additional information needs to be stored in the existing objects. This need gave rise to concept of User Defined Fields (UDF). A UDF can be used to store additional information to the Tally database. In other words, UDFs store additional information into the existing objects.

What is UDF?

User Defined Fields have a storage component defined by the user. UDFs are stored in the current object context. They can be of any Tally data type such as String, Amount, Quantity, Rate, Number, Date, Rate of Exchange and Logical.

Defining UDFs does not serve the purpose, unless it is associated with one or more internal object. When a UDF is created and used in an already existing report, the data is stored in the context of the object, i.e., it is always associated to the object to which the report is associated, i.e., the object in context.

Creating a UDF

UDFs should be defined under the section [System: UDF].

Syntax

[System : UDF]

<Name of UDF>: <Data Type>: <Index Number>

Where,

< Name of UDF > Identifies the UDF. Ideally, it should describe the purpose for which it has been created.

< Data Type > is any of the Tally data types or ‘Aggregate’.

< Index Number > can be any number between 1 and 65536.

Numbers falling between 1 to 9999 and 20001 to 65536 are opened for customisation, and those between 10000 to 20000 are allotted for Common development in TSPL. The user can create 65536 UDFs of each data type.

Note: The index numbers 1 to 29 are already used for Default TDL.

Example

[System : UDF]

MyUDF 1 : String : 20003

MyUDF 2 : Date : 20003

The advantage of UDF in Tally is that it automatically attaches with the current object. No specific declaration is required for object association, when the UDF is defined within system definition.

Storing User Inputs in the UDF

The attribute Storage is used to store the value entered in the field, in the current object context.

Syntax

Storage : <Default Storage/Name of UDF>

Where,

< Name of UDF > identifies the UDF. Ideally, it should describe the purpose for which it is created.

Example

[Field : NewField]

Use     : NameField

Storage : MyUDF

Retrieving the value of UDF from an Object

In the context of the current object, the value of a UDF can be accessed by prefixing $ to the UDF name.

Syntax

$<Name of UDF>

Example

[Field: NewField]

Use    : NameField

Set As : $MyUDF

Classification of UDF’s

The UDFs are classified into two types, which are as follows:

Simple UDF

Complex/Compound/Aggregate UDF

Simple UDF

It can store one or more values of a single data type. A UDF used for storage, stores the values in the context of the object associated at Line/Report level, by default. Only one value is stored in this case.

UDF to store a single value

The following example code snippet demonstrates how a UDF can be made use of to store a single value:

Example

[Report : CompanyVehicles]

Object : Company

.

.

.

[Field : CVeh]

Use : Name Field

Storage : Vehicle

Unique : Yes

[System : UDF]

Vehicle : String : 700

The object is associated at the Report Level. The value stored in a UDF is in the context of ‘Company’ Object in this case. The UDF ‘Vehicle’ stores a single string value.

UDF to store multiple values

When multiple values of the same data type are to be stored, then the ‘Repeat’ attribute of Part is used. The field of the line uses the same UDF name in the ‘Storage’ attribute.

Syntax

Repeat : <Line name> : <Name of UDF>

Where,

< Line Name > is the name of the line to be repeated.

< Name of UDF > identifies the name of the UDF to store multiple values. The example in the section “UDF to store single value” can be modified to store multiple values.

Example

[Part : CompVeh]

Line      : CompVeh

Repeat    : CompVeh : Vehicle

Break On  : $$IsEmpty:$Vehicle

Scroll    : Vertical

In this scenario, multiple values of type String can be stored under the object Company.

Creating collection of Values Stored in UDF

Multiple values stored in a UDF can be displayed as Table in a field. The Collection is defined as:

Syntax

[Collection : <Collection Name>]

Type   : <UDF Name> : <Object Name>

Format: $<UDF Name>, 20

Example

[Collection: CMP Vehicles]

Type    : Vehicle : Company

Childof : ##SVCurrentCompany

Format  : $Vehicle, 20

Title   : "Company Vehicles"

It creates a collection of values stored in the UDF of the current object ‘Company’. This collection can be used in the ‘Table’ attribute of ‘Field’ definition. When the cursor is in the defined field, the values stored in the UDF will be displayed as a popup table. Consider the following example:

[Field : EI Vehicles Det]

Use        : Short Name Field

Table      : CMP Vehicles, Not Applicable

Show Table : Always

A popup t able is displayed when the cursor is placed in the field EI V ehicles Det . The t able con t ains values stored in the UDF which are Not Applicable as a list.

Aggregate UDF

A Simple UDF can only store values of a single data type; so, when multiple values of different data types are required to be stored as one entity, an Aggregate UDF can be used.

Aggregate UDFs are very useful for storing multiple values and repeated values. An aggregate UDF is a combination of different types of UDFs. Aggregate UDFs can be used to store user data in a tabular format, attached to any internal object, and can be used as a collection of UDFs.

In other words, an Aggregate UDF comprises of a set of fields repeating more than once. The output can be stated in the form of a record consisting of fields of different types and sizes. When a line is repeated over an Aggregate UDF, it associates all its storage components (same or different data types) as a single unit.

Creating an Aggregate UDF

To create an Aggregate UDF, the data type Aggregate is used while defining the UDF. The components are defined as simple UDFs.

Syntax

[System : UDF]

<Name of UDF> : Aggregate : <Index Number>

Example

A company wants to create and store multiple details of company vehicles. The details required are: Vehicle Number, Brand, Year of Mfg., Purchase Cost, Type of Vehicle, Currently in Service, Sold On date and Sold for Amount.

[System : UDF]

Company Vehicles      : Aggregate : 1000

VVehicle Number       : String : 1000

VBrand                : String : 1001

VYear of Mfg          : Number : 1000

VPurchase Cost        : Amount : 1000

VType of Vehicle      : String : 1002

VCurrently in Service : Logical : 1000

VSold On date         : Date : 1000

VSold for             : Amount : 1001

To store the required details, simple UDFs are defined and to store them as one entit y , a UDF of type Aggregate is defined, as shown in the example.

Using an Aggregate UDF

An Aggregate UDF defined does not associate each component field with it. The association will takes place only when a Line is repeated over an Aggregate UDF and within that Line, there are fields which store the value into the component UDFs.

Syntax

Repeat : <Line name> : <Name of Aggregate UDF>

Where,

< Name of Aggregate UDF > is the name of the UDF defined with Aggregate data type.

Example

[Part : Comp Vehicle]

Line    : Comp VehLn

Repeat  : Comp VehLn : Company Vehicles

BreakOn : $$IsEmpty:$VBrand

.

.

.

[Field : CMP VBrand]

Use     : Short Name Field

Storage : VBrand

The Line is repeated over the Aggregate UDF and the Simple UDFs are entered in the fields.

Using Aggregate UDF in a Sub-Form

Subform is an attribute that is used within a Field definition. It relates to a report (not Form) and can be invoked by a field. This attribute is useful to activate a report within a report, perform the necessary action and return to the report used to invoke the Subform. There is no limit on the number of Subforms that can be used at the field level.

Syntax

[Field : Field Name]

Sub Form : <Report Name> : <Condition>

Where,

< Report Name > is the name of the Report to be displayed.

< Condition > could be any expression, which evaluates to a logical value. The report will be displayed only when the condition is True.

A Subform is not associated to the Object at the Report level. An Object associated to the Field in which the Sub Form is defined, gets associated to the Sub Form. A Sub Form will inherit the info object from the Field which appears as a pop-up.

The Bill-wise Details is an example of a Subform attribute. This screen is displayed as soon as an amount is entered for a ledger whose Bill-wise Details feature has been activated.

Example

The following code snippet uses a Subform to enter the details of bills when the Bill Collection ledger is selected, while entering a Voucher. The values entered in the Subform are stored in an Aggregate UDF. This UDF is attached to the object to which the field displaying the Subform is associated. Here, it is the Object of a Ledger Entries Collection.

The following code is used to associate a Subform to the default Field in a voucher.

[#Field : ACLSLed]

Sub Form : BillDetail : ##SVVoucherType = "Receipt" and $LedgerName = "Bill Collection"

The Name Report for the Subform uses an Aggregate UDF to store the data. A Line is repeated over the Aggregate UDF at the Part level.

[Part : BillDetails]

Scroll      : vertical

Line        : BillDetailsH, BillDetailsD

Repeat      : BillDetailsD : BAggre

Break After : $$Line=2

The attribute Storage is used for all the fields.

[Field: CustName1]

Use     : Name Field

Storage : CustName

The UDF is defined as follows:

[System : UDF]

CustName : String : 1000

BillNo   : String : 1001

BillAmt  : Amount : 1001

EPrint1  : String : 1002

BAggre   : Aggregate : 1000

Learning Outcome

UDFs are stored in the context of the current Object. They can be of any Tally data type.

UDFs should be defined under the section [ System: UDF ].

The attribute ‘Storage’ in a Field definition is used to store the value entered in a Field.

The value is stored in the context of the current Object.

A Simple UDF can store one or more values of a single data type only.

Aggregate UDFs are very useful for storing multiple values and repeated values