Working with Inventory Transactions in Batch Mode (WITB)

Purpose: Use the Work with Inventory Transactions/Batch menu option to enter transactions that require review and approval before you process them. Although your company can create additional transaction types, inventory transactions typically include:

• adjusting the on-hand quantity of an item (such when the item has been damaged)

• returning an item to the vendor

• transferring items between warehouses

• increasing the quantity of a finished good and decreasing the quantity of its components

You can also work with inventory transactions in immediate mode. See Working with Inventory Transactions in Immediate Mode (WITI).

Note: You cannot process an inventory transaction in immediate mode for an item/SKU if there is an open batch with a transaction for that same item/SKU. You need to delete or process the batch before you can process any other transactions for the item/SKU.

In this topic:

Understanding Batch Processing

Warning about Conflicting Jobs

Work with Inventory Trans Batches Screen

Change Item Information Batch Screen

Inventory Transaction Codes and Reasons

Create Item Transaction Batch Window

First Inventory Transactions Screen (Line Entry)

Second Inventory Transactions Screen (Full Screen Entry)

Inventory Transactions/Horizontal Entry Screen 1

Inventory Transactions/Horizontal Entry Screen 2

Enter Serial Numbers Screen

Review Inventory Transactions Screen

Change Inventory Transaction Screen

Display Inventory Transactions Screen

Understanding Batch Processing

Batch mode process: Use batch mode to enter large numbers of inventory transactions and hold them until they are approved. Batch processing may consist of the following steps:

1. Someone identifies an item that requires a transaction. For example, an item needs to be moved to another warehouse.

2. This person completes any necessary paperwork.

3. A data entry person takes the paperwork for several transactions and enters them into the system.

4. A supervisor checks the entry and approves and processes the batch, leaves the batch as is until more transactions are added to it, or puts the batch on hold.

You can change the status of the batch as many times as you need. No updates take place until you choose to process the batch.

Batch statuses: Possible batch statuses are:

Open--The status of a batch when you first create it. An open batch is available for entry or change.

Active--Indicates that someone is currently working with this batch. The batch is locked to other users until this person is done.

Hold--No activity can take place against a held batch. The batch must be released before anyone can work with it.

Additionally, you might see a batch in one of the following statuses for a brief time.

Printing--The batch is currently being printed.

Submitted--The batch has been submitted for processing; it is no longer available for activity.

Steps in the process: There are several approval steps that must take place while you are working on a batch.

Release--Release the batch from "hold" to make it accessible for change or entry.

Approve--Approve a batch to make it eligible for processing.

Process--Release the batch for system processing. The system performs the inventory transactions and updates, then deletes the batch.

Warning about Conflicting Jobs

A warning pop-up window displays automatically when you select this option if Pick Slip Generation or Location Replenishment is active (in the Active Procedures file).

Active Procedure Warning

Pick Slip Generation is active.

Press ENTER to continue.

F12=Cancel

Active Procedure Warning

Replenishment is active.

Press ENTER to continue.

F12=Cancel

Reason: The warning pop-up window displays because each of these options affect inventory at the location level in the warehouse, as does the current option you are trying to use.

Responding to the warning: Press Enter to use the option anyway, or press F12 to perform the inventory transaction by batch at a later time when the other jobs are finished running.

Note: The warning pop-up window(s) displays again if you entered a new inventory transaction, then used option 9 to process it. You can press Enter to continue or F12 to wait to process the transaction until the conflicting job has finished.

Work with Inventory Trans Batches Screen

Purpose: Use this screen to create a new batch or select a batch to work with. See Working with Inventory Transactions in Batch Mode (WITB) and Understanding Batch Processing for more information.

How to display this screen: Enter WITB in the Fast path field at the top of any menu or select Work with Inventory Transactions/Batch from a menu.

INR0010 DISPLAY Work with Inventory Trans Batches 10/07/98 11:13:08

The KL Mail Order Company

Opt Batch # Sts Created On Created By Approved On Approved By

Type options, press Enter.

