MatchAutoIDs

Matches intercompany transactions by Transaction ID or Reference ID.

Syntax

<HsvICM>.MatchAutoIDs lScenario, lYear, lPeriod, varalEntities, varalICPs, lMatchOption, bstrMatchCurr, bstrMatchIDs

Argument

Description

lScenario

Long (ByVal). The member ID of the Scenario dimension member for which to match intercompany transactions.

lYear

Long (ByVal). The member ID of the Year dimension member for which to match intercompany transactions.

lPeriod

Long (ByVal). The member ID of the Period dimension member for which to match intercompany transactions.

varalEntities

Long array (ByVal). The member IDs of the Entity dimension members for which to match intercompany transactions.

varalICPs

Long array (ByVal). The member IDs of the Intercompany Partner dimension members for which to match intercompany transactions.

lMatchOption

Long (ByVal). A flag that specifies the type of ID by which to match. Valid values are represented by the following constants, which are members of the HFMConstants enumeration tagICMMATCHOPTIONSENUM:

  • ICT_MATCH_REFERENCE

  • ICT_MATCH_TRANSACTIONID

For descriptions of these constants, see Match Option Constants.

bstrMatchCurr

String (ByVal). The transaction currency for which to match. To match for all transaction currencies, pass a blank string.

bstrMatchIDs

String (ByVal). A comma-delimited list of the Transaction IDs or the Reference IDs that identify the transactions to match.

You can use the percentage symbol ( % ) as a wildcard character. For example, the following string matches all IDs that begin with either “ref” or “acct”:

"ref%,acct%"

Example

The following example matches all intercompany transactions for the specified dimension members that have reference IDs beginning with either “ref” or “acct”.

Sub matchRefIdsPattern(lScen As Long, lYear As Long, lPer As Long, _
  laEnts() As Long, laICPs() As Long)
Dim cICM As HsvICM
'g_cSession is an HsvSession object reference
Set cICM = g_cSession.ICM
cICM.MatchAutoIDs lScen, lYear, lPer, laEnts, laICPs, _
  ICT_MATCH_REFERENCE, "", "ref%,acct%"
End Sub