InsertLineItemDetails

Inserts line item descriptions in the cells that intersect the specified dimension members.

Syntax

<HsvData>.InsertLineItemDetails lScenario, lYear, lEntity, lAccount, lICP, lCustom1, lCustom2, lCustom3, lCustom4, varabstrDetail, varalInsertPos

Argument

Description

lScenario

Long (ByVal). The member ID of the Scenario dimension member for the intersecting cells.

lYear

Long (ByVal). The member ID of the Year dimension member for the intersecting cells.

lEntity

Long (ByVal). The member ID of the Entity dimension member for the intersecting cells.

lAccount

Long (ByVal). The member ID of the Account dimension member for the intersecting cells.

Tip:

Use HsvAccounts.UsesLineItems to check whether an account supports line items.

lICP

Long (ByVal). Long (ByVal). The member ID of the Intercompany Partner dimension member for the intersecting cells.

lCustom1

Long (ByVal). The member ID of the Custom 1 dimension member for the intersecting cells.

lCustom2

Long (ByVal). The member ID of the Custom 2 dimension member for the intersecting cells.

lCustom3

Long (ByVal). The member ID of the Custom 3 dimension member for the intersecting cells.

lCustom4

Long (ByVal). The member ID of the Custom 4 dimension member for the intersecting cells.

varabstrDetail

String array (ByVal). An array of strings that contain the line item descriptions to be added.

varalInsertPos

Long array (ByVal). An array of Longs that indicate the positions in the intersecting cells in which the line item details are to be added. The line item position identifiers are 0-based, and the array has a one-to-one correspondence with the varabstrDetail argument’s array.

Example

The following example inserts two line item descriptions in the first two positions of the intersecting cells. The example assumes the variables passed to InsertLineItemDetails have been set to the member IDs for the intersecting cells.

Dim saDesc(1) As String, laPos(1) As Long
saDesc(0) = "Chairs"
saDesc(1) = "Desks"
laPos(0) = 0
laPos(1) = 1
m_cHsvData.InsertLineItemDetails lScen, lYr, lEnt, lAcct, _ 
lIcp, lCust1, lCust2, lCust3, lCust4, saDesc, laPos