Dynamics Blog

Welcome to the Dynamics Blog hosted by the professionals at Armanino. This blog is about anything that may be helpful to others regarding Microsoft Dynamics' software. The topics can be anything from Microsoft Dynamics GP, AX, CRM, SharePoint, MAS 90/200, .NET development, accounting, compliance and more.

Thursday, August 28, 2014

Dynamics GP Excel Copy Paste Error in 2013 R2

We recently received a call from a customer with issues using Dynamics GP Excel copy paste function. She said she did not have access to the Excel Copy Paste function in GP2013 R2. When she attempted to paste data, she received this error message: Not privileged to run this report. Upon further review, we found …

Tuesday, August 19, 2014

Copy from Excel into Dynamics GP General Journal Transaction

GP 2013 R2 includes new functionality that allows you to copy and paste information from Excel into the Dynamics GP general journal transaction entry screen. It’s really very easy to use. Just get the information into this simple format: Description – Account – Debit – Credit. Here’s an example: Select the data you want and …

Friday, July 18, 2014

New Dynamics GP 2013 R2 Dashboards

Microsoft’s Dynamics GP 2013 R2 release includes four ready-to-go dashboards for Purchasing, Inventory, Sales, and Finance. They are deployed as part of the familiar Excel Reports for Dynamics GP. These dashboards show off the results that Excel can deliver from your Dynamics GP data. Though you’ve been able to easily create similar dashboards using Excel …

Monday, April 28, 2014

Don’t panic if Management Reporter does this to you!

You may have just spent weeks or months building out your financial reports in Management Reporter, and then a new company is added to Dynamics GP.  “Easy,” you think, “I’ll just open up the Management Reporter Console and refresh my company list.”  You do this successfully and triumphantly return to Management Reporter to test out …

Monday, February 17, 2014

Multi-Company Smartlists for Microsoft Dynamics GP Smartlist Builder

If you use Microsoft Dynamics GP, you most likely use Smartlist. And you may even be lucky enough to own Smartlist Builder, which allows you to build your own custom Smartlists. If you do have Smartlist Builder, there is one feature I would like to highlight that you may or may not be aware of—the …

Monday, January 20, 2014

Advanced Management Reporter Design Tips – Mastering Report Design Layouts and Complex Reporting Calculations

If you have recently upgraded to Management Reporter from FRx or just started using Management Reporter, I have a few tips and tricks when you want to go beyond the basic report design options. Management Reporter basic report design includes the use of row and column definitions to design basic report layouts, with the occasional …

Monday, December 23, 2013

How to Turn Off “Posting Journals” In Microsoft Dynamics GP

By default, anytime a transaction posts, a series of “Posting Journals” will appear and prompt the user for the destination to print to either screen, printer or file. To turn off these Posting Journals in Dynamics GP, you’ll need to adjust the settings in Posting Setup. Here’s how: Navigate to Dynamics GP>Tools>Setup>Posting>Posting Select the Series …

Monday, December 9, 2013

Microsoft Dynamics GP Year-End Close Advice

What is the #1 preventative measure you can take to make your Microsoft Dynamics GP year-end close go well? It’s not hard—it does not take long—but in my experience, this step is often skipped. This work takes MUCH less time than fixing issues after the fact. What is it, you ask? Check your account posting …

Tuesday, December 3, 2013

Letter Writing Assistant in Microsoft Dynamics GP

The end of the year is coming, and if you’re staring at a long list of letters to prepare/send to vendors and customers, I have a solution that can help you get it all done: The Letter Writing Assistant in Microsoft Dynamics GP. With Letter Writing Assistant, you can shave time off this dreaded task …

Wednesday, November 27, 2013

Rollback your SQL script w/o restoring the database

Have you ever had to update a table in GP and made a mistake. No! Never right? Then had to restore the database to bring it back before you ran the statement.  Dang!! I forgot to make a backup! How many times have you had to restore before getting it right? Well there is in …

« Previous PageNext Page »