{"id":21874,"date":"2026-07-23T10:56:20","date_gmt":"2026-07-23T10:56:20","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=21874"},"modified":"2026-07-23T10:56:23","modified_gmt":"2026-07-23T10:56:23","slug":"how-does-unallocated-invoices-report-works-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-does-unallocated-invoices-report-works-in-idempiere\/","title":{"rendered":"How does Unallocated Invoices Report works in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Unallocated Invoices report provides detailed information about invoices in iDempiere that have not yet been fully allocated to a payment or receipt. It displays each invoice transaction along with its business partner, document type, and location details, helping users identify which invoices remain open.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The report is mainly used by Finance, Accounts Receivable\/Payable, and Management teams to review outstanding invoices, follow up on collections or payments due, and track which invoices still require allocation.<\/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>The report retrieves data from the <strong>RV_C_Invoice<\/strong> report view.<\/li>\n\n\n\n<li>The report combines invoice, document type, business partner, business partner location, and location information into a single report.<\/li>\n\n\n\n<li>Each record represents a single invoice transaction.<\/li>\n\n\n\n<li>Charge amount, total lines, and grand total are automatically sign-adjusted based on the invoice&#8217;s document base type: amounts on credit memos are shown as negative, while other invoice types are shown as positive.<\/li>\n\n\n\n<li>An invoice is considered unallocated when its <strong>IsPaid flag on C_Invoice is set to &#8216;N&#8217;<\/strong>, meaning no payment or receipt has been fully applied to it yet.<\/li>\n\n\n\n<li>Only invoices with no matching record in C_AllocationLine are included \u2014 that is, invoices that have not yet been allocated to any payment or receipt.<\/li>\n\n\n\n<li>Only invoices with a Document Status of <strong>Completed (CO) or Closed (CL)<\/strong> are included in the report results.<\/li>\n\n\n\n<li>The report is read-only and does not create or update invoice data.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Report Parameters<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The Unallocated Invoices parameter window allows users to filter invoice records before generating the report. Users can select Business Partner and Document Type to display only the invoice records that match the selected criteria.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Parameter<\/strong><\/td><td><strong>Purpose<\/strong><\/td><td><strong>Filtering Behavior<\/strong><\/td><td><strong>Sample Data<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Business Partner<\/td><td>Selects the business partner associated with the invoice.<\/td><td>Displays invoice records for the selected business partner.<\/td><td>Alpha Retail Solutions<\/td><\/tr><tr><td>Document Type<\/td><td>Selects the invoice document type.<\/td><td>Displays invoice records for the selected document type.<\/td><td>AR Invoice<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"373\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices.png\" alt=\"\" class=\"wp-image-21883\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices-300x109.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices-768x280.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/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 Unallocated Invoices report displays one row per open invoice. Each row shows the invoice amount signed according to its document base type, along with business partner and document type details.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The report includes the document number, business partner, document type, invoice date, order date, grand total, total lines, charge amount, currency, payment term, paid status, and document status. It helps users track outstanding invoices and follow up on amounts still awaiting allocation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"422\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices1.png\" alt=\"\" class=\"wp-image-21884\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices1-300x124.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices1-768x317.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=\"407\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices2.png\" alt=\"\" class=\"wp-image-21885\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices2.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices2-300x119.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices2-768x305.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=\"407\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices3.png\" alt=\"\" class=\"wp-image-21886\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices3.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices3-300x119.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices3-768x305.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=\"407\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices4-1.png\" alt=\"\" class=\"wp-image-21889\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices4-1.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices4-1-300x119.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-Accounting-UnallocatedInvoices4-1-768x305.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The Unallocated Invoices report provides detailed information about invoices in iDempiere that have not yet been fully allocated to a [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[10,58],"tags":[],"class_list":["post-21874","post","type-post","status-publish","format-standard","hentry","category-product","category-accounting"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21874","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=21874"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21874\/revisions"}],"predecessor-version":[{"id":21890,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/21874\/revisions\/21890"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=21874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=21874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=21874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}