Category Archives: SmartList

Review of Microsoft Dynamics GP 2013 Reporting by David Duncan and Christopher J Liley

I have received a copy of the newly published Microsoft Dynamics GP 2013 Reporting, by David Duncan and Chrisopher J Liley, from Packt Publishing to review. This is an update of a previous book the pair wrote for Microsoft Dynamics GP 2010:

Microsoft Dynamics GP 2013 Reporting

The book covers an extensive range of the reporting tools in, or available with, Microsoft Dynamics GP 2013:

  • SmartList Builder including Excel Report Builder
  • Report Writer and Word Templates
  • Reporting Services Reports
  • Analysis Cubes
  • Management Reporter

Continue reading

Posted in Analysis Cubes for Excel, Business Analyzer, Dynamics, Excel Reports, GP, Management Reporter, Microsoft, Modifier with VBA, Report Writer, Reporting Services Reports, SmartList, SmartList Builder, Word Template Generator | Tagged , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Microsoft Dynamics GP SmartList Default Visible To Company

In July, as part of his weekly MS Connect suggestion series, Mark Polino raised the issue of SmartList Favourites and the default Visible To which is set to System.

Mark’s suggestion was to have the default changed to User which would leave a generally tidier list. To be honest I’d rather have a setting which allowed the default to be chosen by each client. The reason for this is we’re currently in the middle of an upgrade project where a few Microsoft Dynamics GP systems will be merged into one and it would be good to have the default Visib le to set to Company.

Following on from my recent post on a fixed width SmartList left pane I decided to have a fiddle and see if I could force the default to something else. And it turns out with some simple VBA that you can do exactly that;

SmartList

Continue reading

Posted in Dynamics, GP, Microsoft, Modifier with VBA, SmartList | Tagged , , , , , , , , , | 2 Comments

Microsoft Dynamics GP 2013 SmartList Fixed Width Left Pane

In July last year, Frank Hammelly posted a SmartList customisation for Microsoft Dynamics GP 2013 on his blog gp2themax.

I’ve recently been taking a look at Microsoft Dynamics GP 2013 and decided to see if I could use Modifier to reproduce this customisation for GP 2013 (I have no reason to believe the customisation posted by Frank won’t work with 2013, but I wanted to dabble with Modifer and this seemed a good starting point); the customisation can be downloaded at the bottom of this post.

The screenshots below show SmartList in both it’s default size and maximised with the left pane remaining a static size and the right pane occupying the rest of the window;

SmartList

Continue reading

Posted in Dynamics, GP, Microsoft, Modifier with VBA, SmartList | Tagged , , , , , , , , | 5 Comments