Chapter 27: Work with Inventory Transaction Codes (WITC)
Introduction: Inventory transaction codes provide a concise way to describe the transactions that are performed on inventory. These codes control whether the inventory is being increased, decreased, or just moved.
In this chapter:
• Work with Inventory Transaction Codes Screen
• Create Inventory Transaction Code Screen
• Change Inventory Transaction Code Screen
• Display Inventory Transaction Code Screen
There are codes that come with the system and cannot be deleted. You can add customized codes for any purposes you require. Note that each code must consist of a unique number or letter.
Code |
Description |
Effect on Inventory Levels |
A |
Adjustment |
Used in inventory transactions to increase on-hand if positive quantity is entered; decreases on-hand if negative quantity is entered. |
C |
Customer Return |
Used by the system when processing return merchandise via the Return Authorization module or Order Maintenance. Return transactions will always increase the on-hand quantity in the specified warehouse. |
E |
Express Bill |
Used by the system when processing an order that will not go through the normal pick and confirmation cycle (i.e., merchandise is already picked and shipped before the order is entered). |
G |
Item to Item Transfer |
Used in inventory transactions to transfer one item to another, such as when you stop offering an item independently and include it in a grab bag instead. (Note: Not available if you use FIFO Costing.) |
I |
Issue |
Used by the system to decrease on-hand for confirmed shipments. The system writes an issue transaction for non-inventory and drop ship items when the Create Item Transaction History for Non-Inventory Items (E39) system control value is set to Y. See Display Inventory Transaction History (DITH). |
M |
Make Up Finished Good |
Used in inventory transactions to increase on-hand amount for the finished good item and decreases on-hand for the components. |
O |
Reset On-Hand Quantity |
Used in inventory transactions to reset the on-hand quantity to the entered value. (Note: Not available if you use FIFO Costing.) |
P |
Physical |
Used by the physical inventory update program when adjusting on-hand based on physical counts entered. If the count is greater than on-hand, on-hand will be increased. If the count is less than on-hand, then on-hand will be decreased. |
R |
Receiving |
Used in the purchase order receipts program for merchandise received. Increments the on-hand. |
T |
Transfer |
Used in inventory transactions to increase on-hand in "to" location and decreases the on-hand in "from" locations. |
V |
Return to Vendor |
Used in inventory transactions to decrease on-hand amount if positive quantity is entered; increases on-hand if negative quantity is entered. When used by the system for vendor charge backs, decreases on-hand when you process a charge back; increases on-hand when you reverse a charge back. |
Components of codes: Codes have four attributes:
• An attribute that states whether the code may be used in inventory transactions or only by the system for other updating
• An attribute that states whether this code must have an additional reason code entered when the code is entered; see Work with Inventory Transaction Reason Codes (WIT1)
• A plus (+) or minus (-) code that indicates whether inventory will be increased or decreased by the quantity in the transaction
• A General Ledger account number to which the transaction posts; this is validated against the General Ledger Accounts file.
* code for changes in inventory valuation: The system uses the * inventory transaction code, if it exists, to track changes in inventory valuation. See * = Change FIFO Cost and * = Change Average or Standard Cost for more information.
Work with Inventory Transaction Codes Screen
Purpose: Use this screen to create, change, delete, or display transaction codes.
How to display this screen: Enter WITC in the Fast path field at the top of any menu or select Work with Inventory Transaction Codes from a menu.
INR0025 DISPLAY Work with Inventory Transaction Codes 7/10/96 15:59:54 Mail Order
Opt Cde Description Allow Rsn +/- G/L#
Type options, press Enter. 2=Change 4=Delete 5=Display
A ADJUSTMENT Y N + 0 C CUSTOMER RETURN N Y + 0 E EXPRESS BILL N N - 0 G ITEM TO ITEM TRANSFER Y N + 2 I ISSUE N N - 0 M MAKE UP KIT Y N + 0 P PHYSICAL N N + 0 R RECEIPT N N + 0 T TRANSFER Y Y - 0 V RETURN TO VENDOR Y N - 0
F3=Exit F6=Create F12=Cancel F21=Print list F24=Select company |
Field |
Description |
Cde (Code) |
The code representing an inventory transaction. Alphanumeric, 1 position; optional. |
Description |
A description of the code. Alphanumeric, 30 positions; optional |
Allow |
Indicates whether you can use this code when processing inventory transactions, or if it is reserved for system use. Y = Transaction is allowed in inventory transactions. N = Transaction is not allowed in inventory transactions. Note: Even if this value is set to N, you can still process a transaction of this type through the Generic Inventory Transaction Upload. Alphanumeric, 1 position; optional. |
Rsn (Reason) |
This setting indicates whether you must enter an inventory transaction reason code when you process this type of inventory transaction. Reason codes are defined in and validated against the Item Transaction Reason file; see Work with Inventory Transaction Reason Codes (WIT1). Y = Reason code required. N = Reason code not required. Alphanumeric, 1 position; optional. |
+/- (Add to/Subtract from inventory) |
This entry indicates how inventory will be affected when a transaction is processed with this code. Valid values are: + Transaction quantity added to on-hand. - Transaction quantity subtracted from on-hand. Numeric, 1 position; optional. |
A General Ledger account number for posting the transaction. If you do not have authority to the Secure G/L Number Field Access (A84) secured feature, the system displays this field as display-only. Numeric, 8 positions; display-only |
Screen Option |
Procedure |
Create an inventory transaction code |
Press F6 to advance to theCreate Inventory Transaction Code Screen. |
Change an inventory transaction code |
Enter 2 next to a code to advance to the Change Inventory Transaction Code Screen. |
Delete an inventory transaction code |
Enter 4 next to a code to delete it. |
Display an inventory transaction code |
Enter 5 next to a code to advance to the Display Inventory Transaction Code Screen. |
Create Inventory Transaction Code Screen
Purpose: Use this screen to create an inventory transaction code.
How to display this screen: On the Work with Inventory Transaction Codes Screen, press F6.
INR0034 ENTER Create Inventory Transaction Code 7/08/96 17:02:19 CommercialWare
Transaction code . . . . . Description . . . . . . . Allowable . . . . . . . . (Y,N) Reason required . . . . . (Y,N) Effect on inventory . . . (+,-) G/L account # . . . . . .
F3=Exit F12=Cancel |
Field |
Description |
Cde (Code) |
The key to the Item Transaction Code file. The following codes are supplied with the system and cannot be deleted: A = Adjustment C = Customer Return E = Express Bill G = Item to Item Transfer I = Issue M = Make Up Finished Good O = Reset On-Hand Quantity P = Physical Inventory R = Receiving T = Transfer V = Return to Vendor See System Codes. Alphanumeric, 1 position. Create screen: required. Change screen: display-only. |
Description |
A description of the code. Alphanumeric, 30 positions. Create screen, or change screen for user-defined codes: required. Change screen for system codes: display-only. |
Indicates whether you can use this code during inventory transactions or if it is for system use only. Y = You can use this code for inventory transactions. N = You cannot use this code for inventory transactions. Note: • This field cannot be changed for system-supplied codes. • Even if this value is set to N, you can still process a transaction of this type through the Generic Inventory Transaction Upload. Create screen, or change screen for user-defined codes: required. Change screen for system codes: display-only. |
|
This field indicates whether the transaction code requires a reason code. Reason codes are defined in and validated against the Item Transaction Reason file; see Work with Inventory Transaction Reason Codes (WIT1). Reason codes should not be required for codes that you cannot use for inventory transactions (Allow = N). Y = Reason code required. N = Reason code not required. Alphanumeric, 1 position; required. |
|
This entry indicates how inventory will be affected when a transaction is processed with this inventory transaction code. Valid values are: + = Transaction quantity added to on-hand. - = Transaction quantity subtracted from on-hand. Note: You cannot change this field for system-supplied codes. Numeric, 1 position. Create screen, or change screen for user-defined codes: required. Change screen for system codes: display-only. |
|
A General Ledger account number for posting transactions. G/L numbers are defined in and validated against the General Ledger Accounts file. If you do not have authority to the Secure G/L Number Field Access (A84) secured feature, this field is display-only. Important: If you do not specify an account number for the customer return (C) transaction code, then the cost of goods sold will not post to the general ledger when you receive a return. Numeric, 8 position; required. |
Change Inventory Transaction Code Screen
To change: Enter 2 next to the inventory transaction code at the Work with Inventory Transaction Codes Screen to advance to the Change Inventory Transaction Code screen.
You can change any field on this screen except the Code field for codes you define. You can change only the Reason field and the General Ledger # field for system-supplied codes. See the Create Inventory Transaction Code Screen for field descriptions. Change the necessary information and press Enter.
Note: You cannot delete the System Codes.
Display Inventory Transaction Code Screen
To display: Enter 5 next to an inventory transaction code at the Work with Inventory Transaction Codes Screen to advance to the Display Inventory Transaction Code screen. See Create Inventory Transaction Code Screen for field descriptions.
You cannot change any information on this screen.
| Part D: Inventory Transaction Set-Up | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 28: Work with Inventory Transaction Reason Codes (WIT1) |
WH04_01 CWDirect 18.0 August 2015 OTN