Finance.Accounting.CurrentBalances (View)
Contains live account balances calculated from all released accounting vouchers in the system. Reflects the up-to-date financial position, including transactions with future dates.
General
Namespace: Finance.Accounting
Repository: Finance.Accounting.CurrentBalances
Introduced In Version: 25.1.3.29
API access: ReadWrite
Visualization
Display Format: {EnterpriseCompanyId}: {ItemKey}
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 | decimal (38, 2) nullable | Net current balance (Debit - Credit) |
| BalanceBase | decimal (38, 2) nullable | Current balance in base currency |
| BalanceReporting | decimal (38, 2) nullable | Current balance in reporting currency |
| ItemKey | string (64) nullable | Item Key |
References
| Name | Type | Description |
|---|---|---|
| Account | Accounts | Account reference |
| CostCenter | CostCenters (nullable) | Cost Center |
| Currency | Currencies | Currency |
| EnterpriseCompany | EnterpriseCompanies | Legal entity |
| ProfitCenter | ProfitCenters (nullable) | Profit Center |
Attribute Details
Balance
Net current balance (Debit - Credit)
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceBase
Current balance in base currency
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceReporting
Current balance in reporting currency
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ItemKey
Item Key
Type: string (64) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 64
Show in UI: ShownByDefault
Reference Details
Account
Account reference
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
Cost Center
Type: CostCenters (nullable)
Category: System
Inherited From: Acc_Cost_Centers_Table.Cost_Center_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
Currency
Currency
Type: Currencies
Category: System
Inherited From: Gen_Currencies_Table.Currency_Id
Supported Filters: Equals, EqualsIn
Default Value: NewGuid
Show in UI: ShownByDefault
EnterpriseCompany
Legal entity
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
Profit Center
Type: ProfitCenters (nullable)
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_CurrentBalances
Domain API Entity Type: Finance_Accounting_CurrentBalancesEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Finance_Accounting_CurrentBalances?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Finance_Accounting_CurrentBalances?$top=10