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