Finance.Accounting.AccountStatement View
Namespace: Finance.Accounting
Provides a chronological breakdown of all accounting transactions for each general ledger account within a specified date range. For each account, the report shows the opening, total debits and credits, and the closing balance, followed by a detailed list of all associated accounting vouchers. From Date and To Date must be filtered using exact dates to define the reporting window precisely. Entity: Acc_Account_Statement (Introduced in version 25.1.3.31)
Default Visualization
Default Display Text Format:
{FromDate}: {ToDate}
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) | Balance is running sum of (Opening + Debit - Credit) calculated for each row of group. Required |
| BalanceBase | decimal (38, 2) | Calculated as Balance over Base currency. Required |
| BalanceReporting | decimal (38, 2) | Calculated as Balance over Reporting currency. Required |
| Closing | decimal (38, 2) | Closing Balance(at the end of reporting period). Required |
| ClosingBase | decimal (38, 2) | Closing Balance(in Base currency). Required |
| ClosingReporting | decimal (38, 2) | Closing Balance(in Reporting currency). Required |
| Credit | decimal (18, 2) | Credit. Required |
| CreditBase | decimal (18, 2) | Credit Base. Required |
| CreditReporting | decimal (18, 2) | Credit Reporting. Required |
| Debit | decimal (18, 2) | Debit. Required |
| DebitBase | decimal (18, 2) | Debit Base. Required |
| DebitReporting | decimal (18, 2) | Debit Reporting. Required |
| DocumentDate | date | Document Date. Required Filter(ge;le) |
| FromDate | date | Period Start Date - Should be filtered with exact date. Required Filter(eq) |
| ItemKey | string (64) | Item Key. Required |
| MovementType | string (7) | Movement Type. Required Filter(multi eq) |
| Opening | decimal (38, 2) | Opening balance (debit balance is positive, credit - negative). Required |
| OpeningBase | decimal (38, 2) | Opening balance in base currency (debit balance is positive, credit - negative). Required |
| OpeningReporting | decimal (38, 2) | Opening balance in reporting currency. Required |
| ReleaseTime | datetime | Document Release Time. Required Filter(ge;le) |
| ToDate | date | Period End Date - Should be filtered with exact date. Required Filter(eq) |
References
| Name | Type | Description |
|---|---|---|
| Account | Accounts | General Ledger Account. 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 | Enterprise Company. Required Default(New Guid) Filter(multi eq) Inherited from Gen_Enterprise_<br />Companies_Table.Enterprise_Company_Id FilterableReference |
| EnterpriseCompanyLocation | CompanyLocations | Company Location / Branch. 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 |
| VoucherLine | AccountingVoucherLines | Voucher Line reference. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Voucher_Lines_Table.Voucher_Line_Id |
Attribute Details
Balance
Balance is running sum of (Opening + Debit - Credit) calculated for each row of group. Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceBase
Calculated as Balance over Base currency. Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceReporting
Calculated as Balance over Reporting currency. Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Closing
Closing Balance(at the end of reporting period). Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ClosingBase
Closing Balance(in Base currency). Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ClosingReporting
Closing Balance(in Reporting currency). Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Credit
Credit. Required
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
CreditBase
Credit Base. Required
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
CreditReporting
Credit Reporting. Required
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Debit
Debit. Required
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DebitBase
Debit Base. Required
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DebitReporting
Debit Reporting. Required
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DocumentDate
Document Date. Required Filter(ge;le)
Type: date
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
FromDate
Period Start Date - Should be filtered with exact date. Required Filter(eq)
Type: date
Category: System
Supported Filters: Equals
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
MovementType
Movement Type. Required Filter(multi eq)
Type: string (7)
Category: System
Supported Filters: Equals, EqualsIn
Supports Order By: False
Maximum Length: 7
Show in UI: ShownByDefault
Opening
Opening balance (debit balance is positive, credit - negative). Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
OpeningBase
Opening balance in base currency (debit balance is positive, credit - negative). Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
OpeningReporting
Opening balance in reporting currency. Required
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ReleaseTime
Document Release Time. Required Filter(ge;le)
Type: datetime
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
ToDate
Period End Date - Should be filtered with exact date. Required Filter(eq)
Type: date
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
Reference Details
Account
General Ledger Account. 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
Enterprise Company. 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
Company Location / Branch. 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
VoucherLine
Voucher Line reference. Required Default(New Guid) Filter(multi eq) Inherited from Acc_Voucher_Lines_Table.Voucher_Line_Id
Type: AccountingVoucherLines
Category: System
Inherited From: Acc_Voucher_Lines_Table.Voucher_Line_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_AccountStatement?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Finance_Accounting_AccountStatement?$top=10