Reconciling Purchase Order Received Not Invoiced Account with Sage X3


Received, not invoiced reconciliation is a crucial process in the purchase cycle of any organization; financial transaction of accounts payable records with inventory or purchase order records needs reconciling to ensure that all items received have been properly invoiced. It can help identify any discrepancies or errors in the accounts payable process.

For example, let us say you receive a shipment of goods from a supplier but do not receive an invoice for those goods. You may pay for those goods twice without proper reconciliation if the invoice is eventually received and processed. Alternatively, if the invoice is never received, the supplier may not get paid, damaging your relationship with that supplier.

By performing a received, not invoiced reconciliation, you can ensure that all items received have been properly invoiced and that your accounts payable records are accurate.

Sage X3 provides a simple and efficient way to perform received, not invoiced, reconciliation.

In Sage X3, you can run the “Received Not Invoiced” SQL query report, showing all purchase orders received but not yet invoiced.

Here are the basic steps to create a report that shows all items received but not yet invoiced.

Step 1: Navigate to Setup – Usage – Reports – SQL Query Report

A screenshot of a computer Description automatically generated with low confidence

Step 2: Select the Received not Invoiced query code below and Click on Run to generate the query.

Graphical user interface, text, application, email Description automatically generated

Step 3: Use the Criteria to access the filtering option.

Step 4: Define your filtering parameter.

Graphical user interface, text, application Description automatically generated

Step 5: Search to view the filtering result.

Table, Excel Description automatically generated


From the search result, the RNI balance column is the uncleared amount in the purchase cycle.

The report can be exported to Excel for further analysis.


Transforming businesses since 2009

For over a decade, Panni has helped companies transform their businesses to lead, innovate and be profitable. With the right combination of technology and experienced developers and consultants, we help companies with Change Management to achieve the organizational objectives. We believe in long-term relationships with our clients and provide top-notch support with fast turnaround times.

Looking for ERP advice?