Field Definitions: SM Rate Template Effect Dates Form

The following is a list of field descriptions for the SM Rate Template Effect Dates form. Many of the descriptions include links to other topics that provide additional information about or related to the topic.

Effective Date

The Effective Date field on the SM Rate Template Effect Dates form.

Enter the effective date for which to define override equipment, labor, material, and standard item rates. Initially defaults the effective date selected in the Effective Date grid in SM Rate Templates.

Note: You cannot add new effective date templates here. You must use SM Add Effective Date. However, you can enter a different effective date to work on, as long as it exists for the rate template.

Equipment Rates: Markup Percent

The Equipment Rates: Markup Percent field on the SM Rate Template Effect Dates form, Info tab and the Effective Dates tab in SM Rate Templates.

Enter the markup rate to use for equipment used on a work order (e.g. enter 5% as 5.00000).

When entering work completed equipment lines in SM Work Orders (Work Completed tab), the system uses this rate in conjunction with the equipment usage rate (defined for the revenue code in EM Revenue Rates by Category or EM Revenue Rates by Equipment) to derive the Billable Rate.

Note: You can override the markup rate defined here by equipment and revenue code in SM Rate Equipment Overrides (accessed by selecting the Advanced button to the right). The system will only use the rate specified here if an advanced rate is not found for the equipment and revenue code specified on work completed equipment line. However, since equipment rate overrides can also be defined at the rate template, customer, and service site levels, the system will use a specific hierarchy to determine which equipment rates to use. For more information, see Equipment Rate Hierarchy.

Labor Rates: Rate

The Labor Rates: Rate field on the SM Rate Template Effect Dates form, Info tab and the Effective Dates tab in SM Rate Templates.

Enter the standard labor rate to use when entering work completed labor lines on a work order in SM Work Orders (Work Completed tab).

Note: You can override the labor rate specified here by technician, craft/class, call type, and/or pay type in SM Advanced Labor Overrides (accessed by selecting the Advanced button to the right). The system will only use the rate defined here if no advanced rate is found matching the criteria specified on the work completed labor line. However, since labor rate overrides can also be defined at the rate template, customer, and service site levels, the system will use a specific hierarchy to determine which labor rates to use. For more information, see Labor Rate Hierarchy.

Material Rates: Type

The Material Rates: Type drop-down on the SM Rate Template Effect Dates form, Info tab and the Effective Dates tab in SM Rate Templates.

Specify how to represent the Percent field.

  • Markup - Select this option if the Percent specified below represents a markup rate.
  • Discount - Select this option if the Percent specified below represents a discount rate.

The system uses the type specified here in conjunction with the Basis and Percent defined for the rate template to determine billable amounts for material-related work completed Misc, Inventory, and Purchase lines on a work order.

Note: If you have defined rate break points in SM Rate Override Material Form (accessed via the Advanced button below), the option selected here determines whether the rates are markup rates or discount rates. However, if you have defined advanced rates by material or category (in SM Rate Override Material, Category & Material Overrides tab), the option selected here will be overridden by the rate type selected for each material or category override. For more information about the override hierarchy for material rates, see Material Rate Hierarchy.

Material Rates: Basis

The Material Rates: Basis drop-down on the SM Rate Template Effect Dates form, Info tab and the Effective Dates tab in SM Rate Templates.

Select the cost basis to use in Billable Rate calculations for materials entered on a work order (in SM Work Orders, Work Completed tab). The basis selected here will be used when entering materials on a work order where the entry date is equal to or greater than the Effective Date specified for this template.

For each of the applicable default descriptions below, IN Location Materials and HQ Materials apply as follows:

  • HQ Materials — Inventory lines that reference an HQ material (that is, IN Co and Location are not specified), Purchase lines that specify a material, and Misc lines generated from AP where a material is specified.
  • IN Location Materials — Work completed Inventory lines with an IN Co and Location specified.
A-Actual Cost
Typically used with Markups.

Select this option to use the Total Actual Cost specified on the work completed line.

This option does not apply to work completed Purchase lines; therefore if you select this option, the system will use the Total Project Cost in markup/discount calculations for Purchase lines.

S - Standard Cost
Typically used with Markups.

Select this option to use the standard unit cost defined for the material in HQ Materials or IN Location Materials.

This option does not apply to material-related work completed lines that do not specify a material; therefore if you select this option, the system handles the markup/discount calculations as follows:

  • For work completed Misc lines that reference a material-related SM Cost Type, but do not reference a material, the system uses the Total Actual Cost.
  • For work completed Purchase lines that reference a material-related SM Cost Type, but do not reference a material, the system uses the Total Projected Cost.
V - Average Cost
Typically used with Markups.

Select this option to use the Avg Unit Cost defined for the material in IN Location Materials.

This option does not apply for work completed lines that specify an HQ Material or do not specify a material; therefore if you select this option, the system handles the markup/discount calculations as follows:

  • For lines that specify an HQ Material, the system uses the Standard Unit Cost in HQ Materials.
  • For work completed Misc lines that reference a material-related SM Cost Type, but do not reference a material, the system uses the Total Actual Cost.
  • For work completed Purchase lines that reference a material-related SM Cost Type, but do not reference a material, the system uses the Total Projected Cost.
