DeleteLineItemDetails

Deletes line item details for the cells that intersect the specified dimension members. Line item descriptions are used to identify the line items to be deleted.

Syntax

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

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). 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 the line item descriptions to be deleted. For each array item, DeleteLineItemDetails deletes the line item with the matching description.

Note:

If an array item does not match a corresponding line item, the item is ignored and no error occurs.

Example

The following example deletes two line items. The example assumes the variables passed to DeleteLineItemDetails have been set to the member IDs for the intersecting cells.

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