Using dimension IDs, gets an individual record to process for consolidation. This function can be used in Consolidation rules.
Syntax
HS.DataUnit.GetItemIDs2(lItem, lAccountID, lICPID, lCustom1ID, lCustom2ID, lCustom3ID, lCustom4ID, dData)
Table 62. Syntax for GetItemIDs2Function
Parameter | Description |
---|
lItem | A record number. |
lAccountID | ID number of a valid Account dimension member. |
lICPID | ID number of a valid ICP dimension member. |
lCustom1ID | ID number of a valid Custom1 dimension member. |
lCustom2ID | ID number of a valid Custom2 dimension member. |
lCustom3ID | ID number of a valid Custom3 dimension member. |
lCustom4ID | ID number 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