2=Change 3=Hold 4=Delete 5=Work with 6=Release 7=Approve 8=Print

9=Process

117 O 4/10/98 COMMWARE

135 O 9/14/98 COMMWARE

136 O 9/14/98 COMMWARE

138 O 9/14/98 COMMWARE

143 O 9/25/98 COMMWARE

164 O 10/07/98 KLETENDRE

F3=Exit F6=Create F12=Cancel F24=Select company

Field

Description

Batch #

The number of the batch you want to see.

Numeric, 7 positions; optional.

Sts (Status)

The current status of the batch.

Enter a valid status to display batches that match your entry.

Valid statuses are:

A: Active

H: Held

O: Open

P: Printing

S: Submitted

Alphanumeric, 1 position; optional.

Created on

Creation date of the batch.

Numeric, 6 positions; MMDDYY format, optional.

Created by

User ID of the person who created the batch. You must enter an exact match. The list includes only the ID you specify.

If you enter the name and information in some other field, the system displays only those batches created by that person that meet all other qualifications.

Alphanumeric, 10 positions; optional.

Approved on

The approval date for the batch you want.

Numeric, 6 positions (MMDDYY format), optional.

Approved by

User ID of the person who approved the batch. You must enter an exact match. The list includes only the ID you specify.

Alphanumeric, 10 positions; optional.

Screen Option

Procedure

Create a batch

Press F6 to create a batch. See Create Item Transaction Batch Window.

Change a batch

Enter 2 next to a batch to advance to the Change Item Information Batch Screen.

Hold a batch

Enter 3 next to the batch. The system changes the status of the batch to H. No one can work on this batch until the status is changed back to O (open).

In order to change the status from held back to open, you must have the authority to release the batch.

Delete a batch

Enter 4 next to the batch you want to delete.

Work with a batch

Enter 5 next to the batch you want to work with. See Create Item Transaction Batch Window.

Release a batch

Enter 6 next to the batch. The system changes the batch's status to O. A batch must be open before it can be worked on, approved, and processed. You can release a batch only if it is on hold.

Approve a batch

Enter 7 next to the batch you want to approve. The system changes the batch's status, updates the Approved on field with today's date, and updates the Approved by field with your user ID. Note that this action enables a batch to be processed, but the actual processing does not take place until you type a 9 next to the batch.

Print a batch

Enter 8 next to the batch you want to print.

Process a batch

Enter 9 next to the batch you want to process. This is the final step in batch processing. The batch must be approved before the system allows it to be processed. Once done, the batch is removed from the screen.

Change Item Information Batch Screen

Purpose: To change the date a batch was approved, enter 2 next to a batch at the Work with Inventory Trans Batches Screen.

INR0014 CHANGE Change Item Transaction Batch 10/07/98 8:07:43

KAL Company

Batch number . . . : 258

Status . . . . . . : A

Approved on . . . . 100798

Approved by . . . . KLETENDRE

Created on . . . . : 10/06/98

Created by . . . . : KLETENDRE

F3=Exit F12=Cancel

Field

Description

Approved on

The approval date for this batch of inventory transactions. This date, which is required for batch processing, is updated by the system when you use option 7 to approve a batch on the Work with Inventory Trans Batches Screen. You can change the approval date if the batch was approved on a different date. The approval date has no effect on system processing.

Numeric, 6 positions (MMDDYY format), required.

Approved by

The User ID of the person who approved the batch. The system updates this field when you use option 7 to approve a batch on the Work with Inventory Trans Batches Screen.

Alphanumeric, 10 positions; required.

Inventory Transaction Codes and Reasons

Types: There are two types of codes used during inventory transactions: inventory transaction codes and inventory transaction reason codes. Both are created by your System Administrator according to your company's needs.

Transaction codes: Inventory Transaction codes tell the system:

• whether the transaction has a positive (+) or negative (-) effect on inventory

• the General Ledger account number to updated as a result of this transaction

• whether a reason code is required

