Reorder Notification (POPI2.PO20)

The Reorder Notification (ibis_popi.2.po20) view allows you to review the reorder requirements, used by the purchasing agent when reordering stock. There are multiple search criteria available allowing you to search for and sort the data as required. For example, you can search for products that have fallen below their Re-Order Point (ROP).

  • The reorder notification view includes pricing details and the current replacement cost of each product plus an embedded view which lists all applicable quantities (ROP, ROQ, On Hand, On Reserve, On Order, and so on). The embedded view also includes the unit sales to date and the average units for the current year (YTD) and unit sales and average units for the previous year (LYR).

  • Note: The unit sales figure is taken from Invoice & Credit Note Update (ibis_in43). The system keeps track of how many months each product has been active for in the current year and the previous year. These counters (which are updated by S/A Sales Fiscal Period Close (ibis_sa89)) are used in the calculation of average units for YTD and LYR. The calculation is units sold (YTD/LYR) divided by the number of months active (YTD/LYR).

The following list defines the fields available in the reorder notification (popi.2) resource in alphabetical order:

  • Company - the company defaults to the company assigned to your user id in the Session Parameters view. You cannot modify the company in this view.

  • Country of Origin - displays the country in which the product/supplier record originated.

  • Created By - displays the name of the user who created the record you are viewing or maintaining. May not be overridden.

  • Created On - displays the date on which the record that you are creating or maintaining was created. May not be overridden. May also represent the creation date of the records you are attempting to retrieve.

  • Currency - displays the currency for the product/supplier record.

  • Description - displays the product description from the Products (ibis_ici1.im13) view.

  • Discount - displays the discount assigned to the product from the supplier.

  • Discount 2-7 - displays the discount for the product from the supplier for each quantity break.

  • Duty Rate - displays the duty rate assigned to the product/supplier record.

  • Endangered Species - displays the endangered species associated with the product/supplier record.

  • End Date - displays the promotion end date assigned to the product/supplier record.

  • From Purchasing Unit - displays the quantity of units purchased from the supplier for the product.

  • Fumigation Required - displays whether or not fumigation is required for the product from the current supplier.

  • Internet Web Address - displays the supplier's web page for the current product.

  • Intranet Web Address - displays your intranet web page for the current product.

  • Lead Time - displays the total lead time which is calculated as:

    Lead Time in Days + Transit Lead Time Override

  • Lead Time in Days - displays the lead time in days required to manufacture the product once a PO has been placed.

  • Manufacturer's Suggested List - displays the manufacturer's suggested retail price for the product.

  • Minimum Order Quantity - displays the supplier's minimum order quantity for the product.

  • Modification Counter - this field is not maintainable. The date and time the record was last modified.

  • Modified By - this field is not maintainable. The user or system process that last modified the record.

  • Modified On - this field is not maintainable. The date on which the record was last modified.

  • Nested Inventory Master Warehouse Information - displays the Inventory Master Warehouse Information view.

  • Port - displays the port assigned to the product/supplier record.

  • PO Exchange Rate - displays the purchasing exchange rate assigned to the currency associated with the product/supplier record from the Currency Entry (ibis_cc22) program.

  • Price - displays the promotional price offered by the supplier, if applicable.

  • Price Per Unit of Measure - displays the price per unit of measure for the product.

  • Primary Supplier - displays the primary supplier for the product from the Products (ibis_ici1.im13) view.

  • Product - displays the product code associated with the supplier.

  • Promotion Discount - displays the promotional discount offered by the supplier for the product.

  • PUM Numeric Value - displays the quantity associated with the current purchasing unit of measure.

  • Purchase Price - displays the purchase price for the product from the supplier.

  • Purchase Price 2-7 - displays the purchase price for the product from the supplier for each quantity break.

  • Purchase Quantity - displays the purchase quantity for the purchase price, discount and landed costs for the product supplier record.

  • Purchase Quantity 2-7 - displays the purchase quantity associated with the quantity break fields for the product supplier record.

  • Purchasing Criteria - displays the purchase criteria for the product supplier record. the purchase criteria is used in the recalculation routine for maximum stock, safety stock, line point and order point.

  • Purchasing Unit of Measure - displays the smallest unit in which the product can be purchased from the current supplier.

  • Replacement Cost - this is a calculated field. Displays the replacement cost for the current supplier. For more information, see the Replacement/Landed Cost Calculation help topic.

  • Shipping Terms - displays the shipping terms assigned to the product/supplier record.

  • Standard Pack Size - displays the inner quantity of the GTIN flagged as the default costing record from Product Pack Info (ibis_im23).

  • Start Date - displays the start date of the supplier's promotion for the product.

  • Supplier - displays the supplier code.

  • Supplier's Product Code - displays the supplier's product code assigned to the product.

  • To SKU - displays the quantity of stock keeping units the purchasing units should be converted to.

  • Transit Lead Time Days - displays the supplier's default transit lead time (in days).

  • Transit Lead Time Days Override - displays the number of days required to ship the product from the supplier once the product has been produced.

  • Visa/Quota Required - a value of Yes indicates that a Visa/Quota is required for the product from the current supplier; a value of No indicates that nothing additional is required for the product from the current supplier.