GetItemIDs2
Using dimension IDs, 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 GetItemIDs2ExtDim.
Syntax
DataUnit.GetItemIDs2(lItem, lAccountID, lICPID, lCustom1ID, lCustom2ID, lCustom3ID, lCustom4ID, dData)
Table 11-26 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
Variables containing the account, ICP, Custom1...4, data.
Example
Call DataUnit.GetItemIDs2(lItem, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, dData)
If dData = 0 Then
...
End If