Top Smartlist Builder Question – “Can I do a Multi-company Summary Smartlist?”


Collins Dynamics GP Blog tells us about the Top Smartlist Builder Question, which is Can I do a Multi-Company Summary Smartlist?

The answer is a very positive YES.

It’s basically a simple and easy-to-understand feature. This feature is quite important for all clients with multiple companies on a single GP environment.

Pay a visit their post and you will know how exactly to use this feature.

VAIDY

Smartlist Builder Bug – Display As Negative Value Based on Field


Mariano confirms a bug which is spotted in Smartlist Builder.

The bug is in setting up any Numeric Field to be displayed as a Negative Value Based on Field. And he also shows us a simple and doable workaround till this is fixed by Microsoft in coming releases.

The impact of this bug towards GP Versions are also mentioned clearly.

Must read article for those who extensively work on Smartlist Builder.

VAIDY

Smartlist Builder View Returning Nothing – David Musgrave


David explains why Smartlist Builder View may not return records and on which scenario.

Check out his post here: SmartList Builder based on SQL View not returning Data.

VAIDY

View Smartlists with SQL Tables


Have you ever wondered why your Smartlist, created using Smartlist Builder and a SQL Table / View (which is not part of any of GP or 3rd Party Products)?
This may be the issue:
The above screenshot shows Security Task form, where you have to select the option “View SmartLists with SQL Tables” for the users who wants access to this Smartlist.
This particular point is very much covered in Smartlist Manual, but I bet most of us would have overlooked this.
VAIDY