Re: Single Level Where-Used with On Hand, On Order

[Gcschramm@xxxxxxx]

Philip,
See if this gets you close to your requirement...
Create a Query linking PSTRUC to ITEMBL where PINBR equals ITNBR.  You probably 
would want to select one warehouse at a time.  Sort on CINBR.  Include the 
fields you need.  Output to a file and download into Excel.  Once in Excel you 
can pretty it up if you want and perhaps make other calculations.  If your 
requirement is stricly for a display, output to the display, create a MAPICS 
menu option of a CL program that runs the query with RECSEL equal to *YES.
And remember that free advice, even mine, is probably worth exactly what you 
pay for it...
Best regards,
George