YMS Help Center

Reporting - Purchasing Report

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.


directions_40dp_666666.png Getting There

Go to Logs > Quick Reports > Purchasing Report.



filter_alt_40dp_666666.png 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.



print_40dp_666666.png Generating a PDF Report

Once you have filtered the results as required:

  1. Click the Print button.

  2. In the Generate Purchasing Report dialog, tick any of the Report Options below that you want to include.

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


download_40dp_666666.png Exporting to Excel

The information displayed in the grid can also be exported to Excel.

  1. Filter the results as required.

  2. Click the View by dropdown in the top right corner.

  3. Select Export to Excel.