Microsoft Dynamics GP Macros: Macro By Excel Formula

Microsoft Dynamics GPIn this series I am taking a look at how macros can be used to update data in Microsoft Dynamics GP.

Over the last couple of posts, I’ve shown how data can be merged into the macro template using either mail merge or a SQL script. This post is going to show the final method I use for merging data into the macro template, which is to use an Excel formula.

I am using an Excel spreadsheet with two columns, USERID and PASSWORD. I am going to add a third column to the spreadsheet to hold the formula containing the macro.

User data in Excel

Continue reading “Microsoft Dynamics GP Macros: Macro By Excel Formula”

Sales Analytics Dashboard Available Now From DynamicAccounting.net

Microsoft Dynamics GPIn what looks to be the first in a set of analytics dahsboards, Mark Polino has released a Sales Analytics dashboard on his DynamicAccounting.net site.

The dashboard builds on the ideas covered in Mark’s recent Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 and can provide a really good shortcut to getting started using an Excel dashboard rather than rolling your own from scratch.

Continue reading “Sales Analytics Dashboard Available Now From DynamicAccounting.net”

Microsoft Dynamics GP 2013 Reporting – Review Incoming

Microsoft Dynamics GPI have received a copy of Microsoft Dynamics GP 2013 Reporting to review which I will be doing over the next couple of weeks.

This is an update to the previous edition of the book for Microsoft Dynamics GP 2010, but this one is for the current version:

Microsoft Dynamics GP 2013 Reporting

I’ll be giving it a thorough read and, setting aside my distaste for reporting outside of Management Reporter, I may even follow some of the examples and post a detailed account.

If you don’t want to wait for my review of the book, it can be bought now from Packt Publishing.

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino – A (short) Review

Microsoft Dynamics GPA few weeks ago Mark Polino, in conjunction with Packt Publishing published another book, the Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013;

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

I got a copy of Mark Polino’s Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 the other week with the intention of working through it following all of the examples. However, the reality is I don’t have the time to do this due to other commitments (both work and outside of work ones).

Continue reading “Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino – A (short) Review”

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino

Microsoft Dynamics GPFollowing on relatively quickly from Leslie Vail’s new Microsoft Dynamics GP book, , available from Packt Publishing, comes Mark Polino with Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013.

This book will teach you how to build a dashboard using Excel 2013 with information from Microsoft Dynamics GP 2013, how to make Excel a true business intelligence tool with charts, sparklines and slicers and show how to utilise PowerPivot’s full potential to create even more complex dashboards;

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino

Continue reading “Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino”

MDGP 2013 Feature of the Day: Reconcile IV To GL

Microsoft Dynamics GPMicrosoft have started the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifteenth feature they’ve announced is Reconcile IV To GL.

Microsoft Dynamics GP 10 saw the introduction of the Reconcile to GL report which allowed the automation of the reconciliation of differences in Receivables Management and Payables Management to the General Ledger. In Microsoft Dynamics GP 2013 the Inventory Control module will be added to the Reconcile to GL to help users identify the differences between the Historical Inventory Trial Balance and the GL inventory accounts;

Continue reading “MDGP 2013 Feature of the Day: Reconcile IV To GL”