GetItem

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

Call DataUnit.GetItem(lItem, strAccount, strICP, strCustom1, strCustom2, strCustom3, strCustom4, dData)
If dData = 0 Then
  ...
End If