What Information Does the Report Show?
The report gives finance staff a practical view of invoices that still require attention. Vendor and invoice identifiers help locate source documents, while dates and remaining amounts help determine what is due and whether an item needs investigation. The precise fields depend on the report definition, filters, and version in use, so users should confirm the available options before relying on a particular layout.
Open invoice details are useful when an accounts payable balance needs to be traced back to its underlying transactions. For example, a general ledger control account may show the total amount owed to suppliers, while the open invoice report identifies the vendor invoices contributing to that total. Reviewing both views helps finance teams investigate differences and maintain reliable financial records.
How to Use the Report in Sage 100
Start by opening the relevant Accounts Payable reporting area in Sage 100 and selecting the open invoice report available in your installed version. Choose the appropriate reporting date, vendor range, and other available selection criteria. Confirm whether the report includes all relevant vendors and whether the output is intended for a current review, a period-end reconciliation, or payment preparation.
After generating the report, review invoice-level details and compare selected items with their source records. Check whether payments, credits, adjustments, and recently posted transactions are reflected as expected. If the report is being used for a month-end review, retain the selected parameters and report output so another reviewer can reproduce the same view.
How Finance Teams Interpret Open Invoices
An open invoice is not automatically overdue or ready for payment. Its due date, approval status, supporting documents, and remaining balance determine the next action. A current invoice may be scheduled for a future payment run, while an overdue invoice may need approval follow-up, a supplier statement review, or confirmation that a payment has not already been issued.
For example, assume a supplier invoice was originally $6,000 and the company has already applied a $2,000 payment. If the transaction is recorded correctly, the remaining open balance is $4,000. The report helps the team identify that outstanding amount rather than treating the original invoice value as still payable. Before releasing funds, verify that the balance reflects all relevant payments and credits.
Using Open Invoice Details in AP Workflows
Open invoice information becomes more actionable when connected with the wider purchasing and payment process. A purchase order or receipt record from procurement can help confirm that the billed goods or services were ordered and received. Accurate vendor management supports reliable supplier records, while a consistent invoice processing workflow helps ensure invoices are captured, coded, reviewed, and posted correctly.
AP Automation Software can help standardize invoice processing and payment planning. In an automated workflow, invoice capture collects invoice data, and validation checks important fields before posting. Invoice Matching compares invoice information with relevant purchase orders and receipt records, helping the team identify differences that need review. Resources such as invoice automation can provide further context on data extraction, validation, coding, and posting.
For suppliers who ask about invoice status, How Vendor Portals Improve Invoice Transparency discusses ways to communicate progress through the invoice workflow. Once an invoice is verified and authorized, Payment Approval represents the required authorization step before funds are released. The open invoice report can then help finance teams confirm which balances remain outstanding after payments are recorded.
Reconciliation and Best Practices
Use the report as part of a documented reconciliation process. Compare its total with the Accounts Payable control account for the same date, and investigate differences caused by cutoff timing, unposted transactions, report filters, or adjustments. Review older open items individually, since they may represent pending approvals, unresolved credits, partial payments, or transactions requiring correction.
Where expenses have been incurred but the supplier invoice has not yet arrived, accounts payable teams may also need to review goods received not invoiced (GRNI) and month-end expense recognition. Such accruals may require separate analysis because an open invoice report generally shows recorded invoice transactions rather than every expense incurred during the period. Keep supporting documents, approval records, and reconciliation notes together to improve traceability. Use Accounts Payable Matching Approval as a reference for controlled review of invoice details before payment processing.
Summary
The Sage 100 AP Open Invoice Report provides a transaction-level view of unpaid or partially unpaid vendor invoices. It supports payment scheduling, supplier follow-up, balance reconciliation, and period-end review. For dependable results, select appropriate report parameters, confirm invoice balances against source documents, and reconcile the output to the general ledger. Used alongside approval records and payment history, the report helps finance teams maintain visibility into outstanding obligations and make better-informed cash flow decisions.