Company ID and Company Name in SmartList Builder

(0) Share

Report

Posted on by Community Member

Hello:

I have always known that the only way to get a "global" SmartList of data across all companies is to write a SQL "UNION ALL" script. I see that SmartList Builder has a "Company ID" and "Company Name" fields. But, those are only valid for the GP company that you're logged into.

Am I correct or incorrect, on both of my thoughts on obtaining "global" data?

Thanks!

John

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Tristan Clores 2,812 on at

Like (0)

Report
Copy link

Link copied!

Hi John,

You are correct. Smartlist Builder cannot, on itself create a Smartlist Object to check on multiple companies. You will need to create an SQL view first then use Smartlist Builder to view it in GP.

You can use the link below as a guide on how to achieve this:

www.gpwindow.com/detail.php

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks, Tristan!

John

Was this reply helpful? Yes No
Verified answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi John,

SmartList Builder has the ability to turn on the 'Multi-Company' option, in which case you can then pull data from the various GP companies you selected... There is no need to create a 'UNION' view in SQL before that.. SL Builder will do it for you.

Make sure the users have access to the companies you selected in the SQL security (managed in SL builder).

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks, Beat!

John

Was this reply helpful? Yes No