BAQ with PartPlant issue

[Asz0ka (Adam Szoka)]

I just saw a post about this, maybe an outer join would help.

Learned this today - BAQs and sites

For the multi-site people out there. I made a BAQ to show transfer orders. I was hopping mad when site A could not see site B stuff. I learned that if you use the PartPlant, PartRev or Warehse tables in your BAQ (and inner join), the BAQ is restricted to only the sites that the user has access to. This is documented in a table called zDataTable - note the RestrictedBySite column: [image] (I recall others hitting this with territories. Notice the column to the left of the site column.) Cre…