MatchAutoAccounts

Matches intercompany transactions by account. You can optionally restrict matching to only those transactions that include specified Custom dimension members.

Syntax

<HsvICM>.MatchAutoAccounts lScenario, lYear, lPeriod, varalEntities, varalICPs, varabstrAcctsPOV, varabstrMAcctsPOV, lMatchOption, dMatchTolerance, bstrMatchCurr

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.

varabstrAcctsPOV

String array (ByVal). The strings that specify the Account and Custom dimension members for which to match intercompany transactions. Use the following rules and syntax when defining the array’s strings:

  • You must specify an Account dimension member.

  • You optionally can specify members for any of the Custom dimensions.

  • Dimensions are delimited with periods.

  • Members for each dimension are preceded by the following characters:

    • A# = Account

    • C1# = Custom1

    • C2# = Custom2

    • C3# = Custom3

    • C4# = Custom4

The following example specifies an Account dimension member and a Custom 1 member:

"A#RecltIC.C1#Decreases"

varabstrMAcctsPOV

String array (ByVal). The strings that specify the matching Account and Custom dimension members. Use the same rules and syntax as is described for the varabstrAcctsPOV argument.

lMatchOption

Long (ByVal). This argument is reserved for future use. However, you must pass a valid Long, such as zero (0).

dMatchTolerance

Double (ByVal). The matching tolerance.

bstrMatchCurr

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