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?


For example:


Supply & Demand Inquiry displays data input from six major applications:


MRPP3482 or P3483 and F3411, F3412 and F3413
ForecastingP3460 and F3460
Purchase OrdersP4311 and F4311
Sales OrdersP4211 and F4211
Work OrdersP48013 and F4801, WO Parts List (P3111) and F3111
Rate SchedulesP3109 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:


Selection Option
Work Order Header1
Work Order Detail2
Sales Order Entry3
Purchase Order Entry4
Customer Service Inquiry5
Purchase Order Inquiry6
Enter/Change Rate Schedule7
Return Promise Delivery Date8
Transfer Orders9


Several function keys also work within S&D Inquiry as well. They are:


Header 1Header 2
Part AvailabilityF9
Scheduling WorkbenchF10
Message DetailF14
Time Series / ATP InquiryF15
Pegging InquiryF16
Item AvailabilityF17
Manufacturing ValuesF18


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).