MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Inventory Control > Screens > Inventory Adjustment and Stock Transfer Update > IC120S01 - Inventory Adjustment

IC120S01 - Inventory Adjustment

 

 

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.