Product Needs Analysis Report overview

Product > Reports > IC Reports > ICRIN

Function acronym: ICRIN

Use this report to compile product status information that can be used to make purchasing decisions.

The report includes products, vendors, product lines, and quantity status from Product Warehouse Product Setup balances information. Order point and line point quantities from the Product Warehouse Product Setup ordering information are also included. The product stocking unit is from the Product Setup record.

You can run this report to include only order-as-needed (OAN), do not reorder (DNR), or all products regardless of the status of the warehouse product. You can also clear these ordering controls in Product Warehouse Product Setup for OAN and DNR products:

  • Line Point/Maximum
  • Order Point/Minimum
  • Order Quantity
  • Method

If the ordering controls are not cleared, any on-hand balances are considered surplus.

This formula is used to calculate the available quantity of a product:
  • On Hand - Reserved - Committed - Demand - Back Ordered + On Order + Received

The demand value represents warehouse transfer demand. The quantities are expressed in the stocking unit for the product

You can include alternate vendor information on this report. The alternate vendor information is from the Product Extended Product Cross Reference Setup record. If you include alternate vendors, this information is included on the report:

  • Alternate vendor number
  • Product name
  • Price
  • Lead time
  • Buying unit
  • Standard pack

This report is not restricted by authorized replenishment path (ARP) requirements. The report can be generated on any warehouse regardless of the ARP that is specified in Product Warehouse Description Setup.