Gets an individual record to process for consolidation. This function can be used in Consolidation rules.
Syntax
HS.DataUnit.GetItem (lItem, strAccount, strICP, strCustom1, strCustom2, strCustom3, strCustom4, dData)
Table 61. 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