Working with the Suggested Return P/O Queue

After you populate the Suggested Return P/O Queue, display the queue's contents to show the overstock products that you can potentially return to your vendors. In addition, you can filter the queue to include only products that are returnable, and not those that are set as non-returnable.  You can also view or print the  Suggested Return P/O Report directly from the queue for insight in to which products in a buy line have overstock that you can return to the vendor.

Using the queue helps you to work with your vendors and to decide which products you want to return, and convert the suggested returns into actual return purchase orders.

To display the Suggested Return P/O Queue:

  1. From the Purchase > Queues menu, select Suggested Return P/O Queue to display the Suggested Return P/O Queue window.

  2. In the Branch field, enter the branch you want to display. To display all branches, type All.

  3. In the Buyer field, enter the buyer's queue you want to display. To display all, leave this field blank. To assign a buyer, see Assigning Buyers to Buy Lines.

  4. Select the Non-ReturnableProducts check box to include the products that you have marked as non-returnable in Product Maintenance. Leave this check box deselected to review the queue without the non-returnable products.

  5. Click Update to display the overstock products that meet your selection criteria.

Field

Description

Br

The purchasing branch for the buy line.

Buyer

The user assigned to purchase products for the buy line.

Buy Line

The buy line that contains products included in the overstock inventory. If you use the Vendor Scorecard and have built a Vendor Scorecard file, the system uses the overstock days used to build that file to determine which products are considered overstock. If you have not run a Vendor Scorecard build, the default overstock days is 90.

Return Qty

The total number of items suggested for return in the buy line.

Return Amount

The total dollar amount of the returnable items in the buy line.

  1. To view information about the products in the buy line, select the buy line and select File > View Report or File > Print Report to display the ClosedSuggested Return P/O Report.

    Use the Suggested Return P/O Report to gather insight in to which products in a buy line have overstock that you can return to the vendor. For each product in the selected buy line for the branch displayed in the queue, the report shows the following information:

    Field

    Description

    Prod ID

    The Eclipse ID assigned to the product in Product Maintenance. Click the ID to display the product record.

    Description

    The product included in the buy line.

    Onhand

    The total amount of the product that you currently have in sock and tagged to future orders.

    Committed

    The total amount of the product that you have in stock committed to sales and transfer orders.

    Available

    The amount of stock that is currently uncommitted to any order.

    RetQty

    The total number of the product suggested for return.

    BuyPkg

    The number of the product that come in a package. For example, a package might have 5 of a particular product. Your vendor might not take anything less then the buy quantity as a return.

    Days Supply

    The number of days of supply of the product you have based on your current inventory levels.

    12moSls and 1moSls

    The amount of the product you sold in the last year and the last month.

    Order Point

    The minimum amount of stock you want to have on the shelf at any given time to meet your demand. For more information, see How the System Calculates Order Points.

    Min and Max

    The minimum and maximum amount of the product that you should have on hand.

    Demand

    The 30-day demand system-calculated demand for the product.

    Unit Cost

    The cost per each of the item.

    Return $

    The unit cost times the return quantity, which equals the total dollar amount of the overstock items available for return.

More Options When Working in the Suggested Return P/O Queue

The following options are available when working with suggested returns in the Suggested Return P/O Queue:

To...

Select this menu...

convert a line item in the queue into an actual return purchase order for the vendor.

Edit > Convert to Actual POs

view information in Buy Line Maintenance for the selected buy line.

Maintenance > Buy Line Maintenance

to run the Suggested Return P/O Report for a different set of buy lines or purchasing branches.

Edit > Recalculate

to remove the selected entry from the queue.

Edit > Delete

See Also:

Suggesting Return P/Os for Overstock

Converting Suggested Returns into Actual Return P/Os