How to create a % Markup – Current Cost Contract for a range of pre-defined costs

Subject:

The steps here describe how to create a % Markup – Current Cost Contract for a range of pre-defined costs.

In this example, the percent markup is defined based on a few ranges that the Current Cost values fall within: 

Current Cost Range                                         % Markup – Current Cost

 

Min                        Max                                       Percentage

$0.00                     $10.00                                   1.80

$10.01                   $50.00                                   1.50

$50.01                   $500.00                                 1.45

$500.01                 $9,999,999.00                     1.40

You can view the Current Cost per Item in SmartList by adding the Current Cost column to the default Inventory Items report.

Resolution:

These are the steps to follow: 

Option 1: Use an Item Number range with details.

1. Go to Cards | Omni Price | Item Filter.
2. In the Item Filter Maintenance window, enter a Filter ID and Filter Description.
3. Select Item Number for the Ranges field.
4. Enter a range in the From and To fields that would encompass all Item Numbers needed. For example, if you need Item Numbers 1, 3, 7, & 8, you would enter a range from 1 to 8.
5. Click Insert.
6. Select the Item Number range that was just inserted, and then click Details.
7. In the Item Filter Details window, select the specific Item Numbers.
8. Click OK.
9. Click Save.
10. Go to Cards | Omni Price | Contract.
11. Create a new Contract ID or select an existing one.
12. For the Item Selection field, select User Item Filter for all Items.
13. For the Item Filter ID field, select the filter you created above.
14. Then enter the Item pricing information in the Contract Maintenance pricing section of the window.
15. Click Save.

Option 2: Use a field available in the Item Filter Maintenance Ranges drop-down menu.

For the following example, the Price Group field (located in the Item Price List Maintenance window) will be used. Note: If you are currently using this field for other purposes, you can use the same logic below while choosing another field available in the Item Filter Maintenance Ranges drop-down menu.

1. Go to Microsoft Dynamics GP | Tools | Setup | Inventory | Price Group.
2. Create four Price Groups. Note: You can make them more specific or leave them general for future percent markup changes.
   1. Price Group: Range1; Description: Range 1 % Markup Current Cost
   2. Price Group: Range2; Description: Range 2 % Markup Current Cost
   3. Price Group: Range3; Description: Range 3 % Markup Current Cost
   4. Price Group: Range4; Description: Range 4 % Markup Current Cost

3. Go to Cards | Inventory | Price List.
4. Assign each Item a specific Price Group for the Current Cost range they fall into.
5. Go to Cards | Omni Price | Item Filter.
6. In the Item Filter Maintenance window, enter a Filter ID and Filter Description for the first range.
7. Select Price Group for the Ranges field.
8. Enter the Range1 Price Group in both the From and To fields.
9. Click Insert.
10. Click Save.
11. Repeat Steps 6-10 for the next three ranges.
12. Go to the Cards | Omni Price | Contract.
13. Create a new Contract ID or select an existing one.
14. For the Item Selection field, select User Item Filter for all Items.
15. For the Item Filter ID field, select the Filter ID you created for the first range.
16. Then enter the Item pricing information in the Contract Maintenance pricing section of the window.
17. Click Save.