WILLIAMS INVENTORY CONTROL 1/21/93
DSP01 INVENTORY UPDATE TRANSACTION MULTI-LINE ADJUSTMENT
Part Number/ Trans Qty/ Co Whs Stock B Ad R Trans Desc FIFO
Unit Cost Trans Value UM Job/Grp Loc T Cd C Lot Number Date/LT
ASPIRIN 26 BT 001 BEL ALOCAT1 H 01 POS INV ADJ 012193
000000000615
BOLT-100 100 EA 001 BEL LOCA01 H BD SALES RETURN
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. Enter the number of the part for which inventory is to be adjusted. The part number must exist on the Part Master File (DE100M). If not entering a cycle count adjustment, the part must have a part status that is valid for inventory adjustments and stock transfers, as defined on the Reference File (category D88).
TRANSACTION QUANTITY/ADJUSTMENT QUANTITY
Required. Enter the adjustment quantity. If there is not enough inventory in the sourcing location, a warning message will be displayed when you press Enter to process the transaction.
UNIT COST (not on Cycle Count Adjustment Screen)
Optional. 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. It may be entered if you wish 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). For this transaction, either a cost per unit (in the Unit Cost field) or a cost for the entire transaction (in the Transaction Value field) may be entered.
The unit cost may not be entered for a cycle count adjustment.
TRANSACTION VALUE
Optional. The value of the inventory transaction. If not blank, this field must be numeric and right-justified. This field contains two implied decimal positions.
UNIT OF MEASURE
Required. Must be the stockkeeping, purchasing or selling unit of measure for the part. The unit of measure must exist on the Reference File (category 005). The measure will default to the SKU if left blank.
COMPANY/WAREHOUSE
Required. Must be an existing company/warehouse.
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.
Note: For a 'Value Only' adjustment, or for a 'Cost Only' adjustment, a job/group number cannot be specified.
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. The first balance type will defaulted if left blank.
ADJUSTMENT CODE
Required. Code identifying the reason 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.
REVERSAL CODE
Optional. Must be blank or R. A Reversal Code of 'R' indicates that you wish to back out an adjustment that was recorded previously.
TRANSACTION DESCRIPTION/ADJUSTMENT DESCRIPTION
The transaction description may be used as a memo field to record details about the adjustment.
LOT NUMBER
Required for lot-controlled parts; must be blank if the part is not lot-controlled. 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), a new lot number cannot 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 and press Enter, the lot 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
This field is displayed only in lot-controlled environments. Required for lot-controlled parts when you create a lot or when you receive a balance against a preexisting lot for the first time. Must be blank if the part is not lot controlled.
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. You must enter the date 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
This field is displayed only in lot-controlled environments. Required for lot-controlled parts when you create a new lot. This field indicates whether the type of lot is manufactured or purchased. Valid values are:
M - Manufactured
P - Purchased
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 - Display 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.
|