Viewing Product Demand Information

Use the Primary Inventory Maintenance dialog box to view product information related to inventory management.

• The system continually updates the product's projected inventory level (PIL) and order/transfer point (OP/XP) in real time.

• The system updates the remaining fields in the window each time you run the Update Product Demand Forecast program for the product.

When you assign a product the product status of Stock, the Primary Inventory Maintenance window displays a summary of the product's current demand information.

When you assign a product the status of NonStock, the system does not calculate the order point, line point, Economic Order Quantity (EOQ), and monthly demand.

To view product demand information:

1. From the Maintenance menu, select Product to display the Product Maintenance window.

2. Display a product record.

3. From the Inventory menu, select Primary Inventory Maintenance to display the Primary Inventory Maintenance dialog box.

4. In the Br column, review the branch numbers and types.

Branch or warehouse identifiers with letter suffixes indicate the warehousing scheme used for replenishing that product. These lines display calculated information for all branches combined under the defined warehouse scheme.

5. In the Stock column, review whether the item is a known stock (Yes) or nonstock (No) item, or whether the system calculates (Auto) the stock or nonstock status based on the number of hits the product receives in a branch warehouse network.

The product's stock or nonstock status can be set in the Additional Inventory Parameters dialog box.

6. In the Buy Pkg <unit of measure> column, review the quantity multiple in which stock is purchased or transferred. For example, if set to 6, stock is purchased or transferred in quantities of 6, 12, 18, 24, and so forth.

7. In the Div column, review whether the buy package can be divided either by the vendor when purchasing or by the warehousing branch before transfers occur.

Note: Both the Buy Pkg and Div columns remains blank if no territory is selected.

8. Review the fields, as needed, for each parent branch and child branch:

   Field	For a parent branch, shows the...	For a child branch, shows the...
   PIL	projected inventory level.	projected inventory level.
   OP/XP	order point. If a minimum-only is set for the product, the system uses that minimum as the order point until the calculated order point exceeds the minimum-only setting. The system then uses the calculated order point. Minimum-only is in effect when a lower case "m" displays after the EOQ value. If there is a min/max order point set for the product, the min is always the order point and an upper case "M" displays after the EOQ value. Note: The order point displays as a whole number.	system-calculated transfer point if there is no min/max order point set for the product. If the Respect Item Min/Max For Suggested Transfers control maintenance record is set to No, the system checks the Max setting for the product. If there is a min/max set for the product, the transfer point is the max and an uppercase "M" displays next to the EOQ value. If there is no min/max set for the product, the system uses the system-calculated transfer point. If there is a minimum-only set for the product the system uses the minimum-only is in effect when a lowercase "m" displays after the EOQ calculation.
   		If the Respect Item Min/Max For Suggested Transfers control maintenance record is set to Yes, the system checks the min setting for the product. If there is a min/max set for the product, the transfer point is the min and an uppercase "M" displays next to the EOQ value. If there is no min/max set for the product, the system uses the system-calculated transfer point. If there is a minimum-only set for the product, the system uses the minimum-only as the transfer point until the calculated transfer point exceeds the minimum-only setting, the system uses the system-calculated demand. A minimum-only is in effect when a lower case "m" displays after the EOQ value. Note: The transfer point displays as a whole number.
   Low Sale <unit of measure>	lowest sale in the branch within the forecast period.	lowest sale in the branch within the forecast period.
   EOQ	Economic Order Quantity, based on the combined demand of the multi-branch network. When the low sale quantity exceeds the calculated EOQ, the system uses the low sale quantity in place of the EOQ in associated calculations. In this case, the field displays with an asterisk to indicate the exception. An uppercase "M" in this field indicates that the system is using the min/max setting as the transfer point. A lowercase "m" in this field indicates that the system is using the minimum-only setting as the transfer point.	Economic Order Quantity for the item in the branch. An uppercase "M" in this field indicates that the system is using the min/max setting as the transfer point. A lowercase "m" in this field indicates that the system is using the minimum-only setting as the transfer point. An EOQ with no letter indicates that the system is using the system-calculated transfer point.
   	An EOQ with no letter indicates that the system is using the system-calculated transfer point. An uppercase "M" in this field indicates that the system is using the min/max setting as the transfer point. A lowercase "m" in this field indicates that the system is using the minimum-only setting as the transfer point. An EOQ with no letter indicates that the system is using the system-calculated transfer point.
   Monthly Demand	monthly demand for the item in the branch.	monthly demand for the item in the branch.
   Monthly Hits	monthly hits for the item in the branch.	monthly hits for the item in the branch.
   Leadtime XF Cycle	product's lead time for a purchasing branch.	transfer cycle days for selling (child) branches.
   Safety LT Day	number of lead time safety days for the item in the branch.	number of lead time safety days for the item in the branch.

9. When you have finished reviewing the information, exit the dialog box.

More Options in the Primary Inventory Maintenance Dialog Box

The Primary Inventory Maintenance dialog box also offers these options:

See Also:

Updating Product Demand Overview