Chapter 49: Entering Finished Goods Information (WFGD)

Overview: A finished good is an item that requires assembly prior to picking and packing and is comprised of one or more component items that may also be sold individually, or of raw materials that are used only as components of a finished good. An item record must exist for each component item, including raw materials (so that you can track inventory and usage).

When an Order Entry operator places an order for a finished good, the components of the finished good do not appear on the Order Entry screen, only the finished good item.

Unit demand (units ordered) is tracked at the finished goods level. Dollar demand is tracked at the finished goods level. For example: the finished good is a sketch kit and its component items are 1 drawing pad, 3 charcoal pencils and 1 erasure. A customer orders the sketch kit for $20.00. Units ordered for the finished good increase by 1, and dollars ordered increase for the finished good by $20.00.

To assemble a finished good, you must perform a make up finished good inventory transaction (transaction code = M) which increases the quantity of the finished good and decreases the quantity of its component items. You can also reserve component items while you assemble the finished good through the finished good work order process. See Warehousing Part B: Performing Inventory Transactions for more information on the make up finished good inventory transaction and on the finished good work order process.

In this chapter:

Work with Finished Goods Screen

Create Finished Good Screen

Work with Finished Good Component Items Screen

Change Finished Good Component Item Screen

Display Finished Good Component Items Screen

Updating the Cost of a Finished Good

Finished Good Items Average or Standard Cost Updated Report

Work with Finished Goods Screen

How to display this screen: Enter WFGD in the Fast path field at the top of any menu or select Work with Finished Goods from a menu.

INR0231 DISPLAY Work with Finished Goods 2/16/98 9:29:52

The KL Mail Order Company

Opt Item COLR SIZE OTHR Description

Type options, press Enter.

4=Delete 5=Work with

FRUIT3 DELUXE FRUIT BASKET

SAMPLER9 SNACK SAMPLER

ART8 WATERCOLOR KIT

F3=Exit F6=Create F12=Cancel F21=Print list

F24=Select company

Field

Description

Item

The finished good item number.

Alphanumeric, 12 positions; optional.

Clr Size Width

The SKU elements.

Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); optional.

Description

The description of the item.

Alphanumeric, 40 positions; optional.

Screen Option

Procedure

Create a finished good

Press F6 to advance to the Create Finished Good Screen.

Delete a finished good

Enter 4 next to a finished good to delete it.

Note: Deleting a finished good does not delete the item or component items, just the association (link) between the two.

Work with finished good components

Enter 5 next to a finished good to advance to the Work with Finished Good Component Items Screen.

Create Finished Good Screen

Purpose: Use this screen to create a finished good.

How to display this screen: At the Work with Finished Goods Screen, press F6.

INR0232 ENTER Create Finished Good 2/16/98 15:22:24

The Mail Order Company

Finished Good item

F3=Exit F12=Cancel

Field

Description

Finished good

The finished good item/SKU. The item’s Kit type field must be set to F.

Item: alphanumeric, 12 positions; required.

SKU: one 14-position field (full SKU) or three 4-position fields (split SKU); required if the item has SKUs.

Work with Finished Good Component Items Screen

Purpose: Use this screen to add, change, delete, or display component items associated with a finished good (as defined by an F in the Kit type field for the item).

How to display this screen:

• Complete the Create Finished Good Screen.

• Enter 5 next to a finished good item at the Work with Finished Goods Screen.

• Enter 16 next to a finished good item at the Work with Items Screen or Work with SKUs Screen.

• Press F19 a finished good item at the Display Item/Warehouse Information Screen

INR0477 DISPLAY W/W Finished Good Component Items 11/12/02 16:49:18

EZK Mail Order

MOS12345 MOSAIC KIT GIFT SET

Opt Item COL SIZE WDTH Qty Avail (All Whs)

Type options, press Enter.

2=Change 4=Delete 5=Display

SEAGLASS BLUE 1 23

SEAGLASS PIECES FOR MOSAIC

SEAGLASS GRN 1 23

SEAGLASS PIECES FOR MOSAIC

GROUT 1 23

SANDED GROUT FOR MOSAIC

F3=Exit F12=Cancel

Field

Description

Item

A component item that makes up the finished good.

Alphanumeric, 12 positions.

Work with screen: required.

Change screen: display-only.

Clr Size Wdth

The SKU elements used to further define the item.

Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); required if the item has SKUs.

Qty

The number of items that are used to make up the finished good.

Numeric, 5 positions; required.

Avail

The total quantity available for the component item.

Note: If you advanced to this screen from the Display Item/Warehouse Information Screen, the available quantity reflects the selected warehouse only; otherwise, the quantity reflects all allocatable warehouses.

Numeric, 7 positions; display-only.

Screen Option

Procedure

Add a finished good component item

Enter the item code (and SKU information if the item has SKUs) to add the item as a component to the finished good. The item displays below the other component items in the center of the screen.

Change a finished good component item

Enter 2 next to a component item to advance to the Change Finished Good Component Item Screen.

Delete a finished good component item

Enter 4 next to a component item to delete it from the finished good.

Display a finished good component item

Enter 5 next to a component item to advance to the Display Finished Good Component Items Screen.

Change Finished Good Component Item Screen

To change: Enter 2 next to an item at the Work with Finished Good Component Items Screen to advance to the Change Finished Good Component Item screen. At this screen, you can change any information only the SKU and quantity. See Create Finished Good Screen for field descriptions.

Display Finished Good Component Items Screen

To display: Enter 5 next to an item at the Work with Finished Good Component Items Screen to advance to the Display Finished Good Component Items screen. You cannot change any information on this screen. See Create Finished Good Screen for field descriptions.

Updating the Cost of a Finished Good

Purpose: You can update the cost of a finished good when the cost of one or more of its component items changes by running a periodic function. This periodic function produces the Finished Good Items Average or Standard Cost Updated Report, which lists:

• finished goods the system has updated

• the cost of the finished good before the update

• the cost of the finished good after the update.

When you run this periodic function, the system also updates the General Ledger Interface file with the change in inventory valuation. See * = Change Average or Standard Cost for a discussion.

The periodic function that updates the cost of a finished good is called PHR0049. See System Operations Chapter 15: Executing Periodic Processes (EPRO) for more information on periodic processes.

ME05_05 CWDirect 18.0 August 2015 OTN