L - Last Cost
Typically used with Markups.

Select this option to use the Last Unit Cost defined for the material in IN Location Materials.

This option does not apply for work completed lines that specify an HQ Material or do not specify a material; therefore if you select this option, the system handles the markup/discount calculations as follows:

  • For lines that specify an HQ Material, the system uses the Standard Unit Cost in HQ Materials.
  • For work completed Misc lines that reference a material-related SM Cost Type, but do not reference a material, the system uses the Total Actual Cost.
  • For work completed Purchase lines that reference a material-related SM Cost Type, but do not reference a material, the system uses the Total Projected Cost.
P - Standard Price
Typically used with Discounts.

Select this option to use the standard unit price defined for the material in HQ Materials or IN Location Materials.

This option does not apply to material-related work completed lines that do not specify a material; therefore if you select this option, the system handles the markup/discount calculations as follows:

  • For work completed Misc lines that reference a material-related SM Cost Type, but do not reference a material, the system uses the Total Actual Cost.
  • For work completed Purchase lines that reference a material-related SM Cost Type, but do not reference a material, the system uses the Total Projected Cost
Note: If the unit of measure specified for the work completed material line does not match the Standard UM defined for the material (in HQ Materials), the system will use the unit cost or unit price (if using Standard Price) defined for the posted unit of measure in the Add'l UMs table (Inventory lines) or Additional Units of Measure table (Purchase lines).

Break Points By

The Break Points By drop-down on the SM Rate Template Effect Dates form, Info tab and the Effective Dates tab in SM Rate Templates.

Select how to apply rate break points when calculating discounts or markups for stocked or purchased materials specified on a work order using this template.

  • T-Total Cost - Select this option to apply rate break points based on the total cost of the material. For example if you have a break point value of $500, the system will apply a markup or discount when the material total is equal to or greater than $500.

  • U-Unit Cost - Select this option to apply rate break points based on the unit cost of the material. For example if you have a break point value of $10, the system will apply a markup or discount when the material's unit cost is equal to or greater than $10.

Material Rates: Percent

The Material Rates: Percent field on the SM Rate Template Effect Dates form.

Enter the standard markup or discount percent to apply to materials (stocked or purchased) specified on a work order where the work order completed line's Date falls on or after the specified Effective Date for the template.

The system uses this rate for work completed inventory, work completed purchase lines, and work completed miscellaneous lines as follows:

  • Miscellaneous lines - The system uses this rate when a material SM Cost Type is entered (that is, the cost type category is M-Material), regardless of whether you specify a material.
  • Inventory lines - The system always uses this rate, even if no SM Cost Type is specified.
  • Purchase lines - The system uses this rate if:
    • You enter a material SM Cost Type for the PO item, regardless of whether you specify a material.
    • You enter material for the PO item, but you enter a non-material SM Cost Type or leave the SM Cost Type blank.
Note: If you enter a value of 0.00 here, the system assumes that you intended this value and no markup or discount rate is applied to the work completed line; no further rate search will occur.

If you override the markup/discount rate defined here by rate break point in SM Rate Override Material (accessed by selecting the Advanced button to the right), you must specify a rate here. If this rate is 0.00, the break points are ignored.

Break Points

When using break points, the system first calculates the billable rate for the work completed line using the rate specified here. It then multiplies the billable rate x quantity to derive the material total. The material total is then compared to the rate break points defined in SM Rate Override and, if a match is found, the system recalculates the billable rate using the rate break point rate. If no match is found, the previously calculated billable rate is used.

Note: You can override the markup/discount rate defined here by category or material in SM Override Category Material (accessed by selecting the Advanced button to the right and selecting the Category & Material Overrides tab). The system will only use the rate defined here if no advanced rates are found for the material/category specified on the work completed labor line or in the rate break points table. However, since material rate overrides can be defined at the rate template, effective date, customer, and service site levels, the system will use a specific hierarchy to determine which material rates to use. For more information, see Material Rate Hierarchy.

Non-Material Purchases: Markup Percent

The Non-Material Purchases: Markup Percent field on the SM Rate Template Effect Dates form, Info tab and the Effective Dates tab in SM Rate Templates.

Required.

Enter the override markup percent to apply to non-material Misc and Purchase work completed lines. Enter 5% as 5.00000.

Non-material work completed lines are defined as follows:

  • Miscellaneous lines specifying a non-material SM Cost Type (one with a cost type category other than M-Material) with no material specified or lines were where no SM Cost Type is specified and no material is specified.
  • Purchase lines with a non-material SM Cost Type or null SM Cost Type and no material specified

The system applies this rate to the Cost Rate of the work completed purchase line to determine the Billable Rate.

Enter 0.00 if no markup will be applied to non-material purchases.

Note: You can override this markup percent at the customer level (in SM Customers), service site level (in SM Service Sites), or work order quote level (in SM Work Order Quotes). The system will only use the rate specified here if no overrides are defined at the service site, customer, or quote level (quote-related work orders only).