Replenish Inventory for Current Back-Order Needs

Access

Use this routine as an alternative to the Replenish Stock Inventory Based on Sales Rate routine (Automatic PO Replenishment). This routine searches the system for open (that is, back-ordered) sales orders.  You can examine the search results to find the items you want to add to new purchase orders.

The search results include only unlinked, unreserved items. In this way, you can replenish your inventory on an "as-sold" basis.  

The search excludes hard kits and their components.

To access this routine, the log-on user must have access via the View and access product cost information field in the Extended Security settings.  

You can search for back orders by a range of dates, restricting the results by

You can choose to include or exclude

The system sorts the report by vendor and provides the following options for secondary sort:

When you click on Run, if your selection criteria finds any products, the Inventory Replenishment Items screen appears in which the products display in the grid. To order all the items in the grid, click on Save. The system creates purchase orders for the selected products with links to the associated sales orders. A message appears displaying the numbers of the purchase orders created.  

You can use the Inventory Replenishment Items screen to exclude one or more grid items from your purchase orders, and you can use the Place Additional Items on Purchase Order screen to add to the quantity of a line item.

When you create a purchase order from Inventory Replenishment, if the Buying Group feature is active (via the Activate Buying Group field in the Purchasing Control Settings), the system does not specify a buyer. You must re-access the purchase order later to specify a buyer. Otherwise, the system keeps the purchase order on hold.

If a purchase order’s type has the Include in Supply Calculation field checked, the purchase order is included as a source of supply, thus reducing the quantity that needs to be ordered.  If a purchase order’s type has this field unchecked, the purchase order is not included as a source of supply and has no effect on the quantity that needs to be ordered. The Include in Supply Calculation field is only evaluated for the min/safety levels and not for the back ordered sales portion of this process.

General

Location

Vendor

Product Group

Sales Order Range

Start Date

End Date

Options

Sales Date

Scheduled Date Only

Include ASAP Items

Include Special Orders

Include Service Items

Include Transfers

Stock Levels

Quantity Calculation Method

Calculations for Low Stock Levels

The following two fields affect the creation of purchase orders. Here are the results of combining these fields:

Create Purchase Order Per Sales Order Create Purchase Orders by Default Vendor Ship From  
Checked Checked For each sales order, all products for a Vendor Ship From are combined on a single PO for that Vendor Ship From. A separate PO is created for the product's Add quantity.
Checked Unchecked For each sales order, all products for a vendor are combined on a single PO for that vendor. A separate PO is created for the product's Add quantity.
Unchecked Checked All products for a Vendor Ship From are combined on a single PO for that Vendor Ship From.
Unchecked Unchecked All products for a vendor are combined on a single PO for that vendor.

 

Create Purchase Order Per Sales Order

Create Purchase Orders by Default Vendor Ship From

Sort By

The process that creates purchase orders checks the Create replenishment purchase order not on hold setting in Purchasing Security and the Minimum Order Quantity on the Costing page in the Advanced Product Settings. If the purchasing security setting is blank and/or the order quantity is less than the minimum order quantity, the purchase order is placed on hold.