Certain inventory transaction codes that are delivered with the system are available for batch inventory transactions. You can also create your own codes. You cannot delete the system-delivered codes; however, you can change the General Ledger account associated with a code, or whether a reason code is required.

The table below lists the system-supplied codes.

Code

Description

Effect on Inventory Levels

A

Adjustment

Increases on-hand if you enter a positive quantity.

Decreases on-hand amount if you enter a negative quantity.

G

Item-to-item transfer

Increases on-hand amount of the target item.

Decreases on-hand amount of the source item.

M

Make Up Set

Increases on-hand amount for the finished good item.

Decreases on-hand amount for the components.

T

Transfer

Increases on-hand amount in the target warehouse/location.

Decreases on-hand amount in the source warehouse/location.

V

Return to Vendor

Decreases on-hand amount if you enter a positive quantity.

Increases on-hand amount if you enter a negative quantity.

O

On-hand

Overrides on-hand amount to the amount you entered.

Note: Item-to-item transfers (G) and resets to on-hand quantity (O) are not allowed if you use FIFO Costing.

For a discussion of the general ledger postings for each of these transactions, see Accounts Payable General Ledger Overview.

Transaction reasons: Transaction reason codes describe why a specific transaction is being performed. You can establish these codes through the Work with Inventory Transaction Reasons menu option. You can specify whether a reason is required for each inventory transaction type.

For more information: See Work with Inventory Transaction Codes (WITC), and Work with Inventory Transaction Reason Codes (WIT1).

Create Item Transaction Batch Window

To create: Press F6 at the Work with Inventory Trans Batches Screen.

Create Item Trans Batch

Batch number . . . : 149

Created on . . . . : 10/07/98

Created by . . . . : KLETENDRE

*** Press Enter to create ***

F3=Exit

Select entry method: The three screen formats available for batch inventory entry are:

Line screen entry--Allows you to enter or modify a single line at a time. The system validates each line upon entry. You advance to line entry as the default; from here you can select other entry formats. See First Inventory Transactions Screen (Line Entry).

Full screen entry--Facilitates data entry when you are working from a form and do not require immediate validation of each line as you enter it. This format is appropriate if you are entering transactions that all occurred in the same "from" warehouse and you do not need to enter a General Ledger account number or a company number. See Second Inventory Transactions Screen (Full Screen Entry).

Horizontal screen entry--Facilitates entering the same transaction for multiple SKUs of an item. Once you enter the item, first SKU element, and information about the transaction you want to enter, you advance to a second screen with all the SKUs for the item. You cannot use horizontal entry for warehouse or location transfers, or for items that do not use all three SKU elements. See Inventory Transactions/Horizontal Entry Screen 1.

First Inventory Transactions Screen (Line Entry)

Description: Line screen entry allows you to enter a single item at a time. As you enter each item, the system validates your entries, and adds each transaction line below the entry fields.

How to display this screen: This screen displays automatically when you create a batch (by pressing F6) , or when you select the option to work with a batch (by entering 5 next to an existing batch) at the Work with Inventory Trans Batches Screen.

INR0701 DISPLAY Inventory Transactions 12/23/98 8:16:22

EZK Mail Order

Batch# . . . : 260 0 Total Quantity

--- From --- ------ To ------

Cde Item COLO STYL SIZE Quantity Whs Location Cmp Whs Location Reas

40 555

Id# G/L Acct# . PO#

F3=Exit F7=Full screen entry F9=Review batch F12=Cancel

F14=Horizontal entry F22=User defined option

No data to display.

Field

Description

Batch#

The number of the batch you are working on.

Numeric, 7 positions; display-only, assigned by the system.

Total quantity

The total number of units entered in the batch.

Numeric, 7 positions; display-only.

Cde (Code)

A code used during inventory transactions to identify the type of transaction being performed. These codes are defined in and validated against the Inventory Transaction Code file. The following system-defined codes are available in batch inventory transaction processing:

A: Adjustment

M: Make Up Finished Good

O: On-hand

T: Transfer

V: Return to Vendor

