On Hand Qty by Product Group

** This utility is under development and is not yet available. **

This program updates the inventory quantities at the different locations by Product Group.

PRODUCT GROUP

<F4> Select a product group number or look it up in the Window.

DATE

This date will be used as the Adjustment Date, to note the quantity changes when Inventory Adjustment records are automatically written. This affects Inventory Value Reports.

SORT BY PROD#, DESC OR BIN (P/D/B)

Enter P to list products sorted by product number order.
Enter D to list products sorted by product description order.
Enter P to list products sorted by the product's bin location. If this option is selected, two additional columns, 'Bin' and 'Div' are displayed on the following screen.

TYPE OF ADJUSTMENT

Enter the type code for this adjustment or press <F4> to select one from the window. This adjustment type controls the G/L posting account to be credited for the inventory adjustment amount.
These types can be setup in Inventory Adjustment Types.

PRODUCT NUMBER

The Products will list in Product # order or Description order within that Product Group.

DESCRIPTION

The product description will appear on the screen.

Y Column

Press Right Arrow once to reach the Y column. To open the window, press the <F4> Window Key.
The inventory quantity for each locations is displayed, similar to Sales Inventory or Rental Inventory.

To make changes, use the Up/Down Arrow keys to reach the desired locations. Then arrow to Quantity field and type in the desired amount. p> To add new locations, press ADD Key and record the new location & quantities.

ON HAND

The total quantity currently owned will display.
This is the sum of the quantities on the location records.

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 opens to add or remove a serial number to match the quantity adjustment being made.

Press the Accept key twice to accept the quantity changes entered.

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.