On this page:
Use this page to adjust any of the following quantities in an Inventory Catalog record: Available Stock, On Order, Back Ordered, and Reserved. These adjustments allow you to correct data entry errors, as well as discrepancies related to damages, lost items, incorrect shipments, and other causes.
Menu Path: Warehouse Inventory > Entry & Processing > Warehouse Inventory > Warehouse Administration > click Enter Inventory Adjustments
Adjusting Inventory Quantities
Following are some points to keep in mind when adjusting the quantities of catalog items.
-
When you change the quantities for available stock and enter a unit cost different from the current average, the system recalculates the item's cost.
-
Based on settings in the associated Warehouse Code record, the available stock adjustments create or reverse charges for postings to the Fund Accounting System. For related information, refer to Process General Ledger Charges Page.
-
To make mass adjustments in response to physical inventory counts, use the Batch Inventory Transactions option. For details, refer to Batch Inventory Transactions.
Important
When processing back orders, use the Back Order option to adjust the Inventory Catalog and warehouse requests. Adjusting back orders using the Inventory Adjustment option only updates the Inventory Catalog. For details, refer to Back Order Page.
Adjusting stock quantities for catalog items
-
Select Warehouse Inventory > Entry & Processing > Warehouse Inventory > Warehouse Administration to display the Warehouse Administration page.
-
Click Enter Inventory Adjustments to display the Inventory Adjustments page.
-
In the Search Criteria section, enter criteria identifying the records to list, and then click Find. To run an advanced search, use the Advanced button.
-
In the List section, select a catalog record, and then click OK.
-
In the Adjustment Data section, enter the Adjustment Date, Adjustment Type, and Units (+/x).
The additional fields available depend on the Adjustment Type selected. For details, refer to the Fields section. -
Click OK.
-
In the Question dialog, click Yes to process the adjustment.
Depending on the Continuous checkbox:-
If you selected the checkbox, you return to the Adjustment Date field to enter an adjustment for the next item in the List section. Repeat Steps 5-7. Click Back when you finish with your adjustments.
-
If you left the checkbox blank, you return to the List section.
-
Fields
Adjustment Data Section
|
Fieid |
Description |
|---|---|
|
Adjustment Date |
Enter the calendar date for the adjustment being entered. |
|
Warehouse |
Code identifying the warehouse location where the item is stored. The warehouse code and stock number combine to identify a catalog record. Display only. |
|
Stock Number |
Code identifying an item in the Stock Number table. Display only. |
|
Adjustment Type |
Indicates the type of adjustment you are entering. Select: A - Available - to adjust the number of units on hand.
|
|
Units (+/-) |
Enter a positive or negative number to indicate the quantity that is being added or subtracted. For example, to add 10 units to the existing quantity, enter 10. To subtract 10 units, enter -10. Decimal/12,4 |
|
Unit Cost |
Per unit cost of the inventory item based on the average cost from the catalog record. You can only access this field if the Adjustment Type is either A - Available or E - Transfer. If you are adjusting or transferring available stock and the cost differs from the catalog item's average cost, enter the unit price of the stock item being added or subtracted. Otherwise, you may accept the default. |
|
Total Cost |
Total cost of the inventory items being adjusted or transferred. System-calculated. This field only applies if the Adjustment Type is either A - Available or E - Transfer. If so, the following formula is used: Units x Unit Cost = Total Cost |
|
New Average Cost |
Average cost of the available units from all catalog records, including the adjustments. System-calculated. This field displays a new average cost if the Adjustment Type is A - Available or E - Transfer. The following formula is used: (Available Units x Average Cost) + (Adjusted Units x Adjusted Cost) ÷ (Available Units + Adjusted Units) = New Average Cost |
|
Adjustment Reason |
Enter a note explaining the adjustment. Character/35 If the Adjustment Type is E - Transfer, the system defaults the phrase STOCK TRANSFER: FROM. You may add the code of the current location after the phrase or enter different text. |
|
Adjusted By |
Enter the ID, initials, or name of the employee who made the adjustment. Character/35 |
|
Adjustment Orgn |
Organization to be credited for the adjustment. The default is from the Warehouse Code table. This field only applies if the Adjustment Type is A - Available or E - Transfer. While you can change the default, usually you should accept the organization displayed. |
|
Adjustment Acct |
Account to be credited for the adjustment. The default is from the Warehouse Code table. This field only applies if the Adjustment Type is A - Available or E - Transfer. While you can change the default, usually you should accept the account displayed. The following fields only apply if the Adjustment Type is E - Transfer: |
|
Transfer To Warehouse |
Select the warehouse where the units are being transferred. |
|
Transfer To Reason |
Enter the reason for the transfer. The system defaults the phrase STOCK TRANSFER: TO. You may enter the code of the new location after the phrase or enter different text. Character/35 |
|
Transfer To Orgn |
Enter the organization to be debited for the adjustment. |
|
Transfer To Acct |
Enter the account to be debited for the adjustment. |