Handling Part Ownership on Shop Orders—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. |
Basic Data Setup
Discrete Manufacturing Overview Racing Engine
Purpose: The purpose of this exercise is to create the
basic data that is used in the Discrete Manufacturing exercises. This sets up
data for your site and needs to be done only once for the Discrete Manufacturing
course exercises.
- If you haven't done so already, set up your site so that it includes all
the Discrete Manufacturing data for racing engines.
General
exercise for Overview of Discrete Manufacturing Data
Inventory Locations
Purpose: The purpose of this exercise is to set up
inventory picking locations for running functionality isolated by site.
Windows:
Inventory Locations
- If you haven't done so already, create the inventory picking location
shown in the table below.
Site |
Location No |
Warehouse |
Location Name |
Location Group |
Your Site |
1 |
Main |
Main Warehouse |
30 |
Your Site |
1A |
Secondary |
Secondary Warehouse |
30 |
Your Site |
2C |
Sub |
Subassembly inv |
30 |
General
exercise for Entering Inventory Locations
Required Data
System Parameters
Purpose: The purpose of this exercise is to verify that
the system default for creating shop orders is set correctly for the main
exercises below.
Windows:
Parameters for Distribution and Manufacturing
- Verify that the value for Create SO in status Planned is Yes.
General
information about System Parameters
Inventory Part Balance - Company Owned Parts
Purpose: The purpose of this exercise is to ensure that
you have the correct quantities of company owned parts in stock to be able to do
the main exercises below.
Windows:
Inventory Part Currently On Hand
Receive Inventory Part
- Open the Inventory Part Currently On Hand window.
- Verify that you have company owned parts in stock, in at least the quantity shown in the
table below.
Site |
Location |
Part Number |
Part Description |
Quantity Available for Manufacturing |
Serialized? |
Your Site |
2C |
21-250 |
Fuel System |
1 |
Yes |
Your Site |
1 |
21-350 |
Fuel Tank |
5 |
No |
Your Site |
1 |
21-351 |
Carburetor |
5 |
Yes |
Your Site |
1 |
21-352 |
Fuel Pump |
5 |
No |
- If you do not have enough parts, for each part receive the
appropriate quantity into the inventory picking locations as indicated in the
table.
Note: For the serialized parts, you will need to define the serial
numbers when receiving parts into inventory. When generating a range of serial
numbers, the serial numbers generated can have either a prefix, a suffix, or
both added to the generated set of sequential numbers, so you should decide
which you prefer. The generated numbers do not retain leading zeros. To have
leading zeros, the zero characters must be added manually. The serial numbers
are stored in the IFS system as alphanumeric values. You may want to use your
initials followed by a dash as a prefix to make the serial numbers easy to
query.
General
exercise for Receiving Inventory Part
Inventory Part Balance - Customer Owned Parts
Purpose: The purpose of this exercise is to ensure that
you have the correct quantities of customer owned parts in stock to be able to
do the main exercises below.
Windows:
Inventory Part Currently On Hand
Purchase Part
Supplier for Purchase Part
Purchase Order
Register Purchase Order Arrivals
- Open the Inventory Part Currently On Hand window.
- Verify that you have customer owned parts in stock, in at least the quantity shown in the
table below.
Site |
Location |
Part Number |
Part Description |
Quantity Available for Manufacturing |
Serialized? |
Your Site |
1A |
21-350 |
Fuel Tank |
5 |
No |
Your Site |
1A |
21-351 |
Carburetor |
5 |
Yes |
Note: If you do not have enough parts, you will need to register
some basic data to enable that your company can receive parts from the customer,
if this has not been done previously.
- For the part 21-351, you will need to register a purchase part for your
site.
- For each part, create a supplier for
purchase part for your site and supplier C1000. This supplier ID represents the customer 1000, when shipping parts to our company.
Note: The
quickest way to do the above step is to duplicate the supplier for purchase part
record for this part and supplier for site 1.
- For each part create a purchase order
for the
appropriate quantity as indicated in the table, using supplier C1000. On the
purchase order line, verify that the value in the Ownership field is Customer Owned
and that the value in the Owner column is 1000.
- Release the purchase order.
- Receive the parts into the inventory picking locations as indicated in the
table. Note that part 21-351 is serialized.
Note: If you are not able to put the customer owned parts in a location
because some company-owned parts with the same part number already exist
there, then either move the company-owned parts or use a different location.
General exercise for Supplier for Purchase Part
General
exercise for Entering Purchase Orders
General
exercise for Reporting Arrival
General
exercise for Handling Serial and Lot/Batch Numbering
Main Exercise
Purpose: The purpose of this lesson is to show how to
define and handle part ownership on shop orders.
Windows:
Shop Order
Shop Order/Tracking and History
Shop Order/Material
Shop Order/ByProduct
Shop Order/Detail
Inventory Part Currently On Hand
Inventory Transaction History
Shop Order Costs
Customer 1000 has subcontracted our company (company 10), to
assemble the fuel system for racing engines because we have the proper
equipment to do the manufacturing. The customer owns both the finished product
and some of the components. We will manufacture the product, and bill the
customer for the work done and any components supplied by our company.
The exercises below must be performed in the order
listed. If you stop between exercises, it will be necessary to query for your
order and then start where you left off.
- Open the
Shop Order window and create a new record.
- If the value for Site is not your site, change the value to your
site.
- In the Part No. field, enter 21-250 as the part to be manufactured.
- In the Lot Size field, enter 5 for the quantity to be manufactured.
- Select the
Tracking and History
tab.
- In the Ownership list, click Customer Owned.
- In the Owner field, enter the desired customer ID 1000, or select
it from the List of Values.
- Save the information.
- Record the value that
was automatically generated for the Order No. field so that it will be easy for you
later to query for your shop
order.
Note: The Ownership field may have the values Company
Owned or Customer Owned. When the shop order product is customer
owned, the customer shown in the Owner field can only be changed if none
of the material or by-product lines are customer owned, since the owning
customer must be identical for all customer owned parts (the shop order product,
by-products and component material).
Note: The ownership for the component part 21-352 must be changed
because the customer is not providing this part.
- Select the
Material
tab.
- Observe that for each of the material lines, the value in the Ownership
and Owner fields are by default identical to that registered for the
shop order product on the
Tracking and History
tab.
- For the component 21-352, select the value Company Owned from the
list.
- Save the information. A warning message appears, asking if you still want
to save the record even though the ownership of this component part differs
from the ownership of the shop order product. Answer Yes.
Note: The Ownership field may have the values Company Owned,
Customer Owned or Supplier Loaned. For a single shop order, the
owning customer must be identical for all customer owned parts (shop order
product, by-products and component material).
Note: Steel sheeting is used as a part of the packaging material when
the fuel tank is shipped from the customer. This material must be returned to
the customer and it will be treated as a by-product to the shop order.
- Select the
Byproduct tab.
- Create a new record. Enter the part number 21-930, sheet steel.
- Observe that the value in the Ownership and Owner fields are
by default identical to that registered for the shop order product on the
Tracking and History
tab. Keep the values in these fields.
- Enter a value in the Qty per Unit field, which is the quantity of
by-products produced per shop order product manufactured.
- Save the information.
Note: The Ownership field may have the values Company Owned,
Customer Owned or Supplier Loaned. For a single shop order, the
owning customer must be identical for all customer owned parts (shop order
product, by-products and component material).
- Release the shop order.
General
exercise for Releasing Shop Orders
- Select the
Material
tab.
- Select the row for the 21-350 (fuel tank) component part. Right-click on
the row, and then click Manual Reservations.
- When the
Reservations window appears, verify that the
correct picking location is shown.
Note: Only inventory parts with ownership corresponding to
the ownership specified on the component material lines can be reserved or
issued to the shop order. In this case, the location 1A which contains part no.
21-350 that are customer owned should be shown.
- Enter 5 in the Qty Assigned field and save the information, to
reserve these parts to the shop order material line.
- Repeat steps 3-5 for the other two material lines, and verify that parts
with the correct ownership are reserved.
- Select the row for the 21-350 (fuel tank) component part. Right-click on
the row, and then click Manual Issues.
- When the Manual Issue Shop Order window appears, verify that
the correct picking location is shown.
- Enter 5 in the Qty to Issue field and save the information, to
issue these parts to the shop order material line.
- Repeat steps 7-9 for the other two material lines, and verify that parts
with the correct ownership are issued.
- Open the Inventory Part Currently On Hand window and query
for your site and the by-product part 21-930. Record the total quantity
available that is customer owned.
- Right-click anywhere in the header of the
Shop Order window,
point to Material Actions, and then click Manual Receive.
- In the first field in the Received Part area, pull down the list
and click Byproduct (instead of Shop Order). Verify that the
values of the other fields in the Received Part area have changed to
show the information for the by-product part.
- If no location records display in the table on the Inventory Receipt
tab, create a new record. Enter 25 in the Quantity Received field and
1A in the Location No field. If a record is displayed in the table,
enter 25 in the Quantity Received field for the displayed record.
Save the information.
- In the Inventory Part Currently On Hand window, query
again for your site and part number 21-930. Verify that the quantity
available for this part that is customer owned has increased by the quantity
received.
Note: The shop order should have a status of Started with no
operations reported, and all material reserved and issued. After reserving
serial numbers for the shop order product, you will automatically report the
operations at the same time as the shop order product is received.
- In the Proposed Loc field on the
Detail tab, enter
the value 2C if there is not already a value there.
- Reserve serial numbers for the serialized shop order product.
General
exercise for Handling Serial Numbers on Shop Orders
- Right-click anywhere in the header, point to Material Actions, and
then click Manual Receive to open the
Receive Shop Order
window.
- Right-click anywhere in the header of the
Receive Shop Order
window, and then click Build Tracked Structures. This function
creates a tracked structure for the shop order product, which is necessary
before you can receive the products.
- Right-click anywhere in the header, and
then click Shop Order Graphical As-Built Structure. Verify that the
structures are as you expect. Close the window.
- On the
Receive Shop Order
window, select the Auto Report Of Operations check box to indicate that the
necessary work on the operations should be reported automatically on receipt.
- On the
Serial Inventory Receipt tab (in the
Receive
Shop Order window), create a new record.
Note: First, you will attempt to receive the shop order product into a
location which already contains the part but which are company owned. In the
Required Data section of this exercise, part 21-250 that is company owned was
received into location 2C.
- Note that location 2C is automatically suggested. Keep this value.
- In the Serial Number field, select one of the reserved serial
numbers from the list of values.
-
Save the information. You will receive an error message informing you that
it is not possible to receive the part because the chosen location already
contains this part but that is not customer owned.
- Now change the value in the Location No field, and enter 1A
instead.
-
Save the information.
- Receive the remaining products.
- In the Inventory Part Currently On Hand window, query
again for your site and part number 21-250. Verify that the quantity
available for this part that is customer owned has increased by the quantity
received.
- Open the
Inventory Transaction History window and
query for your shop order. Study the information on the
General
tab for each record, and in particular note the values in the costs fields
and the Ownership field. Observe that there are no costs generated on
transactions due to inventory movements of customer owned parts.
Note: There will be a transaction created for movement of
parts in inventory with the inventory location identified in the Location No
field. The Quantity is displayed in three data fields. The first has a
value of '+' or '-' identifying the direction of movement the inventory is
in relation to the inventory location ( '+' means moving into the location and
'-' means moving out). The second field contains the numeric quantity for the
transaction, and the last field is the unit of measure for the part. The Transaction
Code field contains a value that indicates the type of transaction.
- Open the
Shop Order Costs window and query for your shop
orders. Study the available information on each of the tabs. Click the
WIP
Status tab on the
Shop Order Costs window. Verify that
only the company owned component parts have contributed to the value in the Material
Cost field.