说说hfm里的抵消逻辑

最新推荐文章于 2026-06-24 14:34:24 发布

原创最新推荐文章于 2026-06-24 14:34:24 发布 · 1k 阅读

6 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

标签

#大数据

系统和实际的财务有差别，在合并报表里，合并报表会计的合并分录怎么写呢

例如母公司长期股权投资和子公司所有者权益的抵消分录：

借：实收资本

资本公积

盈余公积

未分配利润

贷：长期股权投资

少数股东权益

HFM系统是通过hs.con函数实现的,示例代码为

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 11-12 Syntax for Con Function

Parameter	Description
DestPOV	Combination of these elements: Account Custom1, Custom2, Custom3, Custom4 Intercompany Entity Value
Factor	A number or an expression using mathematical operators (+ - * /) or functions such as 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 transaction information from data grid Source or Destination Transaction options, or from the Entity Detail report. You can also use the Nature string information to generate journal reports for consolidation and elimination entries. If you want to see tis data in a journal report, this parameter is required. Journals for Proportion and Elimination entries are reported from RTS/RTD tables. Depending on your requirements, it may be appropriate to create the journal data for [Elimination] HS.Con entries, but not for [Proportion] HS.Con entries to reduce the volume of RTS/RTD table entries. Using the Nature parameter, which generates RTS/RTD table entries, increases the size of the database and may impact consolidation performance.

Parameter

Description

DestPOV

Combination of these elements:

Account
Custom1, Custom2, Custom3, Custom4
Intercompany
Entity
Value

Factor

A number or an expression using mathematical operators (+ - * /) or functions such as 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 transaction information from data grid Source or Destination Transaction options, or from the Entity Detail report.

You can also use the Nature string information to generate journal reports for consolidation and elimination entries. If you want to see tis data in a journal report, this parameter is required. Journals for Proportion and Elimination entries are reported from RTS/RTD tables. Depending on your requirements, it may be appropriate to create the journal data for [Elimination] HS.Con entries, but not for [Proportion] HS.Con entries to reduce the volume of RTS/RTD table entries.

Using the Nature parameter, which generates RTS/RTD table entries, increases the size of the database and may impact consolidation performance.

Return Value

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