Pending Purchase Orders Report
This report shows pending purchase orders. A purchase order is pending if it is at least in draft status but the invoice for ordered items has not been processed yet and/or stock is not received. Use this report to see the PO status and the number of items ordered, still to invoice, and still to receive for a supplier or PO #.
Users need the Purchase Reporting permission to access this report.
Prerequisites
Data from this report can be exported in Excel, PDF or RTF format.
Input:
Reporting Period |
Allows the user to select the reporting period from a list of options or set a custom date range. |
Layout |
Set to the Default layout. Allows selection of saved layouts, if any. |
Save Layout As |
Allows saving a layout for potential future use. |
Reset Layout |
Resets the layout to the default layout or selected saved layout. |
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.
Output:
The following output fields are available for this report. You may have to open the Configure Layout menu to add some of them to your report.
Fields | |
SKU |
Product SKU, ordered but not yet fully billed |
Product |
The name of the product, ordered but not yet fully billed |
PO # |
Purchase Order Number the product is ordered by |
PO Date |
Date of the purchase order |
Status |
Purchase status |
Supplier |
Name of the supplier who received the purchase order |
Year |
Year of the purchase order date |
Quarter |
Quarter of the purchase order date |
Month |
Month of the purchase order date |
Location |
Location this purchase is intended for |
Category |
Product category |
Brand |
Product brand |
Product Tags |
Comma-separated product tags |
Family |
Product family name |
Unit |
Product unit of measure |
Required By |
Date when stock is expected to be received |
Supplier Additional Attribute 1-10 |
Values of Additional supplier attributes |
Product Additional Attribute 1-10 |
Values of Additional product attributes |
Data Headers | |
Total |
Quantity of the product being ordered |
In Production |
Quantity of the product not yet billed |
To Receive |
Quantity of the product not yet received |
Note: If you have added an Additional Attribute set to your purchase process, the attributes will appear as additional report fields.
FAQs
Here are some questions from Cin7 Core users that have been answered by our support team. If your question does not appear, please do not hesitate to get in touch with Cin7 Core support.
I need to find out what purchase orders and items on them are pending for receipt – but excluding dropship purchase orders. I mean all purchase orders that are open and have not been fully receipted into stock regardless of whether it has been invoiced.
You can use Pending Purchase Orders or Purchase Order Details and filter the status by Receiving. It is not currently possible to exclude dropship purchase orders.
How do I add a cost price in this report?
Unfortunately, the cost price is not available for the Pending Purchase Orders Report. You may just check out other Purchase Reports such as Purchase Order Details which has a cost price and is more comprehensive. You may filter the desired status by Ordering so that the result will be similar to the Pending Purchase Order Report.
I have a product not showing up on my open purchase orders report. It's a non-inventory part, but I need it on there. Can you please tell me how I can fix to add these open POs to the report?
Unfortunately, PO reports only pull stockable items. There is currently no report which pulls non-inventory purchasing. For service items, If you are using a report that populates the products, the PO will still appear but not the item.
Is there a possibility to add an inventory field (eg. Stock On Hand) into the pending purchase order report?
Unfortunately, this is currently not possible. The Quantity on Hand is not an available field to be added in that report. Please consider running the Product Stock Level Report where you can see the current Quantity on Hand information, along with the Pending Purchase Order report. You may export these reports into Excel, where you can combine the data from both reports into a single report.
I have generated the Purchase Order Details Report. We have received and gotten billed by the supplier already but the ‘Status’ is showing ‘Receiving’ as the full PO has not been received/billed. Is there a way to generate a report that shows the ‘Status’ and ‘Invoice Status’ columns, by SKU per PO instead of by PO?
Please run the Pending Purchase Order Report to see if a purchase order has been authorized but the invoice for ordered items has not been processed yet and/or stock is not received. You may also check the Stock Received vs Invoice report which compares stock received vs items invoiced. You can see what has been received but not invoiced or what has been invoiced but not received. You can view the Sale Order Details Report, and it will show if items were already invoiced or not yet.
We have run the Pending Purchase Order Report and some items are coming up on the report where in fact the PO has been closed. I have noticed that if we have ordered 3 items but only received 2 & was invoiced for 2, it shows up on the Pending Purchase Order Report that we still require 1 item. How do I remove the 1 item from the report?
If there is no further stock to receive, you can click Mark as Received on a purchase order to remove it from the Pending Purchase Orders report. Stock received tab and invoice tab must show the same quantity and be authorized for Mark as Received option to be visible.
Can you please tell me why PO-XXXX is missing from this report?
Usually, this is an issue with the date filters. By default the date filter is set to 'Last Month', however, if you are part-way through the next month, this may miss some recent POs. Try setting the reporting period to 'Last 30 days' or setting a custom date range instead. Missing entries can also be caused by cache problems. Try clearing your cache and refreshing to see if the issue persists.
Still no answer to your question? Please do not hesitate to get in touch with Cin7 Core support.
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB