BAQ - Demand Qty

Yahoo Archive
1
PartWhse has the demand separated into fields like unfirmjobdemand, SalesDemandQty, etc.  If using the PartDtl you need to filter on sourcefile and type.  The Pegging tables work too.

Many way to determine demand.  I guess it depends on your query.  I usually use the PartWhse table.
2
I'm writing a query and need to show ALL open / unfulfilled/ etc. demand for a part.  What fields would I need for this?  If find a lot of demand qty fields in many tables and want to show ALL demand.

Thanks,
Renee | EMT International
3

Try partdtl in v8

Sent from Yahoo Mail on Android


From: fite2be@... <fite2be@...>;
To: <vantage@yahoogroups.com>;
Subject: [Vantage] BAQ - Demand Qty
Sent: Thu, Feb 13, 2014 2:48:52 PM

 
<div id="ygrps-yiv-2085352326ygrp-text">
  
  
  <p>I&#39;m writing a query and need to show ALL open / unfulfilled/ etc. demand for a part.  What fields would I need for this?  If find a lot of demand qty fields in many tables and want to show ALL demand.<br clear="none"><br clear="none">Thanks,<br clear="none">Renee | EMT International</p>

</div>
 


<div style="color:#fff;height:0;"></div></div>
4
Thanks Robert, didn't find anything in PartDtl relating to demand - am I missing something?
5
Your best bet may be to enable Multi Level Pegging in the MRP run.  You can then query the Pegging tables and see both the demand and the supply that is tied to the parts.

John