Purchase Demand Center Entry - Run PO RRAR Report field descriptions

Specify a product line to limit the report by product line.

Specify a vendor to limit the report by vendor.

Specify a warehouse to limit the report by warehouse.

If a product's purchasing net available quantity is below order point and is in class 1 through 4, an exception exists.

Select Yes and the PO RRAR will suggest ordering a greater quantity to compensate for the low product level. The formula used is the 1/2-Way Rule: {1/2 (Order Point + Line Point) - PO Available} + Order Quantity.

Select No to not use the halfway rounding rule for qualifying products.

In addition, if the Product Line Setup Use ROQ? field is selected, the setting for this option is applied to the vendor’s recommended order quantity for the product line.

Use this option to exclude POs from the replenishment calculation based on their Due Date. When calculating replenishment requirements, a product’s On Order quantity in Product Warehouse Product Setup is subtracted from Demand. If POs exist with a Due Date weeks or months in the future, but you have immediate demand or backorders, specify a number of days out in this field to exclude those future POs. Those products are included on the PO RRAR so you can review other sources for filling orders.

For example, a purchase order was created for product ABC from an overseas vendor. The PO’s Due Date is 45 days from today. You have backorders for the product, and you know you can purchase it locally for a speedier delivery. Specify 45 or less in the Exclude Due Days Greater or Equal field to exclude that PO from the replenishment calculation. The product is included on the RRAR because the demand does not take into account the PO with the long lead time.

If Exclude Due Days Greater or Equal is blank or zero, no POs are excluded based on Due Date.

If the Print Only Specials/Non-Stock/Rush Lines? option is set to Yes, this option is relevant.

Select Yes and multiple purchase orders per vendor are created depending on the product line of the nonstock or special products.

Select No and only one purchase order per vendor is created. The purchase order contains all the nonstock or special products for the vendor but without product line information.

Select Yes to include alternate vendors so you can compare prices or target buy requirements to obtain the best possible price. For each product, the Product Extended Product Cross Reference Setup records are checked for alternate vendors.

The alternate vendor number, name, product, unit, price, standard pack, and lead time are included on your report if you choose to print alternate vendor information. This provides informative data only, since a PO RRAR line is not created.

If the alternate vendor is no longer valid or the vendor is inactive, the vendor's number and name is not printed.

When a special or nonstock product is entered in Sales Order Entry or Transfer Entry, the customer or warehouse may have specific instructions that are helpful to the buyer reviewing the PO RRAR.

Select Yes to review your Do Not Reorder products. This option corresponds to the Status field on the Product Warehouse Product Setup record. Because of the product’s status, a purchasing decision must be made to place the item on a purchase order.

Do Not Reorder products are included on the report based on the ordering controls and order quantity established in Product Warehouse Product Setup.

Select Yes to include Blanket Releases (BR) for the vendor and all specified warehouses.

This is beneficial in eliminating duplicate orders and can increase your buyer's efficiency by combining the blanket releases with purchase orders for products needing replenishment. This reduces your outgoing costs and the blanket release product can contribute to achieving the vendor's target.

If a Blanket Order (BL) is entered by a buyer other than the assigned buyer, all the Stage 0 (Entered) BRs for the vendor/warehouse match are printed, as well as the buyer who entered the BL.

Outstanding orders that are converted to cover the demand for the stocked product may also be included on a PO RRAR line.

Select Yes to generate only special, non-stock, or rush orders. All lines marked as such are expedited. This includes all stocked lines with a quantity shipped less than quantity ordered, non-stock lines, and specials. The vendor number, buyer, and warehouse/buying group ranges and options entered above apply to the special, non-stock, and rush lines.

Select Yes to include allowable substitutes and supersedes. By including the substitutes and supersedes on the report, you can see that the original product quantities should be used prior to selling the new product. This message is displayed: Products Superseded by Product ###.

For each substitute/supersede product that is printed, the price, on order and net available quantity is included. This is for information only, since a PO RRAR line is not created.

For each product, the Product Extended Product Cross Reference Setup records are checked for substitute and supersede records.

If the Product Setup or Product Warehouse Product Setup record no longer exists, if the product is not active, if it has a direct order only status, or is a kit product, the substitute/supersede product is not printed.

If you leave the default No for this option, the product is checked for old, superseded items. If purchase net available exists for the superseded item(s), this message is printed on the report: ** Superseded Product(s) Exist With Purchase Net Available; Review Purchase **.

Select Yes to capture usage history to establish a pattern of usage while making replenishment decisions. The usage rate from Product Warehouse Product Setup, as calculated by Product Administrator Month End Processing Report, is displayed as the usage amount, with the following exception conditions. Occasionally the usage shown does not equate to the usage rate. This occurs if the usage rate has been overridden or if the product is frozen and the usage rate is not calculated.

If the usage has been manually overridden, the overridden usage is displayed instead of the usage calculated by Product Administrator Month End Processing Report. The override is used even if it is 0 and actual usage exists. If override usage exists and no reason exists, ** is displayed.

Each time you manually override the usage for a product, you can specify an override reason. If an override reason exists, it is displayed next to the overridden usage.

If a stock out condition occurred during a particular period (Stock Out Days > 0), SO is displayed next to the usage. If the usage was overridden as well, the overridden usage is displayed.

If you select Yes, usage is included on your report based on these factors:

• The product is seasonal. The last 24 months of usage is displayed on the report and the Usage Control field in Product Warehouse Product Setup is overridden. Buckets 2 through 25 from Product Warehouse Product Setup are used regardless of the Usage Control field.
• The usage from this table is printed based on the Usage Control field for non-seasonal products in the Product Warehouse Product Setup record.

  Product Warehouse Product Setup Usage Control field	Usage printed on PO RRAR
  Forward	12 Months, Buckets 2-13
  Backward	6 Months, unless Product Warehouse Product Setup # of Months is greater than 6, then 12 Months, Buckets 2-7 or 2-13
  Trend %	24 Months, Buckets 2-25
  Blank	6 Months, unless Product Warehouse Product Setup # of Months is greater than 6, then 12 Months, Buckets 2-7 or 2 -13

Select No and usage is not printed on the report.

This option assists the buyer when a special buy must be made for a product line.

Select Yes and all products for the line being reported are included on the report regardless of the IProduct Warehouse Product Setup On Hand quantity. The quantities on the report default to the standard order quantity. The approval setting on the corresponding PO RRAR Acceptance is set to No. The buyer must indicate what products to accept.