As many of you already know, the Supply/Demand Inquiry (a.k.a. S&D Inquiry) screen is used frequently. Many MRP users rely on S&D Inquiry more than they do the MRP Time Series. However, how many people really look at all of the functionality that S&D Inquiry can perform?
Supply & Demand Inquiry displays data input from six major applications:
|MRP||P3482 or P3483 and F3411, F3412 and F3413|
|Forecasting||P3460 and F3460|
|Purchase Orders||P4311 and F4311|
|Sales Orders||P4211 and F4211|
|Work Orders||P48013 and F4801, WO Parts List (P3111) and F3111|
|Rate Schedules||P3109 and F3109|
Accessing these applications is as easy as inquiring on an item number and branch plant. From there, the following selection options are displayed:
|Work Order Header||1|
|Work Order Detail||2|
|Sales Order Entry||3|
|Purchase Order Entry||4|
|Customer Service Inquiry||5|
|Purchase Order Inquiry||6|
|Enter/Change Rate Schedule||7|
|Return Promise Delivery Date||8|
Several function keys also work within S&D Inquiry as well. They are:
|Header 1||Header 2|
|Time Series / ATP Inquiry||F15|
Several requests have been received to see if the sort can be changed within this inquiry program. However, there is no processing option or other type of setting that will allow you to change the sequence or order in which records display in the P4021. The records, both supply and demand, that appear in the P4021 are displayed in the video because those order lines have reached a "Selected" status value as defined in the Supply/Demand Inclusion Rules (P34004) for the related order type/line type.
Note: In order to determine which Supply/Demand Inclusion Rule is used in your inquiry, processing option 6 in the P4021 tells you.
Best Practice for MRP Users:
When analyzing MRP data, users should focus on the Time Series (P3413) and use the S&D Inquiry to obtain details such as order numbers. The Time Series will display both adjusted and unadjusted values while S&D Inquiry uses unadjusted values only. “Unadjusted” means that the user has not acted on (or processed) any of the MRP messages that are displayed in the MRP Detail Message screen (P3411). In other words, users would be looking at a ‘worst-case scenario’. “Adjusted”, on the other hand, means that the user has processed some or all MRP messages and that as a result, the beginning - and ending - available inventory, as well as the planning for future WOs or POs will be affected.
For additional information about Supply/Demand Inquiry see Understanding Supply & Demand Inquiry P4021 (Doc ID 1933828.1).