Would filtering the BAQ Constant Cur-Plant work?
Sorry read this backwards at first… thinking you wanted users with access to multiple plants to only be able to see inventory in the current active plant.
Rereading… I suspect you may need an external BAQ.
As far as I know, Jose, if a user does not have access to Site X then they won’t see any information from Site X in the default functionality. You could probably create an SQL View and use it as an external query.
@joerojas I think the problem is BAQ respects the security of plant access for the user. Bypassing that would require an external query or another method to bypass the security filtering.
We ended up distributing a simple inventory view with our inhouse BI tool.(SSAS & Excel) We chose this route because it met our needs since most use cases for this request was more analysis level and not to take action on a transactional basis. In other words what was the user going to do with the knowledge even if they had the result. They still couldnt perform a transaction which would require plant level security to be setup for the user.
@Ernie & @Nathan_Woolen are correct. If plant restrictions are in place, then Epicor is following those rules even in BAQs that you create. It would be a nice enhancement to the software (I have suggested it) that Plant security had additional options other then a True/False… it would be better if we also had a “read only” mode so that I could see but not touch.
