Skip to main content

How do I run the Work Order As Build, SOR and BOM reports?

Use the Reports page on the web: pick a site and work order type, add columns, group, and export the Work Order As Build, SOR and BOM reports.

Open Reports from the side menu. Choose a tab: Work Order As Build, SOR Report or BOM Report. Narrow the list with Site and WO Type, then use the Export button to download it as CSV or Excel.

This guide is for admins and anyone whose role includes Reports. You only see the tabs your role allows.

1. Work Order As Build

This tab lists work orders with their details, one row each. It opens first.

The Work Order As Build tab with the tab name, the Site box and the WO Type box circled. Some site and project names are hidden in this picture.

  1. Choose a Site. All Sites shows every active site.

  2. Choose a WO Type. This tab always shows one work order type at a time, and starts with the first type in the list.

  3. Type in Search to find particular work orders.

The table shows the code, type, site, status, project, technician and supplier. Click the Settings cog to add more columns, such as address, dates, notes or QA comments. Your column choices aren't kept when you leave the page.

2. SOR Report

This tab lists the schedule of rates (SOR) items on each work order, with their quantities and amounts.

The SOR Report tab with All Sites and All Work Order Types chosen, listing work orders with SOR codes and descriptions.

Here WO Type starts at All Work Order Types, so you see everything straight away. Choose a site or type to narrow it.

Column

What it means

Original Quantity

The quantity planned for the work order.

Claim Quantity

The quantity the technician or subcontractor claimed.

Variation Quantity

Claim minus Original. Shown as 0 if less was claimed.

Approved Quantity

The quantity an admin approved.

Rate, Claim Amount, Variation Amount, Approved Amount

The rate in dollars, and each quantity multiplied by it.

More columns, such as completed and approved dates, supplier and address, can be added with the Settings cog.

3. BOM Report

The BOM Report tab works the same way for bill of materials (BOM) items: BOM code, description, quantities and amounts.

The BOM Report tab with one row showing a BOM description.

4. Group, sort and export

  • Group: drag a column header into the bar that says Drag a column header here to group its column, for example to group by site.

  • Sort or filter a column: click its header, or the filter icon next to it.

  • Export: click the download button at the top right of the table and choose CSV or Excel.

On the SOR Report tab, the WO Type list is opened, then the Export button shows CSV and Excel.

Export downloads only the rows on the page you're looking at. To export more, set Items per page at the bottom to 250 first, and export each page.

Common questions

Why is the table empty?

Check the Site and WO Type choices and clear the Search box. On Work Order As Build, try another work order type. The empty table says There is no data available to display at the moment.

Why is a tab missing?

Your role doesn't include that report. Ask your admin.

How do I download one work order's PDF report?

Reports here are lists across many work orders. For one job's PDF, see How to download work order reports, photos and media.

Related articles

Did this answer your question?