Update On Hand Quantity by Product#

This utility can be used to update the rental and sales inventory quantities at the different locations.
Quantity adjustments to Sales or Rental products update the Dated Counted by Location.
The prompts are:

PRODUCT #

Leave this field blank to list all products in product number order, or to narrow the resulting list, select a starting product number or look it up in the Inventory Search window.

DATE

Accept today's date or enter a preferred date to be used as the adjustment date if any changes are to be made to the inventory quantities.
The date of adjustment is used in date sensitive computations such as the Sales Inventory Value Report and Rental Inventory Value Report.

TYPE OF ADJUSTMENT

Enter the adjustment type code to account for these adjustments if any changes are to be made to the inventory quantities, or select one from the drop-down list, as setup in Inventory Adjustment Types.
This adjustment type controls the G/L posting account to be credited for the inventory adjustment amount.

Resulting Product List:

SEQ

The sequence number tracks the products listed in this table

PRODUCT NUMBER

The rental and sales products are displayed in product number order.

DESCRIPTION

The primary product description is displayed.

ON HAND

The total quantity owned at all locations displays.
This number reflects the current quantity, regardless of the Date entered, and can only be adjusted by updating the location quantity in the window, as follows:

SEQ

The sequence number tracks the locations listed in this table.
Quantities and Bin numbers can be changed and additional location records can be added.

LOC

The location is displayed.
Location records can be added or deleted from this Location Quantity table.

ON HAND

The current count at this location is displayed.
This can be updated as required.

If a quantity adjustment has been made for a serialized sales product, and the product is NOT flagged to enter serial numbers at "Time of Sale", the Serial Number window is triggered to add or remove a serial number to match the quantity adjustment being made.

An Inventory Adjustment record is written for each change in quantity recording the Date entered above and operator ID currently logged in.

BIN #

Accept or modify the bin discrepancy to describe the location of the stock.

Finished?

Click OK to accept the screen

Quantity Discrepancy:

On exiting the location window, if the quantity total on the Fixed Asset tags for the product does not match the current Quantity On Hand for the product, the Quantity Discrepancy warning window is triggered.

Finished?

Click ACCEPT to accept the quantity changes displayed on the screen and then CANCEL to exit.

After any changes to product quantities are completed, use Post Inventory Adjustments to print an audit report and to generate the G/L postings for the change in the Inventory value to balance the General Ledger to the changes just made to the Inventory sub-ledger.