Time and Material tasks vs. Contract Tasks

A time and materials task (T&M) can be configured to update the quantity on the sales order from the actual time spent on the task. A contract task can be configured with a set amount of billable time.

Managing time within the EBMS task system consist of two values found within the Timecard tab as shown below:

  1. The Billable Time reflects the time that is being billed on the invoice. This time can be manually entered, copied from the inventory item classified as service, or copied from a proposal or quote.

  2. The Actual Time is the sum of all the time the employee entered within the time tab. The Actual time is recorded within the employee’s time

One of the best ways to manage a service business is to manage labor properly. Comparing the Billable Time and Actual Time values is an excellent management tool.

The following table lists the way these time values are used with a variety of task or project types:

 

Task Type

Billable Time

Actual Time

Comments

Time & Materials tasks

Time is copied from Actual time*

Time recorded by Employee

Review section below for more details

Contract Tasks

Time is created from the contract proposal or inventory item.

"

Most contract tasks are created from the SO or Proposal. Review the Creating Tasks > Creating a Task from an Invoice for more details

Tasks attached to Job Costing

Billable time is derived from the budget or proposal

"

Review the Managing Tasks > Using Tasks and Job Costing section for more details.

Warranty Tasks

Time is blank unless vender is charged for service time.

"

 

Sales Tasks

Blank

"

Review the Using Tasks as a Contract Manager for more details.

Copying Actual Time to equal the Billable Time

The Actual time is copied to the Billable time within a task if the Update billable time from actual time option is enabled. The Billable time must be manually entered or copied from the proposal if this option is disabled.

The 2nd step of updating the sales order from the Billable time is to enter a Service inventory item with a multiplier. The following settings are found on the right side of the Billing tab.

The Service code must be an inventory item classified as a Service item. Review the Creating Tasks > Attaching a Task to a Service Item section for more details on service codes.

The Estimated Hours entered within the General tab of the inventory item is copied to the Hours per unit entry. This value becomes the multiplier to calculate the quantity shipped within the attached sales order. Sales Order > Shipped = Billable time * Hours per unit value. Note that the Update document quantity from billable time must be enabled to update the sales order.  

Since the sales order quantity affects the total of the invoice, an invoice amount can be updated automatically when the employee enters time into the task’s Timecard tab. Complete the following steps to attach a sales order to a task:

  1. Click on the Select button to create a new sales order or to attach to an existing sales order.

  2. Select the first option to create a new sales order or invoice. Select the second option - I want to link this task to an existing invoice option to append the item to an existing sales order.
     

  3. The existing sales order or invoice list can be filtered by setting the Status setting. The recommended Status query is the Sales Order option since additional time can only be appended to sales orders. Use the Search for Invoice Number entry to search for an existing sales order.

  4. Enable the View the invoice after linking to open the sales order. The user can click the View Invoice button to view the sales order.

  5. Click on the OK button and the following dialog will open if a Service inventory item is attached:

  6. Click on the Yes button to create a new line on the sales order, Existing Line to add the time to an existing line with the same Service inventory item, or No to manually enter the service code line. Note that the Existing Line button will be disabled if no existing line exists within the selected sales order that contains the specific Service inventory item.

The invoice will open after the wizard is completed if the View the invoice after linking option found on the invoice list page was enabled.

Tasks can also be attached directly from a sales order or when a proposal is used to create a sales order. Review the Creating Tasks > Creating a Task from a Proposal or Quote or Creating Tasks > Creating a Task from an Invoice sections respectively for more details.