MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Just-in-Time > Screens > Maintenance Screens from Other Modules > Inventory Adjustment and Stock Transfer Update > IC120S05 - Multi-Line Inv Adj/Cycle Count Adj Screen

IC120S05 - Multi-Line Inv Adj/Cycle Count Adj Screen

 

 

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.