I created a BAQ several months back prior to when a new company got created. Now I need to have this cross-company. The BAQ is not working even when I have Cross-Company checked. If I create a brand new BAQ and have cross-company checked, it is showing the other company’s data. Is there anything I can do to fix the old BAQ or is my only resort to copy the BAQ and delete the old one? Trying to see if there are better way of getting around it other than copying and deleting. I would have to change my dashboard to the new BAQ as well and want to avoid this if don’t have to.
Figured out the issue. It’s with the joins, since it is inner there are some tables not setup yet. So changed to left outer join and it’s working now.