You may automatically generate a Return to Vendor for Overstock items.

NOTE: You must set the Order Level and Stock Level to the amounts that you want to keep on the shelf before running this program.

An Overstock condition exists when the Quantity on Hand is greater than the Stock Level. You will have the following options:

Enter <O> to Return Overstock Quantity (Qty to Return = QOH - Stock Level).

Enter <Q> to Return All Quantity on Hand (Qty to Return = QOH).

Enter <S> to Create a Return based on Sales History (Qty to Return = QOH - Qty Sold) within the date range. The <S> option also has a prompt for Location/Region used when creating a Return based on Sales History.

Enter <N> to Return All QOH with No Sales History within the date range.

If the <N> option is selected a return will be generated of items that have No Sales history within the specified date range and for the specified location(s). All QOH will be returned for units of measure that have no sales. For Case-Lot items, if any unit size has been sold in the specified date range, the part will not appear on the return. Note: Sales History = Orders, Consignments, In Store Use, and Component Use.

The Purchasing Source is a mandatory entry.

You may chose to Generate the Return only if the Vendor is the Current Source, if the Vendor is a Source or if the Vendor is not a Source.

The next option, Round Down to Standard Pack, allows you to Round Return Qty Down to nearest Standard Pack. This feature is useful for Vendors that require full case returns.

The automatic process will accumulate all Order Quantities Sold within the specific date range for the specific Location. If the difference between the Inventory QOH and the Quantity Sold is greater than zero, this will then Generate a Return of Merchandise to Vendor screen for you to update.