Table of Contents

Finance.Accounting.HistoricalBalances View

Namespace: Finance.Accounting

Account balances with analytical dimensions as of the selected date. Entity: Acc_Historical_Balances (Introduced in version 25.1.2.93)

Default Visualization

Default Display Text Format:
{BalanceValue}: {BalanceBaseValue}
Default Search Members:
__
Category: Views
Show in UI: ShownByDefault

Aggregate

An aggregate is a cluster of domain objects that can be treated as a single unit.

Aggregate Tree

Attributes

Name Type Description
Balance Amount (19, 2) Account balance in the original accounting currency as of the selected date. Currency: Currency Required
BalanceBase Amount (19, 2) Account balance in the company’s base currency as of the selected date. Currency: EnterpriseCompany.BaseCurrency Required
BalanceReporting decimal (19, 2) Account balance in the reporting currency as of the selected date. Required
Date date The report shows balances as of this date. This is a required filter; if not set, the view returns no data. Required Filter(eq)
ItemKey string (64) Combined analytical dimensions key used for grouping and filtering account balances. Required Filter(eq;like)

References

Name Type Description
Account Accounts The general ledger account for which the balance is calculated. Required field. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Accounts_Table.Account_Id FilterableReference
CostCenter CostCenters The cost center associated with the account balance for analytical and reporting purposes. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Cost_Centers_Table.Cost_Center_Id
Currency Currencies Currency in which the account balance is shown. Required field. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Currencies_Table.Currency_Id FilterableReference
EnterpriseCompany EnterpriseCompanies The enterprise company whose accounts are being analyzed. Required for filtering accounting data. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Enterprise_<br />Companies_Table.Enterprise_Company_Id FilterableReference
ProfitCenter ProfitCenters The profit center associated with the account balance for profit analysis and segment reporting. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Profit_Centers_Table.Profit_Center_Id

Attribute Details

Balance

Account balance in the original accounting currency as of the selected date. Currency: Currency Required

Type: Amount (19, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

BalanceBase

Account balance in the company’s base currency as of the selected date. Currency: EnterpriseCompany.BaseCurrency Required

Type: Amount (19, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

BalanceReporting

Account balance in the reporting currency as of the selected date. Required

Type: decimal (19, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault

Date

The report shows balances as of this date. This is a required filter; if not set, the view returns no data. Required Filter(eq)

Type: date
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault

ItemKey

Combined analytical dimensions key used for grouping and filtering account balances. Required Filter(eq;like)

Type: string (64)
Category: System
Supported Filters: Equals, Like
Supports Order By: False
Maximum Length: 64
Show in UI: ShownByDefault

Reference Details

Account

The general ledger account for which the balance is calculated. Required field. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Accounts_Table.Account_Id FilterableReference

Type: Accounts
Category: System
Inherited From: Acc_Accounts_Table.Account_Id
Supported Filters: Equals, EqualsIn
Filterable Reference: True
Default Value: NewGuid
Show in UI: ShownByDefault

CostCenter

The cost center associated with the account balance for analytical and reporting purposes. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Cost_Centers_Table.Cost_Center_Id

Type: CostCenters
Category: System
Inherited From: Acc_Cost_Centers_Table.Cost_Center_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

Currency

Currency in which the account balance is shown. Required field. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Currencies_Table.Currency_Id FilterableReference

Type: Currencies
Category: System
Inherited From: Gen_Currencies_Table.Currency_Id
Supported Filters: Equals, EqualsIn
Filterable Reference: True
Default Value: NewGuid
Show in UI: ShownByDefault

EnterpriseCompany

The enterprise company whose accounts are being analyzed. Required for filtering accounting data. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Enterprise_Companies_Table.Enterprise_Company_Id FilterableReference

Type: EnterpriseCompanies
Category: System
Inherited From: Gen_Enterprise_Companies_Table.Enterprise_Company_Id
Supported Filters: Equals, EqualsIn
Filterable Reference: True
Default Value: NewGuid
Show in UI: ShownByDefault

ProfitCenter

The profit center associated with the account balance for profit analysis and segment reporting. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Profit_Centers_Table.Profit_Center_Id

Type: ProfitCenters
Category: System
Inherited From: Acc_Profit_Centers_Table.Profit_Center_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault

API

Domain API Query: https://demodb.my.erp.net/api/domain/odata/Finance_Accounting_HistoricalBalances?$top=10

Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Finance_Accounting_HistoricalBalances?$top=10