Sales Order ReportsSales Order Reports

The Reports tab houses a variety of customer-facing reports as well as some Job Costing reports designed for management use.

Standard Options

Nearly every report described on this page has an Options button where you can sort and filter the report to include specific details. The options available depend on the report and are described below.

Sales Order Options buttons

Report Options

  • Print Report to your printer
  • Save as PDF on your hard drive
  • Email the report to the customer’s primary email address
  • Save in Docs which puts the report in the associated customer’s Document portal which is available in CRM.

Go To Report

  • Client Proposal takes you to the proposal print screen
  • Labor Hours opens the report as described in Management Reports below
  • Profit & Loss opens the report as described in Management Reports below
  • Product List opens the report as described in Management Reports below

At the bottom of every Options window, you have the option to:

  • Close the window
  • Navigate to the Details portion of the sales order.
  • Go to the sales order’s Designer window.

Client Reports

Client Contracted Sales Order
Clicking this button opens the same report engine used when creating your proposal. You’ll be able to customize the printout exactly as described in Proposals > Reports > Client Proposal.

Cover Page button
The Cover Page button opens the cover page of your proposal.
Standard printing and navigation options are available.
There is also a dropdown menu available where you can switch between cover pages to try out different templates.

Scope of Work button
This button opens the description of work that was defined by the sales team on the Scope of Work tab of the Proposal Setup.
Standard printing and navigation options are also available.

Financial Summary button
This summary button opens the Sales Order Summary report which documents the Payment Schedule, Change Order values, Invoices, and Payments for the sales order. You are prompted to view a Quick PDF or Save with Dialog which lets you choose the location on your computer to save the report. Click for a sample of this report.


Clicking the View Contract button will open the contract that has been loaded for this sales order. This could have come from the default contact assigned to the proposal’s Custom Template, or selected from the list of available contracts defined in Settings > Module Settings > Proposals > Contracts.
Standard printing and navigation options are also available.

Current Change Order button
When you click the Current Change Order button, iPoint opens Active change order in the same print window used to print the Client Contracted Sales Order here on the sales order or the Client Proposal in the proposal module. From here you can adjust the information displayed, printed, and/or sent to your customer. See Proposals > Reports > Client Proposal for detailed instructions.

Client Combined Sales Order button
Just like the current change order and contracted sales order buttons described above, this opens the print window where you can define what details are printed, PDFed, or emailed to your client. However, this button combines the change order with the contracted sales order. You have two options:

  • Detailed – displays every line item, both additions, and removals. So, if you had 1 TV on the sales order and -1 TV on the change order, the report would show two lines both the addition and the removal. The net result is 0 TVs.
  • Summary displays the net result of the changes. So if you had 1 TV on the sales order and -1 TV on the change order, the report would show no lines (because 1 – 1 = 0).
    The net result of both options is that the customer bought zero TVs. The only difference is how much detail they see.

Note: If the Sales Order has items that are marked Optional, you will be prompted to Hide or Show the optional items in the Client Combined Sales Order Report.

The Default Template dropdown box shows all the Custom Templates available for printing. Choosing a different template will affect the visual aspects of the printed documents. However, changing the template will not adjust the payment schedule or contract that was set when the proposal was converted to a sales order, even if the newly selected template has different settings. Contract and Payment Schedules are locked once the Sales Order is created.

Or to put it another way, when you print the client Combined Sales Order, the numbers on the Contract Summary will NOT reflect the change order values but will instead display the contract value when originally proposed to the customer. The Grand Total Summary or the Proposal Details with Grand Summary report, however, will reflect the new totals including the change order.

.

Management Reports

Labor Hours button
The Labor Hours button opens a report showing how many hours are included on the sales order.
Using the Option button on this report, you can sort by phase, group, or location. And you can also filter by a specific change order.
Standard printing and navigation options are also available.

Product List button
The Product List displays a pick list of products associated with the sales order with clickable checkboxes to manually mark the product as submitted, received, or delivered.
The products displayed also include the color of each item printed directly after the model number.

Product List Report OptionsProduct List Report Options
Using the Options button on this report allows you to sort by a manufacturer, location, phase, or phase/location as well as filter by a specific change order.
Standard printing and navigation options are also available.
Note: If the sales order is linked to another sales order [ Read More ] pressing the Product List button will prompt you to show products from the individual sales order or from all of the linked sales orders. Just click the This SO or All buttons to make your selection.: New in 9.0708

.

Product for Project button
Clicking this button produces a printable list of all products included on this sales order, including part number, description, quantity sold, & cost, price, and extended pricing details for each item.
The product list can be sorted by manufacturer, location, phase, and phase/manufacturer or phase/location combinations.
You can also customize the pricing totals to include or exclude the sales order total, the total labor hours, and any product where tasks have not been created yet.
Standard printing and navigation options are available.

Change Orders button
The change order list provides a list of all the change orders affecting this sales order. You can summarize the report by a number of different options:

  • Customer
  • Date Created
  • Date Committed
  • Sales Order Status
  • Change Order Status
  • Sales Person
  • Technical Designer
  • Project Manager

Utilize up to three summary options simultaneously by selecting multiple checkboxes. The order that checkboxes are selected will determine the priority of the sort.

  • For example, if you click Sales Order status first and then Date Created, all of the sales orders will be sorted first by status and then organized in date order.
  • However, if you clicked the Date Created checkbox first followed by the Sales Order status box, then the resulting report will display date order, with change orders from the same date sorted by status.

