GetItem

Gets an individual record to process for consolidation. This function can be used in Consolidation rules.

Note:

This function can only be used for 4 or fewer Custom dimensions. For more than four Custom dimensions, use DataUnitItem.

Syntax

DataUnit.GetItem (lItem, strAccount, strICP, strCustom1, strCustom2, strCustom3, strCustom4, dData)
         

Table 11-25 Syntax for GetItem Function

Parameter	Description
lItem	A record number.
strAccount	Name of a valid Account dimension member.
strICP	Name of a valid ICP dimension member.
strCustom1	Name of a valid Custom1 dimension member.
strCustom2	Name of a valid Custom2 dimension member.
strCustom3	Name of a valid Custom3 dimension member.
strCustom4	Name of a valid Custom4 dimension member.
dData	The data in the specified cell.

Return Value

An array containing the account, ICP, Custom1...4, data.

Example

Call DataUnit.GetItem(lItem, strAccount, strICP, strCustom1, strCustom2, strCustom3, strCustom4, dData)

If dData = 0 Then

  ...

End If