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 58. 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