<< Click to Display Table of Contents >>

IN-C  Enter Inventory Adjustments

Purpose of Program

Use this program to adjust inventory quantities up or down.  If you want to superimpose a new quantity over the prior quantity, as when entering a physical inventory, use IN-K  Adjust Physical Levels instead.

Field Explanations

Date

The date defaults to the computer system date, but may be overridden.

Type

The inventory transaction type.  You can press F1 to get a listing of field values.  They are as follows.

A - Adjustments

S - Shipments

P - Purchase Receipts

Item number

The item number of the item being adjusted.

Description

The inventory description of the item being adjusted.  The user cannot edit this field.

Location

Enter the warehouse location name here.  The current on-hand for this location will be displayed for reference.

Quantity

The number of units being adjusted for this item.  You may enter a positive or negative quantity.

Use Std Cost?

If you do not know the actual cost of the item, you may answer Y and the item's standard cost will be copied into the Actual Cost field.  This is only used when adding to inventory.

GL Account

If your default is set to allow it, you can enter the GL account and department for the expense side of the transaction.

Act Unit Cost

If you answered Y to the Std Cost field, the item's standard cost will be entered in this field.  If you answered N to the Std Cost field, the item's average cost will be the default value in this field.  If you know the actual cost of this transaction, you may override the default value.   If you are entering a negative adjustment, you are not allowed access to this field.

Reference

When entering an adjustment type A you may use this field to make a short note as to the reason for the adjustment.  On transaction types S and P, the system uses this field to record the customer or vendor name.

Invoice No

The invoice number, used when entering a type S (shipments) adjustment.

Customer Code

The customer code associated with the sales order or invoice.  This must be a valid customer in the customer file.  You may select a customer from a pop-up window by pressing the F2 key (or clicking on the Lookup button).

Customer Name

The customer name will automatically display in this field.  You may override it if you wish to use the field for a notation.

Selling Price

The sales price of the shipment.  This would apply only to type S (shipments) transactions.

Purch Ord No

The purchase order number.  This would apply only to type P (purchase receipts) transactions.

Vendor Code

The vendor code for the purchase order.  This must be a valid vendor in the vendor file.  You may select a vendor from a pop-up window by pressing the F2 key (or clicking on the Lookup button).

Vendor Name

The vendor name will automatically display in this field.  You may override it if you wish to use the field for a notation.

Lot Number

If the item being adjusted is coded for lot control, you will be required to enter a lot number before the record can be saved.

Serial Number

If the item being adjusted is coded for serial control, you will be required to enter a serial number for each unit before the record can be saved.

 

General Program Operation

Accept today's date or enter a transaction date.  Select a transaction Type.  If you don't know the available type codes, press F1 (or click on the Help button) for a listing in a pop-up window.  Enter the item number of the item being adjusted or select one from a pop- up window by pressing the F2 key (or clicking on the Lookup button).  The product description will display automatically.

Enter the quantity being adjusted.  This can be a positive or negative amount.

If you are adding an amount and don't know the actual cost, you can answer Y to the Use Std Cost prompt and the system will insert the item's standard cost in the Act Unit Cost field.  If you are deducting from inventory, the system will use the average cost.  If the standard cost is not selected, the system will insert the item's average cost in the Act Unit Cost field.  You may accept it or enter a cost of your choice.  If you are entering a negative adjustment, the current average cost is used and you are not allowed to change it.  The Reference field is used when entering A type (adjustments) transactions.  You may enter a short note describing why the adjustment was made.

When entering a type S (shipments) transaction, the cursor will advance to the Invoice No field.  You may enter the invoice number, the customer code (you may press F2 or click on the Lookup button for a lookup), and the selling price, if applicable.  Type S transactions allow you to use another order entry/invoicing system but still relieve inventory.  You may override the customer name if you wish to use the field for notation purposes.

When entering type P (purchase order receipts) transactions, the cursor will advance to the Purch Ord No field. You may enter the purchase order number and the vendor code (you may press F2 or click on the Lookup button for a lookup).  You may override the vendor name if you wish to use the field for notation purposes.  There is no need to enter a purchase costhe Act Unit Cost field in the upper portion of the screen is for this purpose.

If the item being adjusted is coded for lot or serial control, you will be required to enter a lot or serial number as applicable.  After completing the last field, you will be asked if you wish to save the record.  Press  <Enter> to do so.