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}: {EnterpriseCompanyLocationId}
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) | Net current balance (Debit - Credit)Required |
| BalanceBase | decimal (38, 2) | Current balance in base currencyRequired |
| BalanceReporting | decimal (38, 2) | Current balance in reporting currencyRequired |
| ItemKey | string (64) | Item KeyRequired |
References
| Name | Type | Description |
|---|---|---|
| Account | Accounts | Account reference |
| CostCenter | CostCenters | Cost Center |
| Currency | Currencies | Currency |
| EnterpriseCompany | EnterpriseCompanies | Legal entity |
| EnterpriseCompanyLocation | CompanyLocations | Optional location/branch filter |
| ProfitCenter | ProfitCenters | Profit Center |
Attribute Details
Balance
Net current balance (Debit - Credit)Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceBase
Current balance in base currencyRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceReporting
Current balance in reporting currencyRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ItemKey
Item KeyRequired
Type: string (64)
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
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
EnterpriseCompanyLocation
Optional location/branch filter
Type: CompanyLocations
Category: System
Inherited From: Cm_Company_Locations_Table.Company_Location_Id
Supported Filters: Equals, EqualsIn
Filterable Reference: True
Default Value: NewGuid
Show in UI: ShownByDefault
ProfitCenter
Profit Center
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_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