Once you select your sort options, clicking the green Go button will generate a PDF document and open it in your default PDF viewer.

Note: If the Change Orders button is greyed out that indicates that no Change Orders have been added to this sales order.

Profit & Loss button
Clicking this button opens the Profit & Loss report for this specific sales order. This report can also be run from the Reports module to encompass all active sales orders.

If the sales order has uncommitted change orders, you will be prompted to hide or show them.
Show Uncommitted Change Orders prompt

The resulting report provides cost, price, and margin for Parts, Labor, and Total.
Using the Options button you can sort the report by Phase or Group.
Standard printing and navigation options are available.

Profit By Product button
This button opens a report listing all products on the sales order, including items on uncommitted change orders.
Each item shows:

  • Model Name/Number
  • Quantity Sold and Delivered
  • Cost, Price, Margin and Profit each
  • Extended Cost, Price, Modified Price, and Profit

Using the Options button you can sort by Manufacturer, Location, phase, Phase/Location, or Item.
You can also show or hide various aspects of the report by clicking these buttons:

  • Toggle SO Total – shows or hides the total sales order dollar amount at the bottom of the report
  • Toggle Hours – shows or hides the total labor hours included at the bottom of the report
  • Hide/Show Non-Tasks – shows only parts where a task was created on the sales order Project tab.

Standard printing and navigation options are also available.

Retail By Product button

SO Product List reportSO Product List report

This button opens a report that shows the retail price of all items on the Sales Order, including items on committed change orders. New in 9.0527

Details include:

  • Item Number
  • Item Description
  • Quantity Sold
  • Unit of Measure
  • Price per unit
  • Extended Price
  • Notes added to the sales order

Using the report Options button you can sort the report by

  • Manufacturer
  • Location
  • Phase
  • Phase/Location
  • Vendor
  • Change Order Filter – pick a particular change order to view on the report

Standard printing and navigation options are also available.

Labor Sold vs Used button

Profit Analysis ExampleProfit Analysis Example

This button opens a PDF document that shows the breakdown of labor by Labor Phase showing the number of hours sold and the number of hours used as entered by technicians on work orders. It also shows the total hours not yet used as well as a percentage of hours used to hours sold. For the graphically inclined, there is a bar chart showing the hour comparisons. Click here for a sample of this report.

.

Profit Analysis button

The Profit Analysis report can be run as a Contracted report or as a Combined with Change Orders report. If you choose to include Change Orders you will be prompted to hide or show uncommitted change orders.
The resulting report shows a breakdown of Parts, Labor, and Misc. Modifiers as well as a detailed Profit Analysis, detailing total sale, cost, margin, markup, and profit for each category.

In addition to the standard printing and navigation options are two dropdown options to define how the report calculates information.

Based Labor Cost On – tells the report how to calculate the cost of labor when calculating profitability on the job. – New in 10.0305

  • As Bid – this option will use the time defined in the Designer using time associated with items or additional labor hours added to the job.
    • If you do not choose an option, this is the method iPoint will use.
  • Actual Cost by Time on Site – this option uses the actual time logged by technicians on work orders or projects and sales and engineering staff on the sales order to determine the labor cost.

Include Commissions by – defines how to apply the cost of commission to the profit analysis. – New in 10.0305

  • Earned – selecting this option will cause the dollar amount calculated by the commission rate to be added as a cost to the job. This includes unpaid commissions but is typically calculated based on the percentage of the job that the customer has paid.
  • Paid – choose this option to use the actual commission paid to the sales staff as a cost to the job.
    • Note: If you do not choose an option for this field, the commission won’t be included as a cost on this report. In fact, it will be displayed as N/A.

To ensure that your choices calculate correctly, you will need to refresh the data before you run the report. Do this by going to the Sales Order List > Options > and click on the Refresh All Metrics button.


Historical Revisions & Linked Sales OrdersHistorical Revisions & Linked Sales Orders

Historical Revisions

This list shows the proposal that was converted to the existing sales order at the top of the list and marked as “Current.” Each of the revisions that were not utilized is available to view by clicking on the Options button. Choose Revision Proposal Details to open the revision in the report editor so you can review it. Or click New Proposal From Revision to take the revision and make a brand new Proposal. The new Proposal is then available to edit and treat like you would any other job.

Linked Sales Orders

If the sales order is linked to another sales order, the associated Sales Orders will be displayed here. Linked sales orders have a common Project. This is typically done in a couple of different scenarios.

  1. The customer has two separate contracts for separate aspects of the job, but the two contracts are being executed simultaneously. For example, maybe one contract is for a security system while the other contract is for a whole-house audio system. Even though there are two separate documents, the pre-wire and installation of the two jobs are happening at the same time. By linking the sales orders, tasks from both sales orders can be assigned to a single work order so the tech only has a single document to refer to.
  2. In some instances, a contractor may have purchased a base system for a new home they are building. However, the end customer has added some upgrades on a separate contract directly with you. Linking the contractor and customer sales orders allows your technicians to perform tasks from each contracted sales order simultaneously on one project or series of work orders.

The View button next to the linked sales order will open it for quick and easy navigation between the associated jobs.

iPoint Version: 10.0305
Last modified: 16 Mar 2021

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.