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
API access: ReadWrite
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. 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. 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. 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 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