Part B: Performing Inventory Transactions | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 13: Working with Inventory Transactions in Immediate Mode (WITI) |
Chapter 12: 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 Chapter 13: 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 chapter:
• 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
• 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 Chapter 40: 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 Chapter 27: Work with Inventory Transaction Codes (WITC), and Chapter 28: 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 Chapter 41: 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 Chapter 18: 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 Chapter 2: 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. |
Step-by-step 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).
Step-by-step 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 Chapter 41: 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 Chapter 18: 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 Chapter 2: 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. |
Step-by-step 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.
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 Chapter 29: 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 , 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. |
Step-by-step 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.
Part B: Performing Inventory Transactions | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 13: Working with Inventory Transactions in Immediate Mode (WITI) |
WH02_01 CWDirect 18.0 August 2015 OTN