You can also create and use your own codes. See Inventory Transaction Codes and Reasons.

Alphanumeric, 1 position, required.

Item

A code that represents a unit of inventory. Item codes are defined in and validated against the Item file.

Alphanumeric, 12 positions; required.

Item description (Unlabeled field below the item on the line entry screen)

The description associated with the item. This field displays if the Display Item Description (D45) system control value is set to Y.

Alphanumeric, 40 positions; display-only.

SKU (Stock keeping unit)

The item's unique characteristics, such as its size and color. SKU codes are defined in and validated against the SKU file.

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

Quantity

The number of units that this transaction affects. For an adjustment (A code), or return to vendor (V) you can enter a positive or negative quantity. To enter a negative quantity, use Field Minus on the numeric keypad.

Note: You cannot enter a transaction that will make the on-hand quantity negative.

Numeric, 8 positions; required.

Note: A transfer transaction (T code) requires that you fill in the warehouse and location of the item (the From fields), and the location you are transferring the item to (the To fields), but for all other transactions only fill in the From fields. If you are performing a transfer, the From Item Location record must exist.

-- From Fields --

Whs (Warehouse)

A code for the warehouse where the item is located. Warehouse codes are defined in and validated against the Warehouse file; see Creating and Maintaining Warehouses (WWHS).

The warehouse defined in the Default Warehouse (A04) field of the System Control file defaults, but you can override it.

Numeric, 3 positions; required.

Location

The code for the area of the warehouse that contains the item. Press Enter to display a default location, determined by the following system control values:

Default Primary Location (C05)): defines whether the primary location defined in the SKU file defaults if the specified warehouse is the item warehouse defined in the SKU file.

Default Primary Location from an Item Warehouse (G06): defines whether a primary location for the item in any specified warehouse defaults; in this case the system will default the first primary location, in alphanumeric order, for the item in the specified warehouse. This system control value overrides Default Primary Location (C05).

If the system cannot find a primary location for an item in the specified warehouse, an error message similar to the following displays:

No Default Location was found. Please enter a Location.

 

The location code is validated against the Location file and the Item Location file. If you do not have a record of this item in this location, you can create it if you have proper authorization.

Typically the location code is composed of a single alphanumeric character for Zone, and two numbers each for Aisle, Shelf, and Bin. For instance, the location A010201 indicates:

Zone Aisle Shelf Bin

A 01 02 01

Alphanumeric, 7 positions; required.

--To Fields--

Cmp (Company)

A code for the company to receive the item. Your current company defaults.

Numeric, 3 positions, required.

Whs (Warehouse)

A code for the warehouse to receive the item.

Numeric, 3 positions; required.

Location

The code representing the area within the warehouse to receive the item. Location codes are defined in and validated against the Location file and the Item Location file. If the item location does not exist, you can create it if you have the proper authorization.

An error message similar to the following displays if you enter a location whose location class does not match the location class defined for the item and the Allow Location Class Edit in Inventory Transaction (F86) system control value is set to Y or blank:

Item is not compatible with Location.

 

Typically the location code is composed of a single alphanumeric character for Zone, and two numbers each for Aisle, Shelf, and Bin. For instance, the location A010201 indicates:

Zone Aisle Shelf Bin

A 01 02 01

Alphanumeric, 7 positions; required.

Reas (Reason)

A code for a reason to perform an inventory transaction. Reason codes are defined in and validated against the Transaction Reason Code file. Typical reasons could be that the item is damaged, miscounted, etc. You can also create and use your own codes. See Inventory Transaction Codes and Reasons.

Numeric, 2 positions; may be required depending on the type of transaction.

ID#

The identification number or text associated with this inventory transaction. This information appears in inventory transaction history; see Display Inventory Transaction History (DITH).

Alphanumeric, 10 positions; optional.

G/L Acct# (General Ledger account number)

The General Ledger account number to which this transaction will post. The extended cost of the item posts here. General Ledger account numbers are defined in and validated against the General Ledger file; see Accounts Payable Working with G/L Accounts (WGLA).

Authority to this field is controlled by the Secure G/L Number Field Access (A84) secured feature. If you do not have proper authority, this field is display-only.

Numeric, 8 positions; optional.

PO#

The purchase order number to associate with the inventory transaction history and with a FIFO layer, if you use FIFO Costing.

The system validates that the item for the transaction appears on the purchase order whose number you enter; otherwise, an error message displays.

You can enter a purchase order number only for an adjustment (A) transaction, and only if you have the proper authority. Authority to this field is controlled by the Allow Entry of PO Number in Inventory Transactions (A86) secured feature.

Numeric, 7 positions; optional.

Instructions:

1. Complete the fields. If you need to enter a negative quantity, use Field Minus on the numeric keypad.

2. Once the transaction is accepted, it appears below the entry lines, and the system:

• creates an inventory transaction work record

• sets the Pending transaction flag for the item location to Y

• increases the Pending transaction quantity for the item location by the transaction quantity

 

Note: You cannot process an inventory transaction in immediate mode for an item/SKU if there is an open batch with a transaction for that same item/SKU. You need to delete or process the batch before you can process any other transactions for the item/SKU.

Serial numbers: If the transaction affects the total on-hand quantity for a serial numbered item within a warehouse, you advance to the Enter Serial Numbers Screen.

Screen Option

Procedure

Work in full screen mode

Press F7 to advance to the Second Inventory Transactions Screen (Full Screen Entry).

Review the batch

Press F9 to advance to the Display Inventory Transactions Screen.

Work in horizontal mode

Press F14 to advance to the Inventory Transactions/Horizontal Entry Screen 1.

Second Inventory Transactions Screen (Full Screen Entry)

Purpose: Use full screen entry to enter a batch of items in the same "from" warehouse in a single step. This screen differs from the Line Entry screen in that it does not provide a Company field in the To locations or provide a General Ledger Account number field.

How to display this screen: Press F7 at the First Inventory Transactions Screen (Line Entry).

INR0700 ADD Inventory Transactions 2/22/00 8:49:13

EZK Mail Order

Batch# . . . . : 366

From warehouse . 2

- From - --- To ----

Cde Item COL SIZE WDTH Qty Locat Whs Locat Rsn Id#

PO#

PO#

PO#

PO#

PO#

PO# +

F3=Exit F8=Line entry F9=Review batch F12=Cancel

F22=User defined option

Field descriptions: The code in the From warehouse field defaults from the Default Warehouse (A04) system control value, but you can enter a different warehouse code for these transactions.

For an explanation of the other fields on this screen, see the field descriptions in First Inventory Transactions Screen (Line Entry).

Instructions:

1. Complete the fields. Use Field Minus on the numeric keypad to enter a negative quantity.

2. Once the transactions are accepted, they are removed from the screen, and the system:

• creates an inventory transaction work record

• sets the Pending transaction flag for the item location to Y

• increases the Pending transaction quantity for the item location by the transaction quantity.

 

Note: You cannot process an inventory transaction in immediate mode for an item/SKU if there is an open batch with a transaction for that same item/SKU. You need to delete or process the batch before you can process any other transactions for the item/SKU.

Serial numbers: If the transaction affects the total on-hand quantity for a serial numbered item in your warehouse, you advance to the Enter Serial Numbers Screen.

Screen Option

Procedure

Work in full screen mode

Press F8 to enter inventory transactions using the Second Inventory Transactions Screen (Full Screen Entry).

Review the batch

Press F9 to advance to the Display Inventory Transactions Screen.

Inventory Transactions/Horizontal Entry Screen 1

Purpose: Use horizontal entry to enter the same inventory transaction for multiple SKUs of an item. This entry mode is available only if:

• you use a split SKU

• the item uses all three SKU elements

• you are entering an adjustment, reset to on-hand, or return to vendor

How to display this screen: Press F14 at the First Inventory Transactions Screen (Line Entry). This is the first of 2 screens.

INR0105 ENTER Inventory Transactions/Horizontal Entry 12/23/98 17:02:21

EZK Mail Order

Warehouse . . . . . . . : 2

Batch number . . . . . . : 304

Item . . . . . . . . . . . CLR . . :

Transaction code . . . . .

Total quantity . . . . . .

Reason . . . . . . . . . .

Identification # . . . . .

G/L Account# . . . . . . .

PO# . . . . . . . . . . .

F3=Exit F12=Cancel

Field

Description

Warehouse

The warehouse that contains the item. Warehouse codes are defined in and validated against the Warehouse file; see Creating and Maintaining Warehouses (WWHS).

Numeric, 3 positions; required.

Item

The code for the item. Items are defined in and validated against the Item file.

Alphanumeric, 12 positions; required.

SKU (Stock keeping unit)

The first SKU element, such as color.

Alphanumeric, 4 positions; required.

Transaction code

A code used during transactions; validated against the Inventory Transaction Codes file. Valid codes for horizontal entry are:

A: Adjustment

O: On-hand

V: Return to Vendor

See Inventory Transaction Codes and Reasons.

Alphanumeric, 1 position; required.

Total quantity

The total transaction quantity for all SKUs for the item.

Numeric, 7 positions; required.

Reason

A code that indicates the reason that the transaction is taking place. Not all transaction codes require reasons. Reason codes are defined in and validated against the Transaction Reason file.

See Inventory Transaction Codes and Reasons.

Numeric, 2 positions; may be required for some transactions.

Identification #

The identification number or text associated with this inventory transaction. Displayed in Display Item Transaction History; see Display Inventory Transaction History (DITH).

Alphanumeric, 10 positions; required.

G/L Account# (General Ledger account number)

The General Ledger number to which this transaction will post The extended cost of the item posts here. General Ledger account numbers are defined in and validated against the General Ledger file; see Accounts Payable Working with G/L Accounts (WGLA).

Numeric, 8 positions; optional.

PO#

The purchase order number to associate with the inventory transaction history and with a FIFO layer, if you use FIFO Costing.

The system validates that the item for the transaction appears on the purchase order whose number you enter; otherwise, an error message displays.

You can enter a purchase order number only for an adjustment (A) transaction, and only if you have the proper authority. Authority to this field is controlled by the Allow Entry of PO Number in Inventory Transactions (A86) secured feature.

Numeric, 7 positions; optional.

Complete each required and any optional fields and press Enter again to advance to the Inventory Transactions/Horizontal Entry Screen 2.

Inventory Transactions/Horizontal Entry Screen 2

Purpose: Use this screen to indicate how to distribute the total quantity for the inventory transaction (defined in the previous screen) across the SKUs of the item.

The screen is laid out as follows:

• The top of the screen contains header information, such as the warehouse, batch, item number, the primary SKU, reason code, total quantity, and the item description. These are all display- only fields.

• The left side of the screen lists the characteristics associated with the second SKU element; the row in the middle of the screen lists the characteristics associated with the third SKU element. These attributes form a matrix where you can enter the quantity and the location for each inventory transaction.

How to display this screen: Complete the Inventory Transactions/Horizontal Entry Screen 1

INR0098 CHANGE Inventory Transactions/Horizontal Entry 12/23/98 17:17:39

EZK Mail Order

Warehouse . : 2 QUALITY ASSURANCE WAREHOUSE

Batch# . . : 304 Item . : B5001 CLR . . . : BLK

Code/Qty . : A 2 SUMMER PUMP

PO# . . . . : 990

Qty/Loc Qty/Loc Qty/Loc Qty/Loc Qty/Loc

A AA AAA B BB

10 0 0 0 0

C D EEE

10 0 0 0 0

A AA AAA B BB

12 0 0 0 0

C D EEE

12 0 0 0 0

A AA AAA B BB

4 0 0 0 0 +

F3=Exit F6=Create F9=Accept F12=Cancel

Field

Description

Qty (Quantity per location)

The number of units involved in the inventory transaction for the style of the item (combination of SKU elements 2 and 3).

Numeric, 5 positions, required.

Location

The area in the warehouse that contains the item. A location may default, determined by the following system control values:

Default Primary Location (C05): defines whether the primary location defined in the SKU file defaults if the specified warehouse is the item warehouse defined in the SKU file.

Default Primary Location from an Item Warehouse (G06): defines whether a primary location for the item in any specified warehouse defaults; in this case the system will default the first primary location, in alphanumeric order, for the item in the specified warehouse. This system control value overrides Default Primary Location (C05).

 

The following message displays if you enter a location whose location class does not match the location class defined for the item and the Allow Location Class Edit in Inventory Transaction (F86) system control value is set to Y or blank:

Item is not compatible with Location.

The location code is validated against the Location file and the Item Location file. If there is no record of this SKU in this location, you can create it if you are authorized to do so.

Alphanumeric, 7 positions; required.

Instructions:

1. Complete the fields for each required SKU.

2. Press F9. The system validates your entries and highlights any fields you need to correct. Note that you must reconcile all the outstanding units for the item before you can accept the transaction. For example, if there are 500 units to place, you must place all 500 across all the SKUs. You return to the Inventory Transactions/Horizontal Entry Screen 1.

 

Note: You cannot process an inventory transaction in immediate mode for an item/SKU if there is an open batch with a transaction for that same item/SKU. You need to delete or process the batch before you can process any other transactions for the item/SKU.

Serial numbers: If the transaction affects the total on-hand quantity for a serial numbered item in your warehouse, you advance to the Enter Serial Numbers Screen.

Enter Serial Numbers Screen

Purpose: Use this screen to enter the serial number of each unit of the item affected by the inventory transaction. Assigning serial numbers allows you to track activity, such as receipts or shipments, for individual units of an item.

You must enter serial numbers for each unit of an item affected by an inventory transaction if the item's Serial #'s (Serial numbers) flag is set to Y and if the transaction affects the total on-hand quantity within a warehouse. In other words, transfers from one location to another in the same warehouse do not require serial number entry.

See Merchandising Entering Additional Item Information for an overview of how serial numbers are tracked through the system.

Important: Until you approve and process the batch, the serial numbers you enter here are flagged as being "in use." This status prevents the system from accepting these serial numbers for any other type of transaction.

How to display this screen: Enter an inventory transaction, using the First Inventory Transactions Screen (Line Entry), Second Inventory Transactions Screen (Full Screen Entry), or Inventory Transactions/Horizontal Entry Screen 2, if the transaction will affect the total on-hand quantity of the item in the warehouse.

INR1044 DISPLAY Enter Serial Numbers 7/02/97 15:50:16

EZK Mail Order

Whse : 2 QUALITY ASSURANCE WAREHOUSE

Item : PR600 PHOTO-QUALITY COLOR PRINTER

Serial #'s:

F9=Accept F11=Reject

Field

Description

Serial #s (Serial numbers)

The serial number(s) of each unit of the item or SKU affected by the transaction. This screen provides a field for entry of a serial number for each unit.

Alphanumeric, 20 positions each field; required.

Instructions:

1. Enter the serial number for each unit of the item affected by the transaction in each field provided.

2. The system highlights any serial number fields that are not complete, or that are invalid (see below for examples). Complete or correct any fields as needed.

3. Press F9 to submit the serial number entry; otherwise, press F11 to reject and return to the previous screen.

 

Note: You will not be able to complete the transaction until you complete each serial number field on this screen.

Serial number validation: The system validates that each serial number you enter for this item is appropriate for the transaction. This validation varies depending upon whether the transaction will increase or decrease the total on-hand quantity of the item within a warehouse, as follows:

On-hand quantity increases: The serial number(s) you enter cannot already exist for the item. For example, adjustments to increase on-hand (transaction code A) or resetting the on-hand quantity to a higher quantity (transaction code O) would require that you enter the new serial numbers for the item in the warehouse.

on-hand quantity decreases: The serial numbers you enter must exist for the item in the correct warehouse, and must be on-hand. Serial number statuses that indicate the unit is on-hand are C (customer returns) and R (received). For example, if you are returning a unit to the vendor (transaction code V) or transferring units to a different warehouse (transaction code T), the system confirms that the serial number(s) are currently on-hand in the affected warehouse.

Review Inventory Transactions Screen

Purpose: Press F9 from the First Inventory Transactions Screen (Line Entry) or Second Inventory Transactions Screen (Full Screen Entry) or Inventory Transactions/Horizontal Entry Screen 2 to review and work with batches. Here, you can change, delete, or display the inventory transactions.

INR0019 DISPLAY Review Inventory Transactions 10/07/98 13:15:30

The KL Mail Order Company

Batch# . . . : 165

--- From --- ------ To ------

Opt Cde Item COLR SIZE OTHR Quantity Whs Location Cmp Whs Location

Type options, press Enter.

2=Change 4=Delete 5=Display

A STRABRISURYN 10 3 J010101

SWEATER

A STR872N 5 3 J010101

SHIRT872N

V SWT99215T 5 3 J010101

SWEATSHIRT99215T

T SWT99215T 5 3 J010101 555 10 A010101

SWEATPANT99215T +

F3=Exit F7=Full screen entry F8=Line entry F12=Cancel

F21=Print batch

Field

Description

Cde (Code)

A code used during inventory transactions to identify the type of transaction being performed. These codes are defined in and validated against the Inventory Transaction Code file. The following system-defined codes are available in batch inventory transaction processing:

A: Adjustment

M: Make Up Finished Good

O: On-hand

T: Transfer

V: Return to Vendor

You can also create and use your own codes. See Inventory Transaction Codes and Reasons.

Alphanumeric, 1 position, optional.

Item

A code that represents a unit of inventory.

Alphanumeric, 12 positions; optional.

SKU (Stock keeping unit)

The style of the item, such as its color or size.

Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU); required if scanning for an item with SKUs.

Screen Option

Procedure

Change a transaction

Enter 2 next to a transaction to advance to the Change Inventory Transaction Screen.

Delete a transaction

Enter 4 next to a transaction to delete it.

Display a transaction

Enter 5 next to a transaction to advance to the Display Inventory Transactions Screen.

Work in full screen mode

Press F7 to advance to the Second Inventory Transactions Screen (Full Screen Entry).

Work in line entry mode

Press F8 to advance to the First Inventory Transactions Screen (Line Entry).

Change Inventory Transaction Screen

Purpose: Use this screen to change a specific inventory transaction.

How to display this screen: Enter 2 next to the transaction at the Review Inventory Transactions Screen.

INR0041 CHANGE Change Inventory Transaction 12/23/98 17:23:45

EZK Mail Order

Batch# . . . . . . . . . . : 304

Transaction# . . . . . . . : 9

Date/Time . . . . . . . . : 12/23/98 17:23:02

User Id . . . . . . . . . : EKAPLAN

Transaction code . . . . . : A

Item/SKU . . . . . . . . . : DE400

Quantity . . . . . . . . . : 1

From warehouse/location . : 2 PRIM1

To warehouse/location . . : 0

To company . . . . . . . . : 0

Identification# . . . . . .

Reason . . . . . . . . . . .

G/L account # . . . . . . . 405

PO# . . . . . . . . . . . . 989

F3=Exit F5=Reset F12=Cancel

You can change the To location, Identification number, Reason, General ledger account number, and PO# fields on this screen only. You can change the To location field only when you perform a transfer (T).

Enter any changes you want to make to this transaction, or press F3 or F12 to return to the Display Inventory Transactions Screen.

Display Inventory Transactions Screen

To display: Enter 5 next to a transaction at the Review Inventory Transactions Screen to advance to the Display Inventory Transactions screen. You cannot change any information on this screen. See Change Inventory Transaction Screen for field descriptions.

WH02_01 CWDirect 18.0.x 2018 OTN