- \n
- Retrieves report parameters from the Statement of Accounts process.<\/li>\n\n\n\n
- Accounting Schema and Posting Type are mandatory.<\/li>\n\n\n\n
- Uses the selected Period or Account Date range.<\/li>\n\n\n\n
- Calculates Beginning Balance before the reporting period.<\/li>\n\n\n\n
- Creates detailed accounting transaction lines.<\/li>\n\n\n\n
- Supports filtering by Organization, Account, Business Partner, Product, Activity, Sales Region, Reporting Hierarchy and Tax.<\/li>\n\n\n\n
- Processes only matching accounting entries.<\/li>\n\n\n\n
- Stores data in T_Report Statement.<\/li>\n\n\n\n
- Applies the Statement of Accounts print format.<\/li>\n\n\n\n
- Supports reconciliation and audit.<\/li>\n<\/ul>\n\n\n\n
Report Parameters<\/strong><\/h2>\n\n\n\n
Parameter Window<\/strong><\/h3>\n\n\n\n
The Statement of Accounts Report parameter window allows users to filter records before generating the report.<\/p>\n\n\n\n
![\"TenthPlanet-iDempiere-AccountingManagement-Statement-of-Accounts-1\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Statement-of-Accounts-1.png\" "\\"\\"")
<\/figure>\n\n\n\nStatement of Accounts Report \u2013 Parameter Window<\/strong><\/p>\n\n\n\n
Parameter<\/strong><\/td> Purpose<\/strong><\/td> Filtering Behavior<\/strong><\/td> Sample Value<\/strong><\/td><\/tr><\/thead> Accounting Schema<\/td> Choose Accounting Schema<\/td> Filters by Accounting Schema.<\/td> POTS UN\/38 Indian Rupee<\/td><\/tr> Posting Type<\/td> Choose Posting Type<\/td> Filters by Posting Type.<\/td> Actual<\/td><\/tr> Period<\/td> Choose Period<\/td> Filters by Period.<\/td> Jul-26<\/td><\/tr> From Account Date<\/td> Choose From Account Date<\/td> Filters from selected date.<\/td> 06\/01\/2026<\/td><\/tr> To Account Date<\/td> Choose To Account Date<\/td> Filters to selected date.<\/td> 06\/30\/2026<\/td><\/tr> Account<\/td> Choose Account<\/td> Filters by GL Account.<\/td> Bank Charge_Bank Charge<\/td><\/tr> Business Partner<\/td> Choose Business Partner<\/td> Filters by Business Partner.<\/td> INDIAN BANK<\/td><\/tr> Product<\/td> Choose Product<\/td> Filters by Product.<\/td> 100000_Men’s shoe<\/td><\/tr> Activity<\/td> Choose Activity<\/td> Filters by Activity.<\/td> Standard<\/td><\/tr> Sales Region<\/td> Choose Sales Region<\/td> Filters by Sales Region.<\/td> Standard<\/td><\/tr> Reporting Hierarchy<\/td> Choose Reporting Hierarchy<\/td> Filters by Hierarchy.<\/td> RA Document<\/td><\/tr> Tax<\/td> Choose Tax<\/td> Filters by Tax.<\/td> CGST\/SGST 18%<\/td><\/tr> Run as Job<\/td> Run in background<\/td> Runs report in background.<\/td> Checked<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n The report is executed using the selected parameter values to retrieve matching records.<\/p>\n\n\n\n
Report Output<\/strong><\/h2>\n\n\n\n
The report displays the beginning balance followed by all accounting transactions recorded during the selected period. It shows debit, credit, balance, quantity, and transaction details, helping users review account movements, reconcile balances, and support financial reporting.<\/p>\n\n\n\n
![\"TenthPlanet-iDempiere-AccountingManagement-Statement-of-Accounts-2\"](\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Statement-of-Accounts-2.png\" "\\"\\"")
<\/figure>\n","protected":false},"excerpt":{"rendered":"The Statement of Accounts Report provides a detailed view of accounting transactions for a selected account and accounting period. It […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-21825","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-accounting"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=21825"}],"version-history":[{"count":4,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21825\/revisions"}],"predecessor-version":[{"id":27096,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21825\/revisions\/27096"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}