Understanding Supply-and-Demand Information

Use the Supply/Demand Inquiry (P4021) program to review demand, supply, and available quantities for a specific item. You can review general product and item performance for a specified branch/plant, as well as past sales performance, current demand, and other item information. The information is based on inventory, purchasing, and sales history.

The highlighted available-to-promise (ATP) lines on the Supply/Demand Inquiry form indicate the company's uncommitted available inventory. Available-to-promise inventory is available for sale or distribution within a specified period.

The demand quantities are listed by date and can include safety stock, quantities on sales orders, work order parts lists, planned order demand for lower levels, and interplant and forecasted demand.

The supply quantities are listed by date and can include on-hand inventory and quantities on purchase orders, manufacturing work orders, planned orders, and rate schedules. Supply quantities without a date or order information represent current availability by branch/plant storage location.

You can also access these forms to confirm detail information:

  • Work With Order Scheduling

  • Parts Availability

  • Work With Detail Messages

  • Work With Time Series

  • Work With Pegging Inquiry

  • Work With Item Availability

  • Customer Service Inquiry

  • Plant Manufacturing Data

The system displays information from these tables:

  • Item location File (F41021)

  • Sales Order Detail File (F4211)

  • Purchase Order Detail File (F4311)