How does Unallocated Invoices Report works in iDempiere

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.

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.

Business Rules

• The report retrieves data from the RV_C_Invoice report view.
• The report combines invoice, document type, business partner, business partner location, and location information into a single report.
• Each record represents a single invoice transaction.
• Charge amount, total lines, and grand total are automatically sign-adjusted based on the invoice’s document base type: amounts on credit memos are shown as negative, while other invoice types are shown as positive.
• An invoice is considered unallocated when its IsPaid flag on C_Invoice is set to ‘N’, meaning no payment or receipt has been fully applied to it yet.
• Only invoices with no matching record in C_AllocationLine are included — that is, invoices that have not yet been allocated to any payment or receipt.
• Only invoices with a Document Status of Completed (CO) or Closed (CL) are included in the report results.
• The report is read-only and does not create or update invoice data.

Report Parameters

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.

Parameter	Purpose	Filtering Behavior	Sample Data
Business Partner	Selects the business partner associated with the invoice.	Displays invoice records for the selected business partner.	Alpha Retail Solutions
Document Type	Selects the invoice document type.	Displays invoice records for the selected document type.	AR Invoice

Report Output

• 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.

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.