Is there a way to see all parts assigned to a particular warehouse?

Hi- I'm a relatively new Visual user, and it seems like my question should have a simple solution but I haven't had any luck.

I would like to look up a warehouse and see what parts are assigned to it with the order policy of Master schedule. Is there an easier way to do this, other than opening each part individually?

Thanks,
Christy

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

unknown

Hi Christy, Open Admin then click query tool. In the resulting screen type in the following.

select * from PART_WAREHOUSE
where WAREHOUSE_ID = 'NAME_OF_YOUR_WAREHOUSE'

Gerald

0712131256598360.doc

unknown

If you're only looking for Master Scheduled parts, you'll need to join the part table.

select p.ID, p.[DESCRIPTION], p.ORDER_POLICY from PART_WAREHOUSE pw
inner join PART p on p.ID = pw.PART_ID
where pw.WAREHOUSE_ID = 'NAME_OF_YOUR_WAREHOUSE'
and p.ORDER_POLICY = 'M'

Jeremy

unknown

Good call Jeremy W!

marvin-schultz

Fantastic, thanks to both of you!
Incase someone else is looking for this solution, here is what worked for me:

When I tried to run the Query that Jeremy W provided, I received syntax error 156 "Incorrect syntax near the keyword 'ON'."

Because I'm inexperienced with SQL, I wasn't sure how to correct this. Instead, I combined the queries from glipford and Jeremy and ran this:

select * from PART_WAREHOUSE
where WAREHOUSE_ID = 'NAME_OF_YOUR_WAREHOUSE'
and ORDER_POLICY = 'M'

This gave me the information I was looking for.
Thank you so much!!

[Updated on 7/31/2012 12:11 PM]

Copyright © 2025 Infor. All rights reserved.