Finance.Accounting.HistoricalBalances (View)
Account balances with analytical dimensions as of the selected historical date. Used for reviewing past financial positions based on posted transactions up to that point.
General
Namespace: Finance.Accounting
Repository: Finance.Accounting.HistoricalBalances
Introduced In Version: 25.1.2.93
API access: ReadWrite
Visualization
Display Format: {BalanceValue}: {BalanceBaseValue}
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 | Amount (19, 2) | Account balance in the reporting currency as of the selected date.Currency: EnterpriseCompany.ReportingCurrency 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. |
| CostCenter | CostCenters | The cost center associated with the account balance for analytical and reporting purposes. |
| Currency | Currencies | Currency in which the account balance is shown. Required field. |
| EnterpriseCompany | EnterpriseCompanies | The enterprise company whose accounts are being analyzed. Required for filtering accounting data. |
| ProfitCenter | ProfitCenters | The profit center associated with the account balance for profit analysis and segment reporting. |
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.Currency: EnterpriseCompany.ReportingCurrency Required
Type: Amount (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.
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.
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.
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.
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.
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 Entity Set: Finance_Accounting_HistoricalBalances
Domain API Entity Type: Finance_Accounting_HistoricalBalancesEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Finance_Accounting_HistoricalBalances?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Finance_Accounting_HistoricalBalances?$top=10