GetEntityJournals2

This method supports the Web UI to identify journals via internal ID rather than label. This resolves several issues where Unicode text label-based lookups would fail to return the correct journal due to differences in the way the Windows OS and the DBMS performed upper case conversions of some Unicode text characters.

This method is a duplicate of GetEntityJournals with the exception that GetEntityJournals2 returns an array of journal ID's as well as the labels.

Syntax

<HsvJournalsEx>.GetEntityJournals2 lScenario, lYear, lPeriod, lValue, lEntity, lParent, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, pvaralCreditDebitUnit, pvaradAmount, pvarabstrLabel, pvaralJournalIDs, pvaralICP, pvaralCustom1, pvaralCustom2, pvaralCustom3, pvaralCustom4, pvarabstrGroup
ArgumentDescription

lScenario

Long (ByVal). The member ID of the Point of View’s Scenario dimension member.

lYear

Long (ByVal). The member ID of the Point of View’s Year dimension member.

lPeriod

Long (ByVal). The member ID of the Point of View’s Period dimension member.

lValue

Long (ByVal). The member ID of the Point of View’s Value dimension member.

lEntity

Long (ByVal). The member ID of the Point of View’s Entity dimension member.

lParent

Long (ByVal). The member ID of the parent of the lEntity argument’s Entity dimension member.

lAccount

Long (ByVal). The member ID of the Point of View’s Account dimension member.

lICP

Long (ByVal). The member ID of the Point of View’s Intercompany Partner dimension member.

lCustom1

Long (ByVal). The member ID of the Point of View’s Custom 1 dimension member.

lCustom2

Long (ByVal). The member ID of the Point of View’s Custom 2 dimension member.

lCustom3

Long (ByVal). The member ID of the Point of View’s Custom 3 dimension member.

lCustom4

Long (ByVal). The member ID of the Point of View’s Custom 4 dimension member.

pvaralCreditDebitUnit

Variant array. Indicates whether the journal entries are debits or credits. Valid return values are represented by the HFMConstants type library constants listed in Debit/Credit Constants.

The array is returned as an Long subtype.

pvaradAmount

Variant array. Returns the amounts of the journal entries.

The array is returned as a Double subtype.

pvarabstrLabel

Variant array. Returns the labels of the journal entries.

The array is returned as a String subtype.

pvaralJournalIDs

Variant array. Returns the IDs of the journal entries.

The array is returned as a String subtype. This is an array of integers where each number represents the internal identifier of a journal.

pvaralICP

Variant array. Returns the member IDs of the Intercompany Partner dimension members for the journal entries.

The array is returned as a Long subtype.

pvaralCustom1

Variant array. Returns the member IDs of the Custom 1 dimension members for the journal entries.

The array is returned as a Long subtype.

pvaralCustom2

Variant array. Returns the member IDs of the Custom 2 dimension members for the journal entries.

The array is returned as a Long subtype.

pvaralCustom3

Variant array. Returns the member IDs of the Custom 3 dimension members for the journal entries.

The array is returned as a Long subtype.

pvaralCustom4

Variant array. Returns the member IDs of the Custom 4 dimension members for the journal entries.

The array is returned as a Long subtype.

pvarabstrGroup

Variant array. Returns the labels of the journal groups for the journal entries.

The array is returned as a Long subtype.