...

Creating a Price Matrix Markup

1. Select 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 selected 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 select OK.
4. Complete the following fields, as necessary.
   • Pricing Matrix Name
     You can select 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.
   • Select 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. Select Delete to delete the selected pricing code, clear the data entry fields, and remove the record from 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 Inventory Pricing Markdown Matrix window fill in are filled with the pricing matrix information. Select Delete to delete the selected pricing code, clear the data entry fields, and remove the record from the scrolling window.