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) nullable | Balance is running sum of (Opening + Debit - Credit) calculated for each row of group. |
| BalanceBase | decimal (38, 2) nullable | Calculated as Balance over Base currency. |
| BalanceReporting | decimal (38, 2) nullable | Calculated as Balance over Reporting currency. |
| Closing | decimal (38, 2) nullable | Closing Balance(at the end of reporting period) |
| ClosingBase | decimal (38, 2) nullable | Closing Balance(in Base currency) |
| ClosingReporting | decimal (38, 2) nullable | Closing Balance(in Reporting currency) |
| Credit | decimal (18, 2) | CreditRequired |
| CreditBase | decimal (18, 2) | Credit BaseRequired |
| CreditReporting | decimal (18, 2) nullable | Credit Reporting |
| Debit | decimal (18, 2) | DebitRequired |
| DebitBase | decimal (18, 2) | Debit BaseRequired |
| DebitReporting | decimal (18, 2) nullable | Debit Reporting |
| DocumentDate | date nullable | Document DateFilter(ge;le) |
| FromDate | date nullable | Period Start Date - Should be filtered with exact dateFilter(eq) |
| ItemKey | string (64) nullable | Item Key |
| MovementType | string (7) | Movement TypeRequired Filter(multi eq) |
| Opening | decimal (38, 2) nullable | Opening balance (debit balance is positive, credit - negative) |
| OpeningBase | decimal (38, 2) nullable | Opening balance in base currency (debit balance is positive, credit - negative) |
| OpeningReporting | decimal (38, 2) nullable | Opening balance in reporting currency |
| ReleaseTime | datetime nullable | Document Release TimeFilter(ge;le) |
| ToDate | date nullable | Period End Date - Should be filtered with exact dateFilter(eq) |
References
| Name | Type | Description |
|---|---|---|
| Account | Accounts | General Ledger Account |
| CostCenter | CostCenters (nullable) | Cost Center |
| Currency | Currencies | Currency |
| EnterpriseCompany | EnterpriseCompanies | Enterprise Company |
| ProfitCenter | ProfitCenters (nullable) | Profit Center |
| VoucherLine | AccountingVoucherLines (nullable) | Voucher Line reference |
Attribute Details
Balance
Balance is running sum of (Opening + Debit - Credit) calculated for each row of group.
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceBase
Calculated as Balance over Base currency.
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
BalanceReporting
Calculated as Balance over Reporting currency.
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
Closing
Closing Balance(at the end of reporting period)
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ClosingBase
Closing Balance(in Base currency)
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ClosingReporting
Closing Balance(in Reporting currency)
Type: decimal (38, 2) nullable
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 Reporting
Type: decimal (18, 2) nullable
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 Reporting
Type: decimal (18, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DocumentDate
Document DateFilter(ge;le)
Type: date nullable
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
FromDate
Period Start Date - Should be filtered with exact dateFilter(eq)
Type: date nullable
Category: System
Supported Filters: Equals
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
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)
Type: decimal (38, 2) nullable
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)
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
OpeningReporting
Opening balance in reporting currency
Type: decimal (38, 2) nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ReleaseTime
Document Release TimeFilter(ge;le)
Type: datetime nullable
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
ToDate
Period End Date - Should be filtered with exact dateFilter(eq)
Type: date nullable
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 (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
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
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
VoucherLine
Voucher Line reference
Type: AccountingVoucherLines (nullable)
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