banner banner Skip to main content

Posts

Showing posts from October, 2014

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. Example : - ;;;;; Aggregate UDF example [#Menu: Gateway of Tally] Add :Key Item : Aggregate UDF example : A : Alter : Aggregate UDF example [Report : Aggregate UDF example] Obje...

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 ;;;;;;;;;;;;;;; Add the udf in the ledger master Form [#Part: LED Mailing Address] Add : Line : After : LED Mailing Address : SimpleUDFexample [Line : SimpleUDFexample] Field : Long Prompt,SimpleUDFexample Local : Field : Long Prompt : Set as : "Example of simple UDF" Local : Field : default : Color : Blue [Field : SimpleUDFexample] Use : Name Field Storage : SimpleUDFexample [System : UDF] SimpleUDFexample : String : 999

User Defined Fields

In Tally.ERP 9, the structure of an object, the data type and storages required in order to store the data are all pre-defined by the platform. All the data is stored in the Tally database. By default, data is always stored in pre-defined 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. 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 co...