Solved

BAQ to Match Part Whse and Part Plant

  • 27 April 2021
  • 3 replies
  • 336 views

Userlevel 1

I am new to BAQ’s and banging my head against the wall. I am trying to create a simple BAQ that shows the On Hand Inventory for all our parts. I need the fields Company, Plant, Warehouse, PartNum, Part Descr, BuyerID, PersonID, and On Hand Qty. I know I need the PartWhse, PartPlant, and Part tables to accomplish this but I can’t figure out how to properly join the PartWhse and PartPlant tables. 

Any advice on how to make this happen? Any way  have tried has either ended up with all my warehouses showing up in all my plants (which isn’t possible) or only showing my primary warehouses and not the others. I feel like it shouldn’t be this difficult and I am just missing some simple piece. 

icon

Best answer by jtrent 27 April 2021, 18:35

View original

3 replies

Userlevel 2

Look at PlantWhse.

 

Joe

Userlevel 1

Thank you so much! I just fixed something in 5 minutes that I spent hours on. I think I found a new favorite table. 

Userlevel 2

Welcome! I banged my head a bit on that, too.

 

Joe

Reply