Finance.Accounting.AccountStatement (View)
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.
General
Namespace: Finance.Accounting
Repository: Finance.Accounting.AccountStatement
Introduced In Version: 25.1.3.31
API access: ReadWrite
Visualization
Display Format: {FromDate}: {ToDate}
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) | CreditRequired |
| CreditBase | decimal (18, 2) | Credit BaseRequired |
| CreditReporting | decimal (18, 2) | Credit ReportingRequired |
| Debit | decimal (18, 2) | DebitRequired |
| DebitBase | decimal (18, 2) | Debit BaseRequired |
| DebitReporting | decimal (18, 2) | Debit ReportingRequired |
| DocumentDate | date | Document DateRequired Filter(ge;le) |
| FromDate | date | Period Start Date - Should be filtered with exact dateRequired Filter(eq) |
| ItemKey | string (64) | Item KeyRequired |
| MovementType | string (7) | Movement TypeRequired 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 currencyRequired |
| ReleaseTime | datetime | Document Release TimeRequired Filter(ge;le) |
| ToDate | date | Period End Date - Should be filtered with exact dateRequired Filter(eq) |
References
| Name | Type | Description |
|---|---|---|
| Account | Accounts | General Ledger Account |
| CostCenter | CostCenters | Cost Center |
| Currency | Currencies | Currency |
| EnterpriseCompany | EnterpriseCompanies | Enterprise Company |
| EnterpriseCompanyLocation | CompanyLocations | Company Location / Branch |
| ProfitCenter | ProfitCenters | Profit Center |
| VoucherLine | AccountingVoucherLines | Voucher Line reference |
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
CreditRequired
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
CreditBase
Credit BaseRequired
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
CreditReporting
Credit ReportingRequired
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Debit
DebitRequired
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DebitBase
Debit BaseRequired
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DebitReporting
Debit ReportingRequired
Type: decimal (18, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DocumentDate
Document DateRequired 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 dateRequired Filter(eq)
Type: date
Category: System
Supported Filters: Equals
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
MovementType
Movement TypeRequired 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 currencyRequired
Type: decimal (38, 2)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ReleaseTime
Document Release TimeRequired 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 dateRequired Filter(eq)
Type: date
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
Reference Details
Account
General Ledger Account
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
Enterprise Company
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
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
VoucherLine
Voucher Line reference
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 Entity Set: Finance_Accounting_AccountStatement
Domain API Entity Type: Finance_Accounting_AccountStatementEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Finance_Accounting_AccountStatement?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Finance_Accounting_AccountStatement?$top=10