I just want our company code to show on the report, I've build one with check history where I joined tables from AP options and was able to show the company code as a field, but I'm not sure what to do here.

Example of the goal:

Vendor: Vendor Address: Company Code:

Bob's Garbage 123 Lane Ln ABC (one of my companies)

See Bob could be a vendor for say 20 of my 53 companies, if Bob changes his mailing address I'd rather not hunt through all the companies to see where he's set up and where he is not.

Yah, that's the only way I know how to pull from multiple companies, is there another way?

All the companies are good to go, and available in the Cashe. I have other reports that use all companies and work fine. That's not the issue. The issue is getting the company code field to show on the vendor list.

here, see the issue is I had to go into check history to get a link so company code ties back. That's too much detail. I really just want to vendor name and the company code.

That worked like a charm!!!! I'm very grateful!

How did you build that?

Thanks for sharing Doug.  

Has this question been answered? I have the same issue and I do not see a solution

I believe I was the one that came up with the answer but it looks like it's gone?

So your looking for a Sage Intelligence report that shows the Vendors for multiple company's?

Like this:

yes that is correct, just like that