Set up a new item and view pricing hierarchy

Set up a new item and view pricing hierarchy

Part 1: Create an item
1. Click the Open icon on the toolbar. The Select Form dialog box opens.
2. Type items in the Filter field.
3. Click the Items list item.
4. Click the OK button. The Items (Filter in Place) form opens.
5. Click the Filter in Place icon.
6. Click the New icon.
7. Type [your initials]My New Item in the Item field.
8. Type My New Pricing Item in the Description field.
9. Type EA in the U/M field.
10. Verify Material is selected from the Type drop-down list.
11. Click the Source drop-down arrow. 
12. Click the Purchased list item.
13. Click the Product Code drop-down arrow.
14. Click the PP list item. 
15. Click the Save icon. 
Part 2: Set up an item pricing method
1. Click the ellipsis.
2. Click the Pricing button. A dialog box opens with the message, “Not one Item Price exists for 
Item that has [Item: [your initials]-My New Item].” 
2. Click OK. The Item Pricing (Linked) form displays.
3. Verify [the current date] displays in the Effective Date field.
4. Type 100 in the Unit Price 1 field.
5. Delete [the value] in the Price Code field.
6. Click the Save icon.
Part 3: Create a customer
1. Click the Open icon on the toolbar.
2. Type customers in the Filter field.
3. Click the Customers list item.
4. Click the OK button. The Customers (Filter in Place) form opens.
5. Click the Filter in Place icon. 
6. Click the New icon.
7. Type [your initials]? in the Customer field. 
8. Type Best Customer in the Name field. 
9. Type 1762 Wonderful Avenue in the Address [1] field.
10. Type Columbus in the City field.
11. Click the Prov/St drop-down arrow.
12. Click the OH list item.
13. Type 43210 in the Postal/Zip field.
14. Click the Bank Code drop-down arrow.
15. Click the BK1 list item.
16. Click the Credit tab.
17. Type 30000 in the Credit Limit field.
18. Type 30000 in the Order Credit Limit field.
19. Click the Save icon.
Part 4: Assign price codes
1. Click the Codes tab.
2. Click the Price Code drop-down arrow.
3. Click the CP1 list item.
4. Click the Save icon. 
5. Click the Item Pricing tab to display the Item Pricing form.
6. Click the Price Code drop-down arrow.
7. Click the IP3 list item. 
8. Click the Save icon.
Part 5: Update price formula
1. Click the Open icon on the toolbar.
2. Type price formulas in the Filter field.
3. Click the Price Formulas list item.
4. Click the OK button. The Price Formulas (Filter in Place) form opens.
5. Type G in the Price Formula field. 
6. Click the Filter in Place icon.
7. Verify USD displays in the Currency field
6. Verify Unit Price 1 displays in the Base field.
6. Click the Amount drop-down arrow. 
7. Select the Amount list item.
8. Type 0 in the Value field.
9. Update price breaks with the data in the following table:
Break Qty             Base                   Amount/ Percent                   Value
1                         Unit Price 1             Amount                               200
50                       Unit Price 1             Amount                               150
100                     Unit Price 1             Amount                               100
150                     Unit Price 1             Amount                                   0
200                     Unit Price 1             Amount                                  -5
10. Click the Save icon. 
Part 6: Add a price matrix
1. Click the Open icon on the toolbar.
2. Type price matrix the Filter field.
3. Click the Price Matrix list item.
4. Click the OK button. The Price Matrix (Filter in Place) form opens.
5. Type G in the Price Formula field,
6. Click the Filter in Place icon. Note: the Customer Price Code is CP1 and the Item Price Code is 
IP3. 
Part 7: Create a customer order
1. Click the Open icon on the toolbar. 
2. Type customer orders in the Filter field.
3. Click the Customer Orders list item.
4. Click the OK button. The Price Formulas (Filter in Place) form opens.
5. Click the Filter In Place icon.
6. Click the New icon.
7. Click the Customer drop-down arrow.
8. Click the <your initials>Best Customer list item. 
9. Click the Save icon. 
Part 8: Add a customer order line
1. Click the ellipsis.
2. Click the Lines button. The Customer Order Lines (Linked) form displays.
23 Lesson 2: Pricing Hierarchy
3. Type [your initials]* in the Item field.
4. Select the [your initials] My new item list item.
5. Type 4 in the Qty Ordered field. Note: You can change the quantity to match different price 
breaks and click Reprice to see the prices change.
6. Write down the Order Number ______________.
7. Click the X on the Customer Order Lines (Linked) form.
Part 9: Create a customer contract and customer contract pricing
1. Click the Open icon on the toolbar. The Select Form dialog box opens.
2. Type customer contracts in the Filter field.
3. Click the Customer Contracts list item.
4. Click the OK button. The Customer Contracts (Filter in Place) form opens.
5. Click the Filter In Place icon.
6. Click the New icon.
7. Type [your initials]* in the Customer field. 
8. Click the Customer drop-down arrow.
9. Select the [your initials] Best Customer list item.
10. Type [your initials] * in the Item field. 
11. Click the Item drop-down arrow.
12. Click the [your initials] My New Item list item.
13. Type 1 in the Rank field.
14. Click the Save icon.
15. Click the Prices button. The Customer Contract Prices (Linked) form opens.
16. Verify [the current date] in the Effective Date field.
17. Type 140 in the Contract Price field. 
18. Click the Save icon. 
Part 10: View pricing
1. Click the Open icon on the toolbar. 
2. Type pricing in the Filter field.
3. Click the Pricing list item.
4. Click the OK button. The Pricing form opens.
5. Type [your initials]* in the Customer field. 
6. Click the Customer drop-down arrow. 
7. Select the [your initials] Best Customer list item.
8. Type [your initials] * in the Item field. 
9. Click the Item drop-down arrow.
10. Select the [your initials] MyNewItem list item.
11. Click the Pricing button. The Contract Price now displays $140 as the contract price.
12. Click the Window icon
13. Select the Close All list item

    • Related Articles

    • Set up discounts and view the price

      1. Click the Open icon on the toolbar. The Select Form dialog box opens. 2. Type customers in the Filter field. 3. Click the Customers list item. 4. Click the OK button. The Customers (Filter in Place) form opens. 29 Lesson 2: Pricing Hierarchy 5. ...

    • Set up lot tracking for an item

      Part 1: Set lot track and backflushing for [your initials]-PH-20000 1. Click the Open icon on the toolbar. 2. Type items in the Filter field. 3. Click the Items list item. 4. Click the OK button. The Items (Filter in Place) form opens. 5. Type [your ...

    • Apply item stockroom location to the new items

      1. Click the Open icon on the toolbar. 2. Type item stock in the Filter field. 3. Click the Item Stockroom Locations list item. 4. Click the OK button. The Item Stockroom Locations (Filter in Place) form opens. 5. Type [your initials]* in the Item ...

    • Set up serial number tracking for an item

      Part 1: Select Lot Track and S/N Track for [your initials]-SL-10000 1. Click the Open icon on the toolbar. The Select Form dialog box opens. 2. Type items in the Filter field. 3. Click the Items list item. 4. Click the OK button. The Items (Filter in ...

    • Set up product markup

      Part 1: Setting up markup 1. Click the Open icon on the toolbar. The Select Form dialog box opens. 2. Type items in the Filter field. 3. Click the Items list item. 4. Click the OK button. The Items (Filter in Place) form opens. 5. Type [your ...