...

Creating a price matrix markup

1. Choose Microsoft Dynamics GP > Tools > Service Management > Invoice Setup > Pricing Matrix.
2. If you selected the markup-on-cost inventory method in the Invoice Options window, the Payables & Manual Transactions Pricing Matrix window opens.
3. If you chose the percentage-of-list inventory method, the Pricing Matrix window opens with a drop-down list. (Percentage-of-list inventory method allows you to mark down the list price of inventory items in addition to marking up the cost of payables and manual transactions.) Select Payables & Manual Markup as the transaction source and choose OK.
4. Complete the following fields, as necessary.
   • Pricing Matrix Name
     You can choose an existing pricing matrix or create a new pricing matrix name in this field.
   • Pricing Code
     Used to differentiate markup percentages and cost ranges. A different code can be assigned to each markup percentage grouped under the same price matrix name. For example, a pricing matrix named Preferred could include pricing code A, having a 200% markup for items with a cost in the $0.01 to $2,000.00 range. Pricing code B could have a 150% markup for items with a cost in the $2,000.01 to $4,000.00 range, and so on. If you enter information for a pricing code that already appears in the scrolling window, data initially associated with that code is replaced with new data when the pricing code information is saved.
   • Pricing Markup Percent
     This is the amount that the payable, manually added cost, or inventory item is increased by to calculate the billing amount.
   • Pricing Description
     Enter a pricing description.
   • Starting/Ending Cost
     The Starting/Ending Cost field is used to establish the cost range for the pricing code.
   • Choose Save to save the code and add its information to the scrolling window. To delete or edit a pricing code, double-click it in the scrolling window. The text fields in the data entry area of the window fill in with the pricing matrix information. Choose Delete to delete the selected pricing code, clear the data entry fields, and remove the record from the scrolling window.

Creating an inventory price matrix markdown

If you selected the percentage-of-list inventory pricing method in the Invoice Options window, then you can mark down the cost of an inventory item from the list price established in the Inventory module. (Choosing the markup-on-cost invoice option only allows marking up inventory items.)
Inventory pricing matrix markdowns can be established and used to calculate the billing amount for inventory items used for a service call. By selecting a price matrix in the Location window, you establish the billing rate for non-labor costs for that location. In the Service Invoicing module, the price matrix markdown schedules apply only to inventory transactions and appear in the materials cost category. As costs are accumulated through Inventory, the billing amount is calculated using the price matrix specified for the customer's location.

...