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