Armanino Dynamics Blog

Armanino 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

Excel Copy and Paste Error in Microsoft Dynamics GP2013 R2

We recently received a call from a customer that stated she did not have access to GP2013 R2’s Excel Copy Paste function. When she attempted to paste the data, the following error message was received: Not privileged to run this report.

Upon further review, we found that the feature is available for anyone that has access to the Transaction Entry window in GP. However, if any errors are detected in the data that the user is attempting to paste, the GL Transaction Paste Validation Report will need to print. This report is new to GP2013 R2, specifically made for the Excel Copy Paste feature. The report will display the data that needs to be revised in the Excel Spreadsheet. The GL Transaction Paste Validation Report will not appear if the data is correct- it will bypass this report and paste the data into the Transaction Entry window.

To resolve the error, we navigated to the Security Task Setup and added the “GL Transaction Paste Validation Report” to the TRX_FIN_001* task.


Monday, August 25, 2014

The (Hidden) Open Sales Order Report By Item in Dynamics GP

Recently a client asked me how to run a report of open sales orders by item. I was sure such a report existed in Dynamics GP, but I had a heck of a time finding it. I went to the Sales Reports section and vaguely remembered that the SOP document reports are in the Activity group. I was pleased to see “Sales Open Order Report” in the dropdown list and was about to pat myself on the back for finding the report so quickly, but then I stopped dead in my tracks. The report sort options did not include sort by item number! How could this be? The client was disappointed as much, if not more, than I was because they base their purchasing decisions in part on the open sales orders. I showed the client how to create a smartlist of open order items, export it to Excel and subtotal the data by item, but they preferred not to have to go outside of the system to get the information. So I went back to the drawing board and found out that the Open Sales Order Report By Item option is alive and well in Dynamics GP, you just have to unmark one little checkbox.

Here’s how you get to the report:

Go to the Sales Open Order Report in the Sales Reports section and click on Activity:

Then select Sales Open Order from the dropdown list and click on the New button to create the report option:

Note two things on the default report options for this report: 1) the In Detail checkbox is marked and 2) Item Number is not a sort option.

Enter a name for the new report option, such as “By Item.” Then―and here’s the important part―UNMARK the In Detail checkbox. Note that with this box unmarked, Item Number is a sort option!

When you run the report, you’ll be happy to see that the report subtotals on item.

Like I always say, “What a difference a little checkbox makes in Dynamics GP!”

On a side note: You may not be so happy to see that it is a fairly busy report… However, this report can easily be modified/cleaned up in Report Writer, which allows you to remove unnecessary fields.

By Liane McIlraith, Senior Consultant in Armanino's Gold Certified Microsoft Dynamics GP Practice.

Friday, August 22, 2014

Microsoft Dynamics AX: The ERP That Pays For Itself

According to a study from Forrester Research, Microsoft AX Deployments have an ROI of 92% in the first three years, with an average payback period of 21 months. Additionally the three year study found an average of:
• Net Present Value over $3 million
• Total Benefits over $6 million,
• 53% Internal Rate of Return.
Typically ERP implementations are assessed over a 5-7 year period (industry average for ERP payback), and if Forrester’s study was continued they expect it would show “even better numbers.”
The study focused on:
• Software license fees
• Annual assurance and maintenance costs
• Professional and consulting costs
• Training expenses
• Internal FLE labor costs
• Hardware expenses.
Key benefits of Dynamics AX were cited as:
• Increased business user productivity
• Reduced IT team size
• Elimination of systems license and maintenance costs
• Combined savings of over $10 million in three years

Thursday, August 21, 2014

Why Separation of Duties is Essential to Business Controls

Business controls in your organization can be greatly increased by evaluating business processes and determining whether there is sufficient separation of duties, then making improvements where needed.

The basic guideline in evaluating or designing a business process with a sufficient separation of duties control is to make sure that the person(s) with custody of assets is(are) different than the person(s) with record keeping responsibilities.

For example, you do not want the person who receives the mail and handles cash receipt checks, to also be the person who maintains the accounts receivable records. In this case it would be easy for that one person to deposit the checks in an account they control and then cover up the theft by manipulating the accounts receivable records so that everything looks fine.

Why Even Non-Developers Should Use Dynamics CRM SDK

If you are like me, the acronym “SDK” scares you (not that I would ever share that with my development-type teammates). I am a run-of-the-mill CRM customizer – do I really need or want to know all the nitty-gritty details of end points, soap vs. rest, and assemblies? Not really, but there is much more to the SDK than development tips/tools/examples. My current favorite is the Data Migration Utility.

