{"id":21845,"date":"2026-08-04T12:03:44","date_gmt":"2026-08-04T12:03:44","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21845"},"modified":"2026-08-17T09:32:13","modified_gmt":"2026-08-17T09:32:13","slug":"how-does-unreconciled-accounting-facts-report-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-unreconciled-accounting-facts-report-works-in-idempiere\/","title":{"rendered":"How Does Unreconciled Accounting Facts Report Works in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Unreconciled Accounting Facts Report helps Finance users identify accounting entries that have not yet been reconciled. It displays posted accounting facts pending reconciliation for the selected General Ledger Account and Accounting Date range.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The report supports reconciliation, audit verification, and financial control. It is commonly used during month-end and year-end closing.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Uses the <strong>T_RV_Reconciliation<\/strong> view.<\/li>\n\n\n\n<li>Reads accounting entries from <strong>RV_Fact_Acct<\/strong>.<\/li>\n\n\n\n<li>Joins reconciliation records using <strong>Fact_Acct_ID<\/strong>.<\/li>\n\n\n\n<li>Displays unreconciled accounting facts.<\/li>\n\n\n\n<li>Supports filtering by Account.<\/li>\n\n\n\n<li>Supports filtering by Accounting Date range.<\/li>\n\n\n\n<li>Returns only matching records.<\/li>\n\n\n\n<li>Displays accounting dimensions.<\/li>\n\n\n\n<li>Helps reconciliation activities.<\/li>\n\n\n\n<li>Supports audit review.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Report Parameters<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Parameter Window<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Unreconciled Accounting Facts Report parameter window allows users to filter records before generating the report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Unreconciled Accounting Facts Report \u2013 Parameter Window<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"368\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts1.png\" alt=\"TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts-1\" class=\"wp-image-21851\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts1-300x108.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts1-768x276.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Parameter<\/strong><\/td><td><strong>Purpose<\/strong><\/td><td colspan=\"2\"><strong>Filtering Behavior<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Account<\/td><td>Choose Account<\/td><td colspan=\"2\">Filters by account.<\/td><td>Bank Charge_Bank Charge<\/td><\/tr><tr><td>From Account Date<\/td><td>Choose From Accounting Date<\/td><td colspan=\"2\">Filters from selected date.<\/td><td>01\/01\/2026<\/td><\/tr><tr><td>To Account Date<\/td><td>Choose To Accounting Date<\/td><td>Filters up to selected date.<\/td><td colspan=\"2\">22\/07\/2026<\/td><\/tr><tr><td>Run as Job<\/td><td>Run in background<\/td><td>Runs report in background.<\/td><td colspan=\"2\">Checked<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Report Output<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The report lists unreconciled accounting transactions for the selected account and accounting date range. It helps users identify pending reconciliation items and verify accounting balances for financial reporting and audit.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"779\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts2.png\" alt=\"TenthPlanet-iDempiere-Unreconciled Accounting Facts Report-2\" class=\"wp-image-21852\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts2.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts2-300x228.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-Unreconciled-Accounting-Facts2-768x584.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The Unreconciled Accounting Facts Report helps Finance users identify accounting entries that have not yet been reconciled. It displays posted [&hellip;]<\/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-21845","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\/21845","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=21845"}],"version-history":[{"count":3,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21845\/revisions"}],"predecessor-version":[{"id":27080,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21845\/revisions\/27080"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}