Con

Puts data into the [Proportion] and [Elimination] Value dimension members. This function can be used in Consolidation rules.

Syntax

HS.Con ("DestPOV", Factor, "Nature")

Table 48. Syntax For Con Function  

Parameter

Description

DestPOV

Combination of these dimensions:

  • Account

  • Custom1, Custom2, Custom3, Custom4

  • Intercompany

  • Entity

  • Value

Factor

A number or an expression using mathematical operators (+ - * /) or functions like HS.GetCell.

Nature

A string used for audit purposes. This string is stored in the database and provides information about the accounting purpose of the transaction.

To allow users to view consolidation source and destination transactions after running a consolidation, you must include text in this parameter. If you do not include text, the transaction information is not stored. You can view audit transaction information from the Source or Destination Transaction options in data grids, the Entity Detail report, or automated consolidation journals.

Return Value

None.

Examples

Call HS.Con ("V#[Elimination]",-1*dPCon,"")
Call HS.Con ("V#[Elimination]",-1*dPCon,"Elimination")
Call HS.Con ("V#[Elimination]"PCON,"DefaultConsolidation")