Updating Product Family and Product Code—Exercises

IMPORTANT
It is extremely important that you set up and work within your own site to maintain your data integrity. If you work within any other site, you will compromise your own exercise data as well as the data of other students. Predictable exercise results require that your data be isolated in your own site.

Required Data

Creating Product Structure

Purpose: The purpose of this exercise is to show you the required data that is used in the exercises below.

Windows:
Copy Parts to Site
Product Structure
Inventory Part

Note: If you already have the racing engine parts in your site, use your existing parts. These parts all have part numbers with the format 20-nnn.

  1. If you have not yet already done so, copy inventory parts with Commodity Group 2 equal to 200 from Site 1 to your site.
  2. Copy product structures from site 1 to your site, one for Part 20–250 Fuel System and one for Part 20–260 Fuel System Formula
  3. For all parts, enter the product family and product code using the information in the table below (if not already done).
  4. Save your changes. 

Structure for Part 20–250 Fuel System

Part No Part Description Product Family Product Family Product Code Product Code Structure Level
20–250 Fuel System 30 Fuel System 320 Standard 0
20–350 Fuel Tank 30 Fuel System 320 Standard 1
20–351 Carburetor 30 Fuel System 320 Standard 1
20–352 Fuel Pump 30 Fuel System 320 Standard 1
20–451 Throttle Plate 30 Fuel System 320 Standard 2
20–452 Carburetor Housing 30 Fuel System 320 Standard 2
20–453 Carburetor Trigger 30 Fuel System 320 Standard 2
20–454 Spring, Carburetor 30 Fuel System 320 Standard 2
20–455 Screw, Carburetor 30 Fuel System 320 Standard 2
20–900 Lubricant 200 Engine 320 Standard 2

Structure for Part 20-260 Fuel System Formula

Part No Part Description Product Family Product Family Product Code Product Code Structure level
20–260 Fuel System Formula 30 Fuel System 310 Formula 0
20–360 Fuel Tank 30 Fuel System 310 Formula 1
20–361 Carburetor 30 Fuel System 310 Formula 1
20–362 Fuel Pump 30 Fuel System 310 Formula 1
20–451 Throttle Plate 30 Fuel System 320 Standard 2
20–462 Carburetor Housing 30 Fuel System 310 Formula 2
20–463 Carburetor Trigger 30 Fuel System 310 Formula 2
20–454 Spring, Carburetor 30 Fuel System 320 Standard 2
20–455 Screw, Carburetor 30 Fuel System 320 Standard 2
20–900 Lubricant 200 Engine 320 Standard 2

General exercise for Creating Inventory Part

General exercise for Copying Parts to Site

General exercise for Copy Product Structure

Main Exercise

Purpose: The purpose of this lesson is to show you how to update the product family and product code.

Windows:
Character and Numeric Value Defaults
 Update Product Family and Product Code
 Inventory Parts

Update Product Family and Product Code

  1. Open the Character and Numeric Value Defaults window.
  2. Query all data (F2), and verify that the character value is * (asterisk) for product family and product code. If desired, you can select different values.
  3. Open the Update Product Family and Product Code window.
  4. Enter your site.
  5. Click OK.
  6. Open the Inventory Part window, and query for the Fuel System product family.
  7. Verify that the parts connected to both structures have received the * (asterisk), or common, product code.