What the Suggested P/O Report Shows

Description

Displays buy line name, date and time of report, branch information, target, line buy days and minimum cycle.

The system-assigned ID for the product.

The description of the product as listed in Product Maintenance.

The purchasing branch for this suggested product.

The rank assigned to the product. The first three ranks of this product display based on the purchasing branch.

The lead time plus the order cycle used plus the safety stock. The system uses the LT Used and adds the LB Days calculated on the suggested purchase order. The system uses the resulting value to calculate the safety days by applying the lead time variable.

The maximum economic order quantity (EOQ) for the product.

Displays in the header of the report. This is the incurred cost to keep items on the shelves in the warehouse. This value displays if the branch is null and the calculated carrying cost is greater than zero. Otherwise, this column does not display. This applies to both Target #1 and Target #2 values which display stacked in the heading.

The projected inventory level for the product.

If you have the Add PIL flag set on the Add Demand window off User Controls a message displays indicating how the PIL calculation has been affected by the setting.

The following symbols display in the following conditions:

The monthly demand of the product in the network. Demand is defined as the number of days to show often a customer requests a product whether the product is on the shelf or direct shipped to them.

The number of items required to purchase to bring an item currently below its order point back to its order point.

The number of dollars required to purchase to bring an item currently below its order point back to its order point.

The quantity multiple in which stock may be purchased or transferred, depending on the product divisibility and economic order quantity relative to transfers and the availability of stock in the parent branch.

The cost for a single item.

The calculated quantity required of this product when purchasing the entire buy line.

Total dollar value of the line buy for each item.

The vendor target for the buy line.

The second vendor target for the buy line.

Description

Number of months supply on hand in your warehouse for this product.

Number of months supply on currently open purchase orders. This can help you determine if you truly need to order more. You may want to remove this item, if you already have plenty coming in on other purchase orders.

Total dollar amount for the short quantity buy.

Each item's contribution to the second target value, if one is setup in Buy Line Maintenance.

Total dollar amount for second target value, if one is setup in Buy Line Maintenance.

The calculated quantity required of this product when purchasing the entire buy line for the second calculated target, if one is setup in Buy Line Maintenance.

The on hand quantity of this product, minus any commitments through sales orders.

The available quantity in the purchase branch of the suggested product.

The Stock column setting in the purchasing branch. Options are Auto, Yes, or No.

Indicates if the purchasing branch is flagged to calculate demand.

Each item's contribution to meeting the vendor target. If you have a second vendor target, this number is only the contribution to the first vendor target.

The date the purchasing branch first received the item. This column can help identify new products.

Lists all the branches under the product suggestion. Use this only if you have a central purchasing procurement group, so you can see the same information display on the report for each individual branch.

The dollar amount indicating the sales for the last twelve months for this product.

Lead time used for the suggested purchase order. Lead time calculations are based on several factors. For more information about lead time, see How the System Calculates Lead Time.

The total dollar amount for the target line buy. If you have a second target set, this value is only for the first target.

The days' supply based on the line buy quantity from the target. If you have a second target set, this value is only for the first target.

The quantity required to purchase the entire line. If you have a second target set, this value is only for the first target.

The line point for the product. This is the upper limit to the amount of stock you want to have on the shelf for a given item so a warehouse can meet demand during the order cycle of the product.

The maximum quantity loaded at the purchasing branch for the item.

The minimum quantity loaded at the purchasing branch for the item.

Displays the branches in the network on the suggested purchase order. Using only if you run a  central purchasing warehouse.

Displays a summary of all the surplus in the network of the branches. For example, the report can display Note: 38 are in surplus at other branches in this column.

Amount of this product currently on an open purchase order.

Amount of this product currently on an open transfer.

Order point of the product. This is the minimum amount of stock you want to have on the shelf for a given item so a warehouse can meet demand while waiting vendor replenishment.

This column displays the branch value or the summary line depending on your replenishment method.

How many days' supply you have in your warehouse based on the projected inventory level (PIL) calculation.

The procurement group defined by the product. If not defined, the system displays the group from the buy line. Procurement groups define how products are replenished to the branches and identify emergency procurement sources.

Displays one of the following:

• Y - Indicates the branch has available override fields populated.

• N - Indicates no branch record or the branch record has no fields with Product Forecast Parameters selected.

This column shows users whether individual overrides have been set at the product and branch level and lets users drill directly into the Product Forecast Parameter settings, such as forecast methods, lost sales, exceptional sales %, trend %, and EOQ. Drilling directly to these parameters allows for quicker review and updating, when needed.

The purchasing unit of measure for the product.

The short buy, meaning the amount to buy to replenish the line.

Displays the safety factor of the product in the purchasing branch. Safety factor is the value to adjust the hits related safety coefficient (HRSC) applied to the product at an individual branch. This value displays in the Product Order Points/Line Points screen.

Customer service stock, also called manual safety stock, is a quantity added to the normal stocking level of a product for a period of time. For more information about what this is based on, see Adding Customer Service Stock .

Displays the surplus branches and their monthly demand.

Displays the surplus branches and procurement groups of the product. If this is not defined at the product level, the system displays the buy line procurement group.

Displays the surplus branches and the associated PIL.

Displays detail on surplus at all branches.

Displays how much surplus you have of the product throughout the network the product is in.

Summary of surplus at all branches.

Displays how much surplus is available in only those branches for which the user running the report is authorized.

Displays how much surplus is available in only those branches for which the user running the report has defined for inventory inquiry in Branch Maintenance.

The product unit cost. The Detail Queue from the Suggested P/O Queue displays the unit cost based on ay buy matrix defined for the product or buy group.

The weight of a single unit of the product. This is helpful when your target is in pounds.