Finance.Accounting.CurrentBalances View
Namespace: Finance.Accounting
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. Entity: Acc_Current_Balances (Introduced in version 25.1.3.29)
Default Visualization
Default Display Text Format:
{EnterpriseCompanyId}: {EnterpriseCompanyLocationId}
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 | decimal (38, 2) | Net current balance (Debit - Credit). Required |
| BalanceBase | decimal (38, 2) | Current balance in base currency. Required |
| BalanceReporting | decimal (38, 2) | Current balance in reporting currency. Required |
| ItemKey | string (64) | Item Key. Required |
References
| Name | Type | Description |
|---|---|---|
| Account | Accounts | Account reference. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Accounts_Table.Account_Id FilterableReference |
| CostCenter | CostCenters | Cost Center. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Cost_Centers_Table.Cost_Center_Id |
| Currency | Currencies | Currency. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Currencies_Table.Currency_Id |
| EnterpriseCompany | EnterpriseCompanies | Legal entity . Required Default(New Guid) Filter(multi eq) Inherited from Gen_Enterprise_<br />Companies_Table.Enterprise_Company_Id FilterableReference |
| EnterpriseCompanyLocation | CompanyLocations | Optional location/branch filter. Required Default(New Guid) Filter(multi eq) Inherited from Cm_Company_Locations_Table.Company_Location_Id FilterableReference |
| ProfitCenter | ProfitCenters | Profit Center. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Profit_Centers_Table.Profit_Center_Id |
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 currency. Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceReporting
Current balance in reporting currency. Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ItemKey
Item Key. Required
Type: string (64)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 64
Show in UI: ShownByDefault
Reference Details
Account
Account reference. 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
Cost Center. 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. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Currencies_Table.Currency_Id
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 . 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
EnterpriseCompanyLocation
Optional location/branch filter. Required Default(New Guid) Filter(multi eq) Inherited from Cm_Company_Locations_Table.Company_Location_Id FilterableReference
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. 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_CurrentBalances?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Finance_Accounting_CurrentBalances?$top=10