Adjust On Hand

The Adjust On Hand function is used to add inventory to stock when no quantity currently exists or to return misplaced or lost inventory to the system. When performing adjustments from the main menu, users must specify the Facility, Location, and, in some cases, the Lot for the material being adjusted.

Inventory adjustments can also be performed directly from inventory reports, such as the Lot or Locations reports. Performing adjustments from these reports automatically pre-populates specific lots and locations, which reduces manual data entry and minimizes errors.

Critical Logic: During an adjustment, if there is a discrepancy in item attributes, cost, or location, the system will generate a new system lot to correspond with the selected user lot. Users must exercise caution: if the intent is only to change a lot value, ensure the location and attribute fields remain unchanged to prevent the creation of an unnecessary system lot.

Additional Adjustment Considerations

  • Security: Access is controlled by the "Inventory — adjust on hand" security setting for standard ERP adjustments and "WMS -- adjust on hand" for Warehouse Management System adjustments.
  • Serialization: Items configured for Unit Serialization or Container Serialization on the Item Master Properties tab require a serial or container number during the adjustment process.
  • Location Defaults: The system populates default locations by checking the Item Master Facility override, the Item Master default location, and the Facility's default Location/Type in that specific order.
  • Expiration Dates: If the "Require Expiration Date" flag is enabled on the Item Master, the system blocks adjustments if the Expiration Date is blank. For existing lots, the system retains the current Expiration Date during adjustment.
  • Reporting: The Adjust On Hand button is disabled in inventory reports if the "Display" filter is set to "All" or "Inactive."

System Navigation

  • Inventory > Adjust On Hand
  • Inventory > Inventory Reporting > "Adjust On Hand" button
  • WMS > Adjust On Hand

Inventory Adjustment Form Field Definitions

Field/Button

Description

Apply

Commits the changes and finalizes the inventory adjustment.

Part History

Opens the History Summary report for the selected part and Facility.

Part Number

The identifier for the item. This field is read-only when adjusting from Lots or Locations reports as the part is pre-selected.

Master Lot

The description of the Master Lot being adjusted. This allows for bulk adjustments of master lots without de-issuing individual system lots. Controlled by the "Inventory -- adjust out master lots" security setting.

Stock Pricing Factor

The ratio of stock pricing units per stock unit (e.g., Unit Weight divided by Pricing UOM Factor).

Adjust

Determines if the transaction modifies Quantity and Value or Value Only (Actual/Average cost modes only).

Lot Date

Sets the date for new lots. The Expiration Date is calculated as [Lot Date + Shelf Days]. If blank, the Transaction Date is used for the calculation.

Unit Cost

The cost per unit for the adjustment. The system prioritizes: 1. Facility-specific Last Cost, 2. Facility Part Cross Reference Std. Total, 3. Item Master Std. Total.

Lot / System Lot

Defines the user-facing and internal system lot identifiers. If the part requires a lot, "Lot required" is displayed; otherwise, "System" is used.

Expires

The calculated expiration date. Required if the "Require Expiration Date" flag is active on the Item Master.

Adjustment Account

The expense account debited for the adjustment. Defaults from the Reason Code or the Item Master.

Notes

Optional field for documenting adjustment details.

WMS Specific Buttons

Button

Description

Apply

Executes the WMS adjustment. Requires "Accounting -- backdate transactions" security for past-dated entries.

Find

Opens a search form to locate and select inventory for adjustment.