WILLIAMS INVENTORY CONTROL 8/01/94
DSP01 INVENTORY UPDATE TRANSACTION ADJUSTMENT
Part Number ASPIRIN
Transaction Quantity 33 Unit Of Measure BT
Company 001 Warehouse BEL
Adjustment Code 01 Stock Location ALOCAT2
Balance Type H Reversal Code
Transaction Description Job/Group No
Lot Number LOT001 Lot FIFO Date
Lot Type
Unit Cost Transaction Value
Account/Center Number
F2=Command F3=Exit F4=Prompt F9=Inquiry
F15=Rekey Data F22=New Trans Date
This screen is used to record inventory balance adjustments and/or to adjust moving average values. The adjustment code specifies the nature of the adjustment and whether the transaction has a positive or negative effect on inventory.
PART NUMBER
Required. The number of the part for which inventory is to be adjusted. The part number must exist on the Part Master File (DE100M). Unless you are entering a cycle count adjustment, the status of the part must be valid for inventory adjustments and stock transfers, as defined on Reference File category D88.
TRANSACTION QUANTITY/ADJUSTMENT QUANTITY
Required. The adjustment quantity. If there is not enough inventory in the sourcing location, a warning message will be displayed after you press Enter to process the transaction.
UNIT OF MEASURE
Required. The unit of measure used for the adjustment quantity. Must be the stockkeeping, purchasing, or selling unit of measure for the part. The unit of measure must exist on Reference File category 005. If you leave this field blank, it will default to the stockkeeping unit.
COMPANY/WAREHOUSE
Required. The company and warehouse where the inventory adjustment will be made. Must be an existing company/warehouse.
ADJUSTMENT CODE
Required. Identifies a 'reason' code for the adjustment. The adjustment code also defines whether the adjustment will result in an increase or a decrease in inventory. The adjustment code must exist on Reference File category 432.
STOCK LOCATION
Required. Must be stock location that exists within the company/warehouse.
BALANCE TYPE
Required. Must be one of the four balance types defined for the system. If you are maintaining a manufacturing company/warehouse, the balance type will default to the first balance type, ON-HAND (H). If you are maintaining a distribution company/warehouse, the balance type must be entered.
REVERSAL CODE
Optional. A Reversal Code of 'R' indicates that you wish to back out an adjustment that was recorded previously. If you are not reversing a transaction, leave this field blank.
TRANSACTION DESCRIPTION/ADJUSTMENT DESCRIPTION
Optional. The transaction description may be used as a memo field to record details about the adjustment.
JOB/GROUP NUMBER
Optional. The job/group number is only displayed if the Job Control module is installed. Can only be entered for job-controlled parts. Must be either a valid job number (job status cannot be 'C' - Job Closed or 'Z' - Costing Close) on the Job Master File, or a valid group on Reference File category D47, or blank if inventory in an excess location is being adjusted, or an existing stock location for the part and job/group. This last case occurs if either the job has been closed and inventory still exists for the job, or if a group has been deleted and inventory still exists for the group.
LOT NUMBER
Required for lot-controlled parts. Must be left blank for non-lot-controlled parts. You have several options:
o You may enter an existing lot number in this field.
o You may create a new lot by entering a new lot number in this field.
o If Automatic Lot Number Assignment has been set to Y (yes) in Reference File category Y34, a lot can be assigned automatically using the next available lot number.
o If Automatic Lot Number Assignment has been set to N (no) in Reference File category Y34, a new lot number will not be assigned automatically. You may, however, enter either an existing lot number or a new lot number in this field. If you enter a new lot number in this field and press Enter, the lot number will be added to the Lot Control File (IC150M).
If the lot is on hold, an error message is displayed and the lot number is reverse imaged. No inventory may be issued from or received into a lot that is on hold.
LOT FIFO DATE
Required when you create a new lot or receive a balance against a preexisting lot for the first time. This date is used to establish the age of lot-controlled inventory so that the oldest inventory is used first and inventory obsolescence is minimized. This field is only used for lot-controlled parts. It must be entered using the appropriate date format (day/month/year, year/month/date, etc.) as defined on Reference File category 049. If you do not enter a date and you are creating a new lot, the transaction date will default to this field.
LOT TYPE
Required for lot-controlled parts when you create a new lot. This field must be blank if the part is not lot controlled. This field indicates whether the type of lot is manufactured or purchased. Valid values are:
M - Manufactured
P - Purchased
UNIT COST (not on Cycle Count Adjustment Screen)
Optional. Used to assign a value to the adjustment transaction for a part that uses moving average costing (the part is in a warehouse using moving average costing or is a non-standard part).
If entered, the unit cost must be numeric and can have up to five or seven decimal places, depending on the number specified during installation. Either a cost per unit must be entered (in the Unit Cost field) or a cost for the entire transaction must be entered (in the Transaction Value field). The unit cost may not be entered for a cycle count adjustment.
TRANSACTION VALUE
Optional. If not blank, must be numeric and right-justified. Has two implied decimal positions.
ACCOUNT/CENTER INFORMATION
Optional. The account/center number may be entered to specify the expense (or gain) account to be booked. If not entered, the expense account will be assigned based on the adjustment code. If the General Ledger module is installed, the account/center must be found on the Account/Center Master file. If the General Ledger module is not installed, the account must be found on the Account Description category (112) and the center must be found on the Center Description category (113).
COMMAND KEYS
Enter - Update changes.
F2 - Display a window where a fast path option or mnemonic can be entered. Fast path allows the next menu selection to be made directly from this screen. When the window is displayed, pressing F3 will remove it.
F3 - Exit program without update.
F4 - Displays a list of values for the field where the cursor is positioned. If you select one of the items from the list, it will be returned to the application screen.
F9 - Enter the Inventory Stock Status Inquiry (standard inventory adjustment) or the Inventory Transaction History Inquiry (cycle count adjustment) without processing transaction.
F15 - Clear screen.
F22 - Change the transaction date that will appear on the Transaction Register report. The transaction date defaults to the current date. The adjustment transactions will be processed in Inventory accounting based on the transaction date.
|