Anchor
servicemanagement_extended_prici_3866 servicemanagement_extended_prici_3866

Anchor
servicemanagement_extended_prici_5362 servicemanagement_extended_prici_5362

You can set the billing amount and markup costs for a service invoice based on criteria such as call type, problem type, equipment type, and so on, for non-labor charges. For example, for an emergency call, you might want the ability to charge a higher markup cost. In addition, you can also include a flat rate/fee with zero costs to the service invoice. 

...

Note
If you do not use the extended pricing matrix feature, but instead the standard one, all markup is markup on total cost; there are no other options available.

Extended

...

Pricing Matrix Setup

Setup involves the following steps:

Table of Contents
maxLevel 2 minLevel 2

Step 1:

...

Select Microsoft Dynamics GP > Tools > Setup > Service Management > Invoice Setup > Invoice Options.

...

Invoice Options Setup

Set up the following options in the Invoice Options Setup window.  See Choosing Invoice Options for more information.

1. Under Preferences, mark Use Extended Pricing by Cost Code (Non-Labor) checkbox to enable Extended Pricing Matrix.
2. Select the method of determining Defaults for Price Matrix and Labor Rate Groups:
   • Bill To (default): The pricing matrix and labor rate group default from the pricing matrix and labor rate group on the Bill To location record.
   • Location: The pricing matrix and labor rate group default from the pricing matrix and labor rate group on the service call Location record.
3. Select OK to save your settings.

Defaulting the price matrix and labor rate group

...

1. Under Service Call Defaults, you select whether the price matrix and labor rate group will populate on a new service call from the service call Location record or the Bill To Location record

...

• The price matrix and labor rate group for a new service call are pulled from the Bill To Location.
• A service call performed at location A and billed to location B will use the price matrix and labor rate group from location B (the Bill To location).>A service call performed at location B and billed to location B will use the price matrix and labor rate group from location B (the Bill To location).

...

1. .

Anchor
servicemanagement_extended_prici_4250 servicemanagement_extended_prici_4250

Step 2: Setting up

...

Sub-

...

Cost Codes for Other Costs (Optional)

Sub cost codes allow you to assign sub cost category accounts for other costs. An example would be a trip charge that you may charge that is separate from the actual work being done. This allows you to track other costs and a lower level through GL accounts. Sub cost codes apply only to cost code 5 (usually labeled as Other). Each sub cost code will have its own tax schedule and own set of GL accounts for posting.

Set up

...

Sub Cost Codes

1. Select Microsoft Dynamics GP > Tools > Setup > Service Management > Invoice Setup > Other Costs. The Other Costs Setup window opens.

2. Enter a Description for a sub cost code. Select Save. Repeat this step for all sub cost codes you are adding.

Assign GL

...

Accounts to Sub Cost Codes

1. Select Tools > Setup > Service Management > Invoice Setup > Invoice Accounts > Other Costs button.

2. Use the Default button to automatically fill an account field with the same account used for the main Other cost code. If you are using the same accounts, this button helps to speed up data entry.
3. Use the lookups to assign debit and credit accounts for each sub cost code.
4. When you are finished, select OK. You cannot leave this window until all sub cost codes have been assigned accounts.

Assign

...

Tax Schedule IDs to

...

Sub Cost Codes

1. Select Tools > Setup > Service Management > Invoice Setup > Master Tax Schedule Setup. The Service Management Master Tax Schedule Setup opens.

2. Select a master tax schedule ID.
3. Select the Other Costs Setup button. The Other Cost Master Tax Setup window opens.
4. Select an Other Costs Sub-Cost Code.

5. Select a Tax Schedule ID. 

   Note
   If you are using third-party tax software, the Exclude From Tax Calculation checkbox has no effect.

   
   

6. Select Save. The master tax setup is saved and displays in the list at the bottom of the window.

Step 3: Setting up

...

Extended Price Matrices for Markup on Costs

Extended price matrices allow you to define all pricing markup for non-labor charges, by cost code element. You can filter criteria by various elements of a service call, such as problem type, service call type, equipment type, and so on. Each element is a field that can be either required or not required. You can set up multiple price matrices, based on a combination of elements.
First, you must define which elements will be required for which price matrix/cost code combinations.

Specify

...

Required Fields for Entering Price Matrices

Fields you select will become required data entry any time someone enters a price matrix for that price matrix/cost code combination. You can include the following fields as required:

...

When you are finished specifying filter criteria fields, continue with Step 2 below to enter pricing markup information, including the specific values for the criteria fields you have marked as required.

Enter

...

Price Matrix Markup Cost Information