The Data Migration Utility allows you to export data from specific entities and then import that data into another environment. Why is this important? It means that lists or supporting data will have the same GUID in each environment. If you have jscript or a real-time workflow that populates fields as defaults, you can use the same GUID in each environment!

In the SDK 6.1 this can be found in \SDK\Tools\ConfigurationMigration\DataMigrationUtility.exe

Tuesday, August 19, 2014

Copy from Excel into General Journal Transaction in Dynamics GP

Dynamics GP 2013 R2 includes new functionality that allows you to copy and paste information from Excel into the general journal transaction entry screen in Dynamics GP. 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 copy it.
Then go to the general journal transaction entry screen and click on "Paste." The copied information will populate the screen.

Here's a quick video that shows the process in action: http://youtu.be/VbpP3D_aBFI

By Steve Chapman, Senior Account Executive at Armanino, a Gold Certified Microsoft Dynamics GP Partner

Monday, August 18, 2014

Top 5 Reasons to Attend Armanino's 2014 Microsoft Dynamics User Day

5) We know your time is valuable: We’ve generated an informative and dynamic day targeted towards professional growth.

4) Take control of your learning: You can select a single solution track of presentations, or hand-pick sessions across the AX, GP and CRM platforms to fit your needs.

3) Network: This is a Microsoft Dynamics event exclusively for customers spanning multiple industries. You’ll have the chance to share experiences and solutions with your colleagues at one of the largest user conferences in California.

2) Discounted Pre-Conference Training: Build the skills of your team and gain valuable internal resources with a full day of pre-conference training. Training is offered at a deep discount (75%) and space is limited.

1) It’s FUN: Armanino, Microsoft and our sponsors create exciting and enlightening content for you!

Friday, August 15, 2014

Armanino Named to 2014 Dynamics Inner Circle

Armanino is pleased to announce that we have been named to the 2014 Dynamics Inner Circle for the third year in row. Tom Mescall, Armanino partner-in-charge of Consulting shared, “"We are honored to achieve Microsoft's Inner Circle membership for three years running. It is a testament to our team's commitment to delivering excellent service to our customers. Our growth and success correlate with our investment in creating premier industry-specific solutions to enhance the ROI (Return on Investment) of our clients using the Microsoft Dynamics stack of products." Armanino consultants provide thought leadership to our clients and the Dynamics community through our annual User Conference (http://www.amllp.com/dynamicsuserconference/2014/), this blog, solution-specific webinars, white papers, and presentations on life science and technology solutions at the Microsoft Industry Summit.

Read the Accounting Today article here: http://www.accountingtoday.com/accounting-technology/news/armanino-named-to-microsoft-dynamics-inner-circle71659-1.html?utm_campaign=daily-aug%2014%202014&utm_medium=email&utm_source=newsletter&ET=webcpa%3Ae2937515%3A2645145a%3A&st=email

Wednesday, August 13, 2014

Who Needs Workflow Approval Duties in Dynamics AX 2012?

Apart from the system administrator, every user in a workflow needs to have the approval duty that is related to the workflow.

For example, anyone who will approve vendor invoices in the workflow will need to have the “approve vendor invoices as employee” duty.

I often add these duties to a generic employee role that everyone gets― simply because having the ”approve vendor invoice” duty doesn’t mean you can go in and approve any invoice you want. It just means that you can be in the workflow and IF an invoice gets routed to you, you can approve it.

By Darrell Graham, Manager at Armanino, a Gold Certified Microsoft Dynamics AX Partner.

Tuesday, August 5, 2014

Armanino's 2014 Microsoft Dynamics User Conference


We are excited to announce open registration for Armanino’s 2014 Dynamics User Conference! 


Register now: September 17th, San Diego, CA | September 25th, Mountain View, CA 

This is one of the largest Microsoft Dynamics user conferences in California (and the West Coast). It features learning tracks for Dynamics AX, GP and CRM – led by Armanino and Microsoft subject matter experts. 

These sessions are designed to provide you with valuable information on how to get the most from your solution, including tips and tricks, as well as insights on new functionality. 

In addition to learning sessions, there will be numerous opportunities for you to network with other Dynamics users from all over the country, speak with Armanino and Microsoft representatives, and visit sponsor booths to learn more about products that can extend your solution’s capabilities. 

 NEW IN 2014: Improve your skills and gain internal resources with in-depth training. This year we are offering a full day of Pre-Conference training at a deeply discounted group rate. Space is limited, reserve your spot today

Watch a recap of Armanino's 2013 Dynamics User Conference: