Working with Inventory Transaction Errors (WITE)
Purpose: Use the Work with Inventory Transaction Errors function to review all of the errors that occurred while performing inventory transactions, either through processing within Order Management System (system errors) or through the generic inventory transaction upload.
How do system errors occur? Errors can occur when you enter transactions in batch mode or automated transaction mode, or through transactions the system performs, such as issuing or express billing items. The system, or the person performing an inventory transaction, can cause the errors if inventory levels in related tables become out of sync, such as when an interface performs an update before the transaction is complete.
For example, the system attempts to perform an issue transaction when you confirm shipment of an item. However, the on-hand quantity for the item/warehouse is less than the shipment quantity. In this situation, the system creates a "negative on hand" transaction error record. For another example, if there is a discrepancy between the on-hand quantities for the FIFO layers and the related item/warehouse and/or item/location, the system creates a "FIFO unbalanced" error.
Correcting system errors: You can reprocess "negative on hand" errors using this menu option, and complete the attempted inventory transaction. In the example above, you would first need to reset the on-hand quantity of the item through a purchase order receipt or adjustment inventory transaction before submitting the reprocess. You can also use this menu option to delete errors that are informational only, such as FIFO warnings.
Note: You cannot process inventory resets if there are any inventory transaction errors; you must first correct or delete all errors. See Working with Inventory Resets.
Generic upload errors: In addition to the errors that can occur within the system, either through batch or system transactions, the Generic Inventory Transaction Upload can generate errors based on invalid, inconsistent, or missing information provided in the uploaded message. Unlike with most system errors, you can normally correct and resubmit generic upload errors.
In this chapter:
• Work with Inventory Transaction Errors Screen
• Display Inventory Transaction Errors Screen
• Generic Interface Error Screen
Work with Inventory Transaction Errors Screen
Purpose: Use this screen to display all of the errors that have occurred during inventory transactions.
How to display this screen: Enter WITE in the Fast path field at the top of any menu or select this option from a menu.
Field |
Description |
Indicates whether the error resulted from invalid, inconsistent or missing information in a transaction received through the Generic Inventory Transaction Upload or Automated Inventory Transaction Processing. Valid values are: • Y = generic inventory transaction upload error: When you select Change for this type of error, you advance to the Generic Interface Error Screen, where you can change information before resubmitting and processing the transaction. • N = error resulting from an interactive or system transaction: You cannot change information for the transaction. When you select Change for this type of error, the system displays an error message: System generated transactions cannot be changed. However, you can reprocess “negative on hand” errors using this menu option, and complete the attempted inventory transaction, if you have corrected the situation that produced the error. Note: Uploaded inventory transactions can have this flag unselected if the information in the upload was correct and complete, but a regular transaction error occurred once the upload was processed. For example, an upload error could have this flag unselected if the transaction would produce a “negative on hand” situation. |
|
Date (Inventory transaction error date) |
The date when the transaction error occurred. Numeric, 6 positions (user date format); optional. |
Item |
A code for a unit of inventory. Item codes are defined in and validated against the Item table. Alphanumeric, 12 positions; optional. |
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 table. Alphanumeric, three 4-position fields; display-only. |
Cde (Transaction code) |
The inventory transaction code that was used when the error occurred. Valid values include: • A =Adjustment • C = Customer Return • E = Express Bill • G = Item to item transfer • I = Issue • M = Make up finished good • T = Transfer • V = Return to vendor • O = On-hand • R = Receiving You can also create user-defined transaction codes. See Work with Inventory Transaction Codes (WITC). Alphanumeric, 1 position; display-only. |
Qty (Quantity) |
The number of units that this transaction error affects. Numeric, 8 positions; display-only. |
Error (Inventory transaction error description) |
A description of the transaction error that occurred. For example: Negative On hand See Inventory Transaction Upload Errors for information on the types of errors that can occur through the generic inventory transaction upload. Alphanumeric, 25 positions; display-only. |
Screen Option |
Procedure |
Change an uploaded transaction or automated transaction |
Select Change for an uploaded transaction or automated transaction to advance to the Generic Interface Error Screen. Note: You cannot change a transaction error that occurred through batch inventory transactions or system processing; instead, the system displays an error message: System generated transactions cannot be changed. See the I (Interface error) flag for more information. |
Delete a transaction error |
Select Delete for the error you want to delete. |
Display a transaction error |
Select Display for an error to advance to the Display Inventory Transaction Errors Screen for a system error, or the Generic Interface Error Screen for an generic upload error. See the I (Interface error) flag for more information. |
Advance to inventory inquiry |
Select Inv Inquiry for an error to advance to the Display Item/Warehouse Information Screen. |
Attempt to reprocess the inventory transaction |
Select Reprocess for the error to reprocess it. See Reprocessing Transactions. |
Advance to standard order inquiry |
Select Order Inquiry for an error to advance to the Order Inquiry Header Screen or the Order Inquiry Detail Screen, depending on the setting of the Default Version for Order Inquiry (C34) system control value. |
Advance to item transaction history |
Select Item Transaction History to advance to the Inventory Transaction History Screen (1 of 2). |
Attempt to reprocess all inventory transactions in error |
Select Reprocess. See Reprocessing Transactions. |
Delete all inventory transaction error records |
Select Delete all. The system displays a confirmation window. If you confirm the deletion at this window, the system submits the job DLT_WITE, which deletes all transaction errors except for “FIFO unbalanced” errors, and produces a listing of each deleted error. (Note: You must delete each “FIFO unbalanced” error using Delete. |
Display Inventory Transaction Errors Screen
Purpose: Use this screen to display a specific system transaction error.
How to display this screen: Select Display for a system inventory transaction error at the Work with Inventory Transaction Errors Screen.
Note: When you select Display for a generic upload transaction error (the I (Interface error) flag is selected), you advance to the Generic Interface Error Screen.
Field |
Description |
Date (Inventory transaction error date) |
The date when the transaction error occurred. Numeric, 6 positions (user date format); display-only. |
Time (Inventory transaction error time) |
The time when the inventory transaction error occurred. Numeric, 6 positions (HHMMSS format); display-only. |
Transaction code (Inventory transaction code) |
The code identifying the inventory transaction that was attempted when the transaction error occurred. Alphanumeric, 1 position; display-only. |
Order # |
The order, ship-to number, and shipment number, each separated by hyphens, associated with the transaction error. Order number: numeric, 7 positions; display-only. Ship-to number: numeric, 3 positions; display-only. Shipment number: numeric, 3 positions; display-only. |
Invoice # |
The invoice number identifying a shipment against an order, if the inventory transaction error occurred when attempting an issue transaction. Numeric, 7 positions; display-only. |
Item#/SKU (Item number and stock keeping unit) |
The unit of inventory and its unique characteristics that was affected by the transaction. Item: Alphanumeric, 12 positions; display-only. SKU: Alphanumeric, three 4-position fields; display-only. |
Transaction qty (Transaction quantity) |
The amount of inventory that this transaction error affects. Numeric, 8 positions; display-only. |
From whs/location (From warehouse and location) |
The original warehouse and location that the item was taken from. Whs: Alphanumeric, 3 positions; display-only. Location: Alphanumeric, 7 positions; display-only. |
To cmp/whs/location (To company, warehouse and location) |
The company, warehouse and location that the item was transferred to. Cmp: Alphanumeric, 3 positions; display-only. Whs: Alphanumeric, 3 positions; display-only. Location: Alphanumeric, 7 positions; display-only. |
Called by |
The name of the function that performed this inventory transaction. This field is not currently implemented. Alphanumeric, 40 positions; display-only. |
Error (Inventory transaction error description) |
A description of the transaction error that occurred. Alphanumeric, 25 positions; display-only. |
Cost |
The unit cost of the item. Numeric, 11 positions with a 4-place decimal; display-only. |
Price |
The unit price of the item on the order, if the transaction error involved an order. Numeric, 7 positions with a 2-place decimal; display-only. |
Batch # |
The number of the batch containing the attempted inventory transaction, if this error was a result of immediate or batch inventory transactions. Numeric, 7 positions; display-only. |
Transaction reason |
The code identifying the reason for the inventory transaction, if one was specified. Numeric, 2 positions; display-only. |
Express bill |
This flag indicates whether the transaction represented an express bill, or an order that bypasses reservation, pick slip generation, and shipment confirmation. An order is processed as an express bill if the ship via on the order header has a Billing code of Express Bill. Valid values are: • Selected = Transaction was an express bill • Unselected = Transaction was not an express bill |
S/H |
This flag indicates whether the item associated with the transaction required special handling. Valid values are: • Selected = Item required special handling • Unselected = Item did not require special handling |
Auto restock |
This flag indicates whether the transaction was a replenishment to the Auto restock location in the “to” warehouse. Valid values are: • Selected = Transaction was a replenishment to an auto restock location • Unselected = Transaction was not a replenishment to an auto restock location |
Delete location |
This flag indicates whether the item location record should be deleted when the transaction is complete. Ordinarily, the system deletes an item location record when the on-hand falls to zero, unless it is a primary location. Valid values are: • Selected = Item location should be deleted • Unselected = Item location should not be deleted |
Generic Interface Error Screen
Purpose: Use this screen to review or work with errors that occur through the Generic Inventory Transaction Upload or Automated Inventory Transaction Processing.
How to display this screen:
• Select Change for a generic upload error at the Work with Inventory Transaction Errors Screen to display this screen in Change mode.
• Select Display for a generic upload error Work with Inventory Transaction Errors Screen to display this screen in Display mode; in this case, all fields are display-only.
Note: You cannot display this screen for a system transaction error (the I (Interface error) flag is unselected).
Field |
Description |
Date |
The date when the transaction error occurred. Numeric, 6 positions (user date format); display-only. |
Transaction code |
The code identifying the inventory transaction that was attempted when the transaction error occurred. For upload transactions, the transaction_code from the inventory transaction upload message defaults. Defined in and validated against the Item Transaction Code table; see Work with Inventory Transaction Codes (WITC). Alphanumeric, 1 position; required. |
Time |
The time when the inventory transaction error occurred. Numeric, 6 positions (HHMMSS format); display-only. |
Transaction reason |
Defined in and validated against the Item Transaction Reason Code table; see Work with Inventory Transaction Reason Codes (WIT1). Required if the inventory transaction code has the Reason required flag selected. For upload transactions, the transaction_reason, if any specified in the inventory transaction upload message defaults. Numeric, 2 positions; optional or required. |
Error |
The description of the error that occurred. It is possible for an uploaded transaction to have more than one error. See Inventory Transaction Upload Errors for a list of errors and descriptions. Alphanumeric, 25 positions; display-only. |
Allow partial |
The setting of the allow_partial flag from the inventory transaction upload message. Valid values are: • selected = process a partial quantity if the full quantity cannot be processed. Defaults to selected for Automated Inventory Transaction Processing. • unselected = do not process a partial quantity; put the transaction in error if the full quantity cannot be processed See Processing Partial Quantities for a discussion. |
Batch # |
The batch number to identify a transaction or group of transactions. The batch_number, if any, specified in the inventory transaction upload message defaults. Numeric, 7 positions; optional. |
The setting of the create_item_ flag from the inventory transaction upload message. Valid values are: • selected = create an Item Warehouse record if it does not already exist. Y defaults for Automated Inventory Transaction Processing. • unselected = do not create a new Item Warehouse record; put the transaction in error if the Item Warehouse does not exist In the case of a transfer (T) or item-to-item transfer (G) transaction, this value refers to the To warehouse; otherwise, it refers to the warehouse specified in the Warehouse. |
|
Identification # |
A number to identify the transaction. Not valid with item-to-item (G) transactions. The identification_nbr, if any, specified in the inventory transaction upload message defaults. For Automated Inventory Transaction Processing, AUTOTRANS defaults. Numeric, 10 positions; optional. |
Create item location |
The setting of the create_item_location flag from the inventory transaction upload message. Valid values are: • selected = create an Item Location record if it does not already exist. Y defaults for Automated Inventory Transaction Processing. • unselected = do not create a new Item Location record; put the transaction in error if the Item Location does not exist Note: • In order to create both a new Item Warehouse and a new Item Location, both this flag and the Create item warehouse flag must be selected. • In the case of a transfer (T) or item-to-item transfer (G) transaction, this value refers to the To location; otherwise, it refers to the warehouse specified in the Location. |
Entered by user |
The user ID of the user that entered the inventory transaction. The entered_by_user, if any, specified in the inventory transaction upload message defaults. Alphanumeric, 10 positions; optional. |
To company |
Used for transfer (T) and item-to-item transfer (G) transactions only, and only when the “to” company is different from the “from” (current) company. See Summary of Transaction Rules for a summary. The company, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. Numeric, 3 positions; optional. |
Defined in and validated against the Item table; see Performing Initial Item Entry (MITM). See Resolving the Item and SKU for information on how the system identifies the correct item and SKU. The item_number, if any, specified in the Transaction element of the inventory transaction upload message defaults. Alphanumeric, 12 positions; optional. |
|
To item # |
Defined in and validated against the Item table; see Performing Initial Item Entry (MITM). See Resolving the Item and SKU for information on how the system identifies the correct item and SKU. The item_number, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. Used for item-to-item transfer (G) transactions only. See Summary of Transaction Rules for a summary. Alphanumeric, 12 positions; optional. |
SKU |
The item’s unique characteristics, such as its color and size. Required if the Item is specified and the item has SKUs. The sku_code, if any, specified in the Transaction element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Alphanumeric, 14 positions; optional. |
To SKU |
The item’s unique characteristics, such as its color and size. Required if the item_number is specified and the item has SKUs. See Resolving the Item and SKU for more information. The sku_code, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. Used for item-to-item transfer (G) transactions only. See Summary of Transaction Rules for a summary. Alphanumeric, 14 positions; optional. |
Short SKU |
An additional code to identify an item and SKU. The short_sku, if any, specified in the Transaction element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Numeric, 7 positions; optional. |
To short SKU |
The short_sku, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Used for item-to-item transfer (G) transactions only. See Summary of Transaction Rules for a summary. Numeric, 7 positions; optional. |
Retail ref # |
An additional code or reference number to identify an item and SKU. The retail_reference_nbr, if any, specified in the Transaction element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Numeric, 15 positions; optional. |
To retail ref # |
The retail_reference_nbr, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Used for item-to-item transfer (G) transactions only. See Summary of Transaction Rules for a summary. Numeric, 15 positions; optional. |
UPC type |
A code to identify the format of the Universal Product Code. The upc_type, if any, specified in the Transaction element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Alphanumeric, 3 positions; optional. |
To UPC type |
The upc_type, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Used for item-to-item transfer (G) transactions only. See Summary of Transaction Rules for a summary. Alphanumeric, 3 positions; optional. |
UPC |
The Universal Product Code. The upc_code, if any, specified in the Transaction element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Note: Include any leading zeros. For example, if the UPC code is 06012011, enter 06012011 and not 6012011. Alphanumeric, 14 positions; optional. |
To UPC |
The upc_code, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. See Resolving the Item and SKU for more information. Used for item-to-item transfer (G) transactions only. See Summary of Transaction Rules for a summary. Note: Include any leading zeros. For example, if the UPC code is 06012011, enter 06012011 and not 6012011. Alphanumeric, 14 positions; optional. |
A code to identify the warehouse where the item is located. Defined in and validated against the Warehouse table; see Creating and Maintaining Warehouses (WWHS). For upload transactions, the warehouse, if any, specified in the Transaction element of the inventory transaction upload message defaults. Represents the "from" warehouse for transfer (T) and item-to-item transfer (G) transactions. Numeric, 3 positions; required. |
|
A code to identify the warehouse to move the item. Defined in and validated against the Warehouse table; see Creating and Maintaining Warehouses (WWHS). For upload transactions, the warehouse, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. Used for transfer (T) and item-to-item transfer (G) transactions only. Numeric, 3 positions; optional. |
|
A code to identify the location in the warehouse where the item is located. Defined in and validated against the Location table; see Creating and Maintaining Locations (WLOC). For upload transactions, the location, if any, specified in the Transaction element of the inventory transaction upload message defaults. Represents the "from" location for transfer (T) and item-to-item transfer (G) transactions. Alphanumeric, 7 positions; required. |
|
A code to identify the location in the warehouse to move the item. Defined in and validated against the Location table; see Creating and Maintaining Locations (WLOC). For upload transactions, the location, if any, specified in the TransactionTo element of the inventory transaction upload message defaults. Used for transfer (T) and item-to-item transfer (G) transactions only. Alphanumeric, 7 positions; optional. |
|
Quantity |
The quantity of the item and SKU that is affected by the transaction. For upload transactions, the transaction_quantity, if any, specified in the inventory transaction upload message defaults. The actual effect on inventory varies with the transaction. See Summary of Transaction Rules for more information. Numeric, 5 positions; required. |
S/O control |
Updates the SKU table if the item will be sold out as a result of an item-to-item (G) transfer. Validated against the Soldout Control table; see Working with Soldout Controls (WSLD). If a soldout control code is indicated, it must represent a valid code even if it is not required for the transaction. For upload transactions, the so_control, if any, specified in the Transaction element of the inventory transaction upload message defaults. Alphanumeric, 2 positions; optional. |
Completing this screen: See Inventory Transaction Upload Errors for a discussion of each error.
Correct any fields and Select OK. The system validates your entries and highlights any fields you need to correct. If the system does not highlight any errors, you can reprocess it; see Reprocessing Transactions.
Note: After you correct an error and reprocess the transaction, it is possible for the transaction to remain in error status if there is an additional problem. You can repeat the correction and reprocessing steps; alternatively, you can delete the transaction error and use Working with Inventory Transactions (WITI) to process the transaction.
Purpose: You can complete unprocessed inventory transactions at the Work with Inventory Transaction Errors Screen, provided that:
• the error was “negative on hand” or occurred through the Generic Inventory Transaction Upload or Automated Inventory Transaction Processing
• you have corrected the condition that produced the error
You cannot reprocess "FIFO unbalanced" inventory transaction errors; these errors are informational only. You should delete this type of error.
Reprocess an individual transaction: Select Reprocess for a transaction error to reprocess it. If it is possible to complete the inventory transaction at this time, the error will be deleted from the screen, and the following message indicates:
Transaction was successfully reprocessed!
Otherwise, the system displays an error message.
Reprocess all transactions: Select Reprocess to reprocess all eligible transactions. The Process Item Transaction Errors window opens.
Optionally, enter the item and SKU to complete inventory transactions for that item/SKU only, or select Reprocess to reprocess transactions for all items. The system submits the job PROC_WITE, which reprocesses each eligible transaction. Transaction errors remain for any transactions that were not eligible for completion.
Pick slip preparation: If a transaction causes the system to unreserve an order because the on hand quantity was reduced below the reserved quantity, the system removes any pick slip preparation from the order and then reevaluates the order for pick slip preparation; see Preparing Orders for Pick Slip Generation.
