SQL View to Return Budgets By Month

Microsoft Dynamics GPThe budget functionality in Microsoft Dynamics GP isn’t the strongest with reporting being particularly weak. The ability to report on budgets in Management Reporter does somewhat redeem this area of functionality.

However, the absence of a SmartList Object for budgets is quite a big issue, as SmartList is a very nice flexible reporting tool which the majority of my clients know well. For those with SmartList Builder, it was easy enough to create a SmartList Object for them.

With the introduction of SmartList Designer, we were able to roll out the SmartList budget report to all of the clients who wanted it.

The script is below and returns the budget information with the beginning balance, 12 hard-coded periods and total horizontally across the page.

Continue reading “SQL View to Return Budgets By Month”

Microsoft Dynamics GP 2013 Financial Management Has Been Published

Microsoft Dynamics GPMy second book, Microsoft Dynamics GP 2013 Financial Management has been published and is available now from Packt Publishing.

This is my second book, the first being the Microsoft Dynamics GP 2013 Cookbook, and is the third piece of my work Packt Publishing have released this year (the first being the Microsoft Dynamics GP Techniques Online Leaning Course);

Microsoft Dynamics GP 2013 Financial Management by Ian Grieve

With this book you will:

  • Discover how to improve financial management in Microsoft Dynamics GP 2013
  • Learn the key financial management modules in Microsoft Dynamics GP 2013
  • Improve your abilities with Microsoft Dynamics GP 2013 to gain a better understanding and control of your business

The modules covered in Microsoft Dynamics GP 2013 Financial Management are:

  • Analytical Accounting
  • Cash Flow Management
  • Budgets
  • PO Commitments
  • Encumbrance Management

You can buy Microsoft Dynamics GP 2013 Financial Management from here.