banner banner Skip to main content

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]
Object : company
Form : Aggregate UDF example

[Form : Aggregate UDF example]

Use         : Master Accounting Form
NormalColor : @@SV_COSTCATEGORY
Delete : Bottom Buttons
Height : 100% Screen
Width : 20% screen
Part : AggMainPart

[Part : AggMainPart]

Line : AggMainPartTitle,AggMainPartBody
Repeat : AggMainPartBody : Agg_CollectionPartBody
Common Border: Yes
Scroll : Vertical

[Line : AggMainPartTitle]
Use : AggMainPartBody
Local : Field : default : Delete : Storage
Local : Field : default : Type : String
Local : Field : stringDataTypevalue : Info : "String value"
Local : Field : Number Datatypevalue : Info : "Number value"
Border: Bottom Flush Column Titles

[Line :  AggMainPartBody]

Field : stringDataTypevalue,Number Datatypevalue

[Field : stringDataTypevalue]

Use :  Name Field
Set as : $$Value
Storage : stringDataTypevalue

[Field : Number Datatypevalue]

Use : Number Field
Set as : $$Value
Storage : Number Datatypevalue
Border : thin left
   Full Width : Yes

[System : UDF]

Agg_CollectionPartBody : Aggregate : 100
stringDataTypevalue : String : 101
NumberDatatypevalue : Number : 400


Comments

Post a Comment

Popular posts from this blog

Tally ODBC Driver Issue

Based on the Operating System bit (32/64) Tally has given the Exe. However the Micro Soft Excel application should be compatible to O/S and Tally.ERP9. Please note, On 64 Bit OS and 64Bit Tally.ERP9, a 32 Bit Excel application can act as a server with following steps. Please download from the Portal- ‘Microsoft Access Database Engine 2010 Redistributable’.  1. Install AccessDatabaseEngine_x64.exe Installed (steps given below separately.) 2. Excel 32 Bit (Excel 2003) Installed – and acting as server 3. Tally 64 Bit As Client –                      with ODBC Driver [ODBC: "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:Tally.ERP 9 4.5 Build 7Sample Data.xls;"] and  Tally 32 Bit as Client – with ODBC Driver [ODBC : "Driver={Microsoft Excel Driver *.xls)};DBQ=Sample Data.xls"] This will resolve the problem by NOT upgrading MS Office to 64 bit. you can continue using 32 bit application of Excel.
16 comments
Read more

LOG In function

During expression evaluation, intermediated values of the expression can be passed to calculator window and a log file ‘tdlfunc.log’ inside the application directory. This is very much helpful for debugging the expression. By default, logging is enabled inside the function. Syntax LOG : < Expression> Where, is the expression whose value needs to be passed to the calculator window. [Function : GetCurrentUserApprovelAmt] Parameter : PsvCurrentUser : String Variable : ApprovelAMT : Amount Return : Amount  10 : Walk Collection : ApprovelRequredColl  11 : If : $CustVAUser =  ##PsvCurrentUser  12 : Set : ApprovelAMT : $ApprovelAmount  12A : Log : ##ApprovelAMT  13 : End If  14 : End Walk  15 : Return : ##ApprovelAMT
Post a Comment
Read more

Differences between Applications and DLLs

Differences between Applications and DLLs Even though DLLs and applications are both executable program modules, they differ in several ways. To the end user, the most obvious difference is that DLLs are not programs that can be directly executed. From the system's point of view, there are two fundamental differences between applications and DLLs: An application can have multiple instances of itself running in the system simultaneously, whereas a DLL can have only one instance. An application can own things such as a Stack, Global memory, File handles, and a message queue, but a DLL cannot.
Read more