Morning CoffeeMorning Coffee

Morning Coffee is a configurable reporting engine that enables the delivery of ad-hoc email reports to specific users on a specific schedule.

How to get started

Name the Report

  1. Click the New Morning Coffee Report button
  2. In the edit screen on the right, adjust the Report Name

Report Content

  1. Click the in the Report Information (Elements/Content) section to open the list of available report elements. If the pop-over window is blank, click the Update Morning Coffee Definitions button.
  2. You can use the wildcard search at the top to filter down the number of reports displayed.
  3. Select the report you want to use by clicking the . The icon will change to a green “dash icon”. You can include as many report elements as you like on a single Report. NOTE: A detailed description of each report is listed at the bottom of these instructions.
  4. Click the Close button to close the pop-over window and add the element to your report.

Schedule the Report

  1. Click the in the Delivery Schedule section to select the time frame and delivery schedule for the report.
  2. Select either Daily, Weekly or Monthly to determine the date the report will run. Each schedule has its own set of options. This also sets the date range for the data, from the previous period and time to the defined date and time.
  3. Select a Run At time to determine what time when the report will be sent on the date selected in step 2.
  4. Click the “close icon” in the top right corner to save the schedule.

Choose Recipients

  1. Click the in the Recipients section
  2. The names in the pop-over list come from active iPoint users maintained in Settings > Users
  3. Click the next to everyone who should receive this report.

Finalize the Report

  • Display Report: will execute the report and show it in a new window.
  • Send Report: will cause the report to be delivered to the recipients.
  • Display and Send Report: will cause the report to be displayed and emailed to the recipients.

Morning Coffee Sample ReportMorning Coffee (Sample Report)

Editing A Morning Coffee Report

  1. Select the report under “List of Morning Coffee Reports”
  2. Click the + buttons under the headings described above to modify the information, schedule, and recipients.

Additional Options

  • *New Morning Coffee” – Creates a new report.
  • Duplicate… – Duplicates the currently selected Morning Coffee report.
  • Delete… – Deletes the currently selected Morning Coffee report.
  • Update Morning Coffee Definitions

Report Details

Details displayed on the Morning Coffee report are defined by the frequency the report is generated.
If the report is scheduled weekly the number of customers added, for example, will be those added in the past week.
If the report is scheduled monthly, the dollar amount of new invoices will be calculated based on transactions in the past month.

Here is a detailed description of each report available for inclusion in Morning Coffee. They are divided into report topics.

Contacts

  • Count Of Customers Added: Displays the number of Customers/Contacts added to the system in the specified time period.
  • List Of Customers Added: Shows a list of the customers added to iPoint in the specified time period with customer name, what user added the customer, and who is the assigned sales rep.
  • Customers needing QB Sync Today: The number of customers that are not synced with QuickBooks. Includes those that have had syncing errors.

New Proposals

  • Count of Proposals Created: Displays the number of Proposals created in the specified time period. This does not include Proposals that have been converted to Sales Orders.
  • List Of Proposals Created: Provides a list of Proposals created in the specified time period. This does not include Proposals that have been converted to Sales Orders. Includes the Proposal’s name and the Sales Rep.

Lost Proposals

  • Count Of Proposals Lost: Displays the number of proposals that were not accepted by the customer in the specified time period. This is determined by the Proposal Status set as Customer Rejected in Settings > Pop Up Lists > Proposal Status.
  • List Of Proposals Lost: Prints a list of proposals that have been marked lost, displaying customer name, the reason lost (set up in Settings > Pop Up Lists > Proposal Lost Reasons) and the memo entered at the time of marking the proposal lost.

Sales Orders

  • Count of Sales Orders Created: Displays the number of Proposals that were converted to Sales Orders in the specified time period.
  • List of Sales Orders Created: The list of change orders includes the customer, sales order name, change order number, the description of the change order, and who created the change order in the specified time period.
  • Amount of New SO: Displays the total dollar amount of the new sales orders created in the specified time period along with accepted change order amount.

