The Purchasing Report gives an overview of your Purchase Orders, so you can see what has been ordered, what is on its way and what has been received. You can refine the results by order date, order status and stage.
As the filters are changed, the preview updates automatically so you can review the orders before generating the PDF report.
Getting There
Go to Logs > Quick Reports > Purchasing Report.
Filtering the Results
Date Filters
Order Date From - Filters the report to orders with an order date on or after the selected date.
Order Date To - Filters the report to orders with an order date on or before the selected date.
Order Status
Choose one or more statuses from the dropdown list. This filters the results to only include orders with the selected statuses. Leave it blank to include all orders.
These statuses come from your customisable Order Status list, which is managed in the List Utility.
Open, Shipped and Completed Orders
All three are ticked by default. Untick any you want to remove from the report.
|
Filter |
Includes |
|---|---|
|
Open Orders |
Orders that are not yet shipped or completed. |
|
Shipped Orders |
Orders marked as shipped that are not yet completed. |
|
Completed Orders |
Orders marked as completed. |
Note These are system statuses, set by the checkboxes on the Purchase Order. They are separate from your Order Status list.
All Departments
The All Departments filter is based on the logged in user's department.
Checked - Includes Other Departments Data.
Unchecked - Excludes Other Departments Data.
Generating a PDF Report
Once you have filtered the results as required:
-
Click the Print button.
-
In the Generate Purchasing Report dialog, tick any of the Report Options below that you want to include.
-
Click Create to generate a preview of the report.
The PDF report can then be downloaded, saved and shared as required.
Report Options
Both options are unticked by default, which gives a summary of each order.
|
Option |
What it does |
|---|---|
|
Include Related Tasks |
Lists the Tasks linked to each order, with their Job #, Subject, Equipment and Status. |
|
Include Line Items |
Lists each line item on the orders, with the quantity ordered and received, the cost per item and the extended cost. |
Exporting to Excel
The information displayed in the grid can also be exported to Excel.
-
Filter the results as required.
-
Click the View by dropdown in the top right corner.
-
Select Export to Excel.