1. In the Extended Pricing Matrix window, select a Pricing Matrix  ID and Cost Code.
2. Make selections in the criteria fields, noting that those that include an asterisk * are required.
3. Select a Billing Method. The fields that appear depend on which billing method you selected.
   1. If you select:  Markup on Total Cost by Percent,  Markup on Unit Cost by Amount, OR Markup on Unit Cost by Percent 
      Then: A list view appears, where you can enter a Markup percentage, Starting Cost, and Ending Cost. Select Add to enable these fields.
      
      When you are finished with the first row, if you want to enter another cost range, press Tab. The cursor moves to the next row, where you can enter another markup percentage for the next price range. As rows are added, the price matrix hierarchy tree on the left is updated.
      
      For subsequent rows, the Starting Cost is always the ending cost from the previous row, plus one penny (.01). So if the ending cost from the previous row is $2,000.00, the starting cost for the next row fills with $2,000.01. The Ending Cost always fills with 99,999,999,999,999.99; you can adjust amounts to fit your own price range criteria.
   2. If you select:  Fixed Unit Price
      Then: Enter a Unit Price. Select Add. The price matrix hierarchy tree on the left is updated.
   3. If you select:  Fixed Service Call Amount
      Then: Enter a Billing Amount and Item Description. Select Add. The price matrix hierarchy tree on the left is updated.
4. Continue to add other price matrix combinations. Choosing Save clears the window, which allows you to add an entirely new price matrix with different criteria.

Working with the

...

Tree View Hierarchy

To collapse and expand the price matrix tree:

Use the collapse or expand buttons, as shown below.

To remove elements in a price matrix tree:

When you remove elements (nodes) in a price matrix tree, all child elements are removed along with the parent.

1. Expand the price matrix tree to view the elements you want to remove.
2. Select an element and select Remove.

To copy price matrices:

In the Extended Pricing Matrix window, select Copy. The Extended Pricing Matrix Copy window opens.

1. Select a Copy From price matrix name and a Copy To price matrix name. Enter a Pricing Description for the Copy To price matrix.
2. Select Copy.
3. Select OK to the Copy completed successfully message.

Step 4: Setting up

...

Billable Overhead 

To account for miscellaneous service expenses like shop supplies, fees, and non-inventoried items such as nuts and bolts, you may select to set up a "billable overhead" charge, to be added automatically to your service invoices. This charge is calculated as a percentage of the total cost or billing amount for a cost category, with set minimum and maximum amounts. Setting up this automatic charge is useful in helping to eliminate user error, as it assures that billable overhead is being applied on a consistent basis.
You can set up multiple charges in your pricing matrices, which are then assigned to customer locations; this allows you to not only associate different charges with different customers but also assign a different charge to each location.

Setting up an

...

Automatic Billable Overhead Charge

The parameters for automatically adding billable overhead to an invoice are set up on the Extended Pricing Matrix window. Similar to the way you use a pricing matrix to create markups for non-labor charges, you use this window to define when and how billable overhead is applied to a service call invoice.

...

1. Select Microsoft Dynamics GP > Tools > Setup > Service Management > Invoice Setup > Extended Pricing Matrix.
2. Select the Pricing Matrix that you wish to add the charge to, or enter a new name and description if you wish to create a new pricing matrix.
3. Select the Cost Code that the charge applies to. For example, if you select MATERIALS, the billable overhead charge will be a percentage of the cost or billing amount in the MATERIALS category. If you select OTHER/TRAVEL, select a Sub Cost Code as well.
4. In the Billing Method field, select whether you want billable overhead to be calculated as a percentage of costs or a percentage of the billing amount for the selected cost code.
5. Use the drop-down fields on the window to define billable overhead criteria. Service calls of which call type and problem type should include the extra charge? Or perhaps you want to set up billable overhead based on certain values in your user-defined fields. Only when a service call meets the criteria specified on this window will the charge be added to the service invoice. Billable overhead is calculated based on the following four criteria fields:
   • Problem Type
   • Service Call Type
   • User-Defined 1

   • The equipment-related fields Equipment Type, Manufacturer ID, and Model Number are disabled, as these are not criteria for determining when billable overhead is added.
     
     In addition, any of the four criteria fields that appear beneath these equipment fields will also be inactive. 

     Note
     If you wish to change the order of these fields, use the expansion button next to the Pricing Matrix field to open the Extended Pricing Matrix Setup window.

     
     

6. Specify the overhead billing charge amount by entering the Percentage of the total billing/cost. In the Item Description field, enter the description that you want to show up on the invoice for this charge.
7. Specify a Minimum and Maximum billable overhead amount. If the charge that is calculated from the percentage is higher than zero but lower than the minimum value, the minimum value will be used. If the amount is higher than the maximum value, the maximum value will be used. If you want to charge a flat fee on any billing or cost amount greater than zero, regardless of the percentage, enter the flat fee amount as both the minimum and maximum value.
8. Select the cost code that you want to apply the charge to. If you select Other as the Apply to Cost Code, also select a Sub Cost Code. The charge will appear as a billable amount charged to this cost code.
9. Select Add to add the parameters for the billable overhead charge to this pricing matrix. You can continue to set up billable overhead charges for additional cost codes on this pricing matrix; however, you can only set up one charge per cost code.

Assigning the

...

Charge to a

...

Location

After setting up the billable overhead charge parameters, assign the pricing matrix to a customer location. When you create a service call for this location, if the service call meets the criteria specified for billable overhead on the selected pricing matrix, the billable overhead charge will be automatically added to the invoice.

...