{"id":21811,"date":"2026-08-04T12:03:50","date_gmt":"2026-08-04T12:03:50","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21811"},"modified":"2026-08-17T08:24:18","modified_gmt":"2026-08-17T08:24:18","slug":"how-does-accounting-fact-daily-report-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-accounting-fact-daily-report-works-in-idempiere\/","title":{"rendered":"How Does Accounting Fact Daily Report Works in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Accounting Fact Daily Report provides a daily summary of accounting transactions recorded in the iDempiere system. It summarizes debit, credit, and balance amounts based on the Accounting Date and Accounting Schema.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The report helps Finance and Accounting teams review daily postings, monitor ledger activity, and verify accounting transactions. It is commonly used for reconciliation, financial analysis, and audit purposes.<\/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>Retrieves data from the <strong>RV_Fact_Acct_Day<\/strong> view.<\/li>\n\n\n\n<li>Groups accounting transactions by <strong>Accounting Date<\/strong>.<\/li>\n\n\n\n<li>Summarizes data by Account, Organization, and Accounting Schema.<\/li>\n\n\n\n<li>Calculates <strong>Source Debit<\/strong>, <strong>Source Credit<\/strong>, and Source Balance.<\/li>\n\n\n\n<li>Calculates <strong>Accounting Debit<\/strong>, <strong>Accounting Credit<\/strong>, and Accounting Balance.<\/li>\n\n\n\n<li>Calculates accounting exchange rate.<\/li>\n\n\n\n<li>Supports filtering by Organization, Period, Account, Business Partner, Product, Tax, and Accounting Date.<\/li>\n\n\n\n<li>Returns only records matching the selected parameters.<\/li>\n\n\n\n<li>Displays summarized daily accounting information.<\/li>\n\n\n\n<li>Supports reconciliation and financial reporting.<\/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\"><strong>Parameter Window<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The Accounting Fact Daily Report parameter window allows users to filter Business<strong> <\/strong>Partner records before generating the report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Accounting Fact Daily 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=\"746\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-1.png\" alt=\"TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-1\" class=\"wp-image-21813\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-1-300x219.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-1-768x560.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>Accounting Schema<\/td><td>Choose Accounting Schema<\/td><td colspan=\"2\">Filters by Accounting Schema.<\/td><td>POTS UN\/38 Indian Rupee<\/td><\/tr><tr><td>Organization<\/td><td>Choose Organization<\/td><td colspan=\"2\">Filters by Organization.<\/td><td>HQ<\/td><\/tr><tr><td>From Account Date<\/td><td>Choose From Accounting Date<\/td><td>Filters from selected date.<\/td><td colspan=\"2\">07\/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\">07\/31\/2026<\/td><\/tr><tr><td>Period<\/td><td>Choose Period<\/td><td>Filters by accounting period.<\/td><td colspan=\"2\">Jul-2026<\/td><\/tr><tr><td>Account<\/td><td>Choose Account<\/td><td>Filters by account.<\/td><td colspan=\"2\">Sales Revenue<\/td><\/tr><tr><td>Business Partner<\/td><td>Choose Business Partner<\/td><td>Filters by Business Partner.<\/td><td colspan=\"2\">ABC Traders<\/td><\/tr><tr><td>Product<\/td><td>Choose Product<\/td><td>Filters by Product.<\/td><td colspan=\"2\">Laptop<\/td><\/tr><tr><td>Tax<\/td><td>Choose Tax<\/td><td>Filters by Tax.<\/td><td colspan=\"2\">GST 18%<\/td><\/tr><tr><td>Run as Job<\/td><td>Run in background<\/td><td>Runs as background job.<\/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 provides a daily summary of accounting entries for the selected criteria. It displays debit and credit amounts in source and accounting currencies together with calculated balances. Users can analyze transactions by account, organization, business partner, product, and tax. The report supports General Ledger verification, reconciliation, and financial analysis.<\/li>\n\n\n\n<li>Accounting Date<\/li>\n\n\n\n<li>Accounting Schema<\/li>\n\n\n\n<li>Organization<\/li>\n\n\n\n<li>General Ledger Account<\/li>\n\n\n\n<li>Source Debit\/Credit<\/li>\n\n\n\n<li>Accounting Debit\/Credit<\/li>\n\n\n\n<li>Accounting Balance<\/li>\n\n\n\n<li>Business Partner, Product and Tax<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"746\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-2.png\" alt=\"TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-2\" class=\"wp-image-21814\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-2.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-2-300x219.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-2-768x560.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"746\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-3.png\" alt=\"TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-3\" class=\"wp-image-21815\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-3.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-3-300x219.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-AccountingManagement-AccountingFactDaily-3-768x560.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The Accounting Fact Daily Report provides a daily summary of accounting transactions recorded in the iDempiere system. It summarizes debit, [&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-21811","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\/21811","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=21811"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21811\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}