This is probably a trivial question - but what is the most reliable way to get the site a part is in (from PartBin or PartWhse)? For the first BAQs I wrote I would calculate it based on WarehouseCode. However, as we have grown and evolved, I find that we keep adding more warehouses and even more sites. This requires me to remember all the places I wrote that calculation and update them. I have used PlantWhse before but I am aware that it can have its limitations (like if a warehouse is shared). We don’t share warehouses today but who knows what tomorrow may bring. I am hoping to fix the way I am getting the site on my BAQs that will be more future proof. Any suggestions? More like, is there a tried and true or a “generally accepted best practice”? I’ll compare my thoughts to what others are doing to make sure I’m on the right track.
1 Like
The Warehse table has Company, Warehouse and Plant in it. That’s what I use in my BAQs to get to the plant based on the warehouse.
4 Likes
Ahhh no way! I never knew that was there. Love it. I was hoping it would be a simple answer. Thank you @Doug.C !