Change Orders

  • Count of Change Orders Created: Displays the number of change orders created in the specified time period.
  • List of Change Orders Created: The list of change orders includes the customer, sales order name, change order number, the description of the change order, and who created the change order.
  • List of Change Orders Committed: Provides a list of change orders that have been approved or committed in the specified time period. This report includes the customer and sales order name, the change order number, the description of the change order as entered on the C/O details, what user approved/committed the change order, and the total dollar amount of the change order.
  • Amount of Committed CO: Displays the total dollar amount of all committed/approved change orders in the specified time period.

Invoices

  • $ of New Invoices: Displays the dollar amount of all invoices created in the specified time period (including standard and RFP invoices).
  • Total Invoiced YTD: Total value of Invoices created this year to date…includes archived Invoices.
  • RFP Invoices ($): Displays the dollar amount of RFP (Request for Payment) invoices created in the specified time period.
  • Delivery Invoices ($): Displays the dollar amount of Delivery invoices created in the specified time period. These are the invoices reflecting delivered product and time in the RFP billing process.
  • Standard Invoices ($): Displays the total of standard invoices created in the specified time period. Standard invoices are created from projects, work orders, and stand-alone Point of Sale invoices.
  • Invoice Aging (30,60,90): Prints totals for invoices with a balance due. The invoice number, the invoice total balance, and the invoice balance due are displayed for invoices 0-29 days old (Current), 30 to 59 days old( 30 Days), 60 to 89 days old (60 Days), and 90 days and older ( 90 Days). Note that a time period with no balance due is omitted from the report.
  • Invoices Age Current (Invoice Total): Displays the total balance due of all invoices that are less than 30 days old.
  • Invoices Age 30 (Invoice Total): Displays the invoice total of all Invoices with a balance due that are between 30 and 59 days old.
  • Invoices Age 60 (Invoice Total): Displays the invoice total of all Invoices with a balance due that are between 60 and 89 days old.
  • Invoices Age 90 (Invoice Total): Displays the invoice total of all Invoices with a balance due that are 90 days old or older
  • Invoices Total Balance Due: Prints the total amount of all open customer invoice balances. This is a cumulative total, not just those invoices created since the last report was generated.
  • Invoices Age Current (Balance Due Total): Displays the balance due total of Invoices with a balance due that are 0 to 29 days old
  • Invoices Age 30 (Balance Due Total): Displays the balance due total of Invoices with a balance due that are between 30 and 59 days old
  • Invoices Age 60 (Balance Due Total): Displays the balance due total of Invoices with a balance due that are between 60 and 89 days old
  • Invoices Age 90 (Balance Due Total): Displays the balance due total of Invoices with a balance due that are 90 days old and older
  • Invoices needing Sync with QB: Any invoice that has not been synchronized to QuickBooks or has had a change since it was last pushed to QuickBooks will be included in this count.

Purchase Orders

  • List Of ALL Purchase Orders Created NOT Submitted: Provides a list of any purchase order that has not been marked submitted. This list includes the PO number, the vendor name and the status of the purchase order.
  • Count Of ALL Purchase Orders Created NOT Submitted: Displays the count of any purchase order that has not been marked as submitted.
  • Count Of NEW Purchase Orders Created NOT Submitted: Shows the count of new purchase orders entered in the specified time period that have not been marked as submitted.
  • List Of NEW Purchase Orders Created NOT Submitted: Prints a list of the purchase orders created in the specified time period. The list includes the PO number, the vendor, and the status of the purchase order.
  • Count Of Purchase Orders Submitted: Displays the number of purchase orders that were marked submitted in the specified time period.
  • List Of Purchase Orders Submitted: Shows a list of purchase orders that have been marked submitted in the specified time period and includes the PO number, the vendor, the status of the purchase order, and the total value of the PO.
  • Count Of Purchase Orders Received in Full: Shows the number of purchase orders that have been marked Received in Full in the specified time period.
  • List Of Purchase Orders Received in Full: Displays a list of the purchase orders marked Received in Full in the specified time period.
  • Items Received: Shows a list of items has been received on a purchase order in the specified time period. This report shows the item name, the quantity requested and received, the job the parts were ordered for, and the PO number.
  • Product Receipt with Sales Rep: Shows a list of items has been received on a purchase order in the specified time period. This report shows the item name, quantity requested and quantity received, and the purchase order number as well as the job and sales representative names. The user who received the items is also displayed.
  • Items Received w/ Back Order Date: Shows a list of items has been received on a purchase order in the specified time period. This report shows the item name, the quantity requested and received, the job the parts were ordered for, the PO number, and a back order date if any.
  • Items Back Ordered: Shows a list of items has been back ordered on a purchase order in the specified time period. This report shows the item name, the quantity requested and received, the job the parts were ordered for, the PO number, a backorder date, and the back order expiration date.

Payments

  • Payments Received: Provides a list of payments created in the system in the specified time period. The list includes the payment reference number, the date the payment is received, the customer, the payment amount, the payment method (type), how much of the payment is available, and any memo recorded with the payment.

Projects

  • Projects Created: Provides a count of the new projects that have been created in the specified time period.
  • Tasks Added to Projects: Shows the number of tasks that have been added to all projects in the specified time period.
  • Work Orders Scheduled in the period: Displays a list of work orders that were scheduled in the specified time period. The report includes the date scheduled, the work order status and name, and whether or not the work order is billable and had parts added. This report prints all work orders regardless of project affiliation.

Work Orders

  • Work Orders Created: Displays a count of all new work orders created in the last time period.
  • Work Orders Scheduled: Shows a count of work orders that were scheduled in the last time period.
  • Work Orders Completed: Prints a count of work orders that were marked completed in the last time period. A completed work order is one that has a status of “Complete” as defined in Settings > Pop Up Lists > Work Order Status.
  • Work Orders Not Completed: Displays a count of work orders from the previous period that were not marked complete.
  • Needs Billed: Shows a count of work orders from the previous period that are marked Billable.
  • Parts Added: Shows a list of parts added to work orders since the last time the report was generated. The list includes the date the part was added, the name of the job, the item name and quantity added, as well as the delivery status.

All Work Orders That Need Billed

  • All Work Orders Needs Billed: Provides a count of all work orders that have the “Billable” checkbox ticked and are not marked as ‘Billing Complete’

Time

  • Billable Time – Total Time – Per Tech: Shows a list of time broken down by User and includes Time Clock time (amount of hours checked in on the iPoint dashboard) and the Work Order Time (the total of all work order check in and check out) during the past time period.
  • Work Order Time: Shows a summary of time a tech has assigned to a work order. Work Order Name, Tech, and Total Time clocked for a Work Order in the specified time period.
  • Work Order Time Detail: Shows the list of time entries for the specified time period. The list includes the Work Order, the tech, the total time, the time in, the time out, the labor phase, and any memo.

Tech Utilization Rate

  • WO Time / Time Clock: Displays the percentage of hours worked that are listed on a Sales Order since the report was last generated. This takes the total hours of all employees as entered on all work orders divided by the total hours of all employees as entered on the time clock.
  • Persistent Time / Job Time: Displays a calculation of the number of work order hours on persistent work orders divided by the total of all work order hours.

Morning CoffeeMorning Coffee
h4. RMA
  • RMA Created: Displays the count of new Return Materials Authorizations created in the specified time period.

Deals

  • Pipeline – All Deals Value: Presents the value of each Customer Job Sales Status (set up in Settings > Pop Up Lists > Customer Job Sales Status) set on the customer record. iPoint summarizes the value of customers’ open (not archived) proposals for each customer job sales status created in the past time period.
  • Pipeline – All Deals Count: Presents the total number of proposals created in the past period broken down by customer lead status type.

Deal Goals

  • Deals Won by User towards Value: Shows the total value of Deals that have been won against the Deals Won by User towards Value Goal (set up in Settings > Users > Goals)
  • Deals Won by User toward Count: Shows the total count of Deals that have been won against the Deals Won by User towards Count Goal (set up in Settings > Users > Goals)
  • Deals Proposed by User towards Value: Shows the total value of proposals created in Deals against the Deals Proposed by User towards Value Goal (set up in Settings > Users > Goals)
  • Deals Proposed by User Towards Count: Shows the total number of proposals created in Deals against the Deals Proposed by User towards Count Goal (set up in Settings > Users > Goals)
  • Pipeline – Deal Count for User: Displays the number of Deals the user has in each Deal status.
  • Pipeline – Deal Value for User: Displays the total dollar value of active Deals the user has.
Last modified: 17 Dec 2019

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.