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.

Tuesday, August 25, 2015

Safe Pay in Microsoft Dynamics GP

Safe Pay in Microsoft Dynamics GP is functionality that creates a file in conjunction with the Payables Management payment processing function that you can send to your bank to take advantage of the positive pay service that many banks offer. The positive pay service compares all checks being presented for payment from your account, to the Safe Pay file you send your bank. If there is not a match the check does not get paid.

This adds another level of security over your payment processing function to reduce the chance of fraudulent checks being paid from your accounts.

The setup is fairly easy to do. You can utilize the Safe Pay Configurator screen to format the Dynamics GP output information to your bank’s required file format. The Safe Pay screens are located in the Financial > Routines area.

Thursday, August 13, 2015

Tales from the Trenches: Advanced Find with Multiple Conditions for Child Records in Dynamics CRM

The next installment of Tales from the Trenches for Microsoft Dynamics CRM covers Advanced Find with multiple conditions for child records.

Have you ever needed to search on Entity line items with multiple conditions for the child record? Although it is not obvious, you can set up your Advanced Find query to search downward to the child entity, then back up to the parent entity so you can identify your specific conditions.

For example, let’s look at the native Opportunity Products. In the below example, we would like to find all Opportunities that have both the CRM Online Enterprise and CRM Online: Professional products. If we were to simply add both products to the first criteria, Advanced Find would only search where either (but not necessarily both) of the products are associated. However, by filtering our query to identify the first search criteria, we can then circle back to identify the second criteria.

Thursday, July 30, 2015

EVOLUTION Conference Early Bird Deadline TOMORROW!

Armanino has revamped the Dynamics User Days and Technology Forums of our past into the robust EVOLUTION conference. This year's conference is dedicated to showcasing superior professional development alongside technology tips, tricks, and updates.

Early bird discount pricing ends this week on July 31st!

Educational tracks include Financial Planning & Analysis (FP&A), Enterprise Resource Planning (ERP), IPO Readiness, Cloud & Data Security, Technology Toolkit, and a Solution Showcase. Sessions will span high level views on the Realities of Migrating from On-Premise to the Cloud, insights into SEC Filing Hot Buttons & Gotchas: Tax, Audit, & Stock Options, and best practices in Rolling Forecasts - Evolve Beyond Annual Budgets.

Rand Morimoto, former White House cybersecurity advisor and best-selling author, will present the keynote address discussing cybersecurity insights for businesses. Other featured speakers include Peter Bardwick, CFO of Nitro, Thomas Peff, Finance Director for Adaptive Insights, and numerous industry panelists.

Additionally, Armanino has partnered with Saint Mary's College of California School of Economics and Business Administration to deliver business certifications for the ERP, IPO Readiness, and FP&A tracks. California CE credits will be available for those attending the conference as well.

Learn more and register today to secure your spot at the EVOLUTION conference- early bird pricing ends this week on July 31st!

Tuesday, July 28, 2015

ROI of CRM - A Tactical Guide

Armanino recently published, The ROI of CRM: A Tactical Guide to Project Justification and Building Value, which features  insights from a Nucleus Research report on the ROI of companies using a customer relationship management system (CRM) versus those without one. The report noted, for every dollar spent, a CRM pays back $8.71.

The white paper touches on key points for understanding the importance of CRM as a tool as important as your team's enterprise resource planning (ERP) or business intelligence (BI) tools. It covers both direct and indirect returns on investment (ROI) for finance, sales, operations, customer service, and marketing. Additionally, the white paper discusses the potential costs of consolidation and integrating with your existing solutions to maintain a smooth-running operation.

Read the full white paper, The ROI of CRM: A Tactical Guide to Project Justification and Building Value, to learn more about the value of a CRM for your team and gain access to and ROI calculator for a rough estimate of the costs and benefits for your own team.

Learn more about Microsoft Dynamics CRM to see the benefits for your business.

Thursday, July 23, 2015

Azure Machine Learning Webinar for Dynamics UG Members

Armanino's business intelligence and data warehouse expert, Noah Kluge, is presenting an AXUG webinar on Friday, July 24 around a newly released feature of Microsoft's Azure.

Members of all Microsoft Dynamics User Groups are welcome to attend the webinar to learn about Machine Learning in Azure. This new feature is a cloud-based solution to deliver predictive analytics. The presentation will cover what is Azure Machine Learning and what applications to consider for your organization.

Register today to hold your spot!

About Noah
Noah is a Senior Manager with Armanino's business intelligence practice. During his career, he has been responsible for the design, build, and implementation of various business intelligence projects. Noah has extensive experience with the PrecisionPoint data warehouse and a great understanding of the importance of integration among systems.

Wednesday, July 22, 2015

Understanding Fiscal Year Close Options in Dynamics AX

Savvy Dynamics AX users may have noticed the fiscal / financial year closing options in Microsoft Dynamics AX R3 CU8 have a different look than from previous versions. Check out this quick reference guide for what the fields mean and how to configure them.

General Ledger Parameters

  1. Delete close-of-year transaction during transfer: This one is fairly self-explanatory - it's used to delete the close-of-year transaction during transfer.
  2. Create Closing transactions during transfer: If checked, this creates a closing transaction of all accounts during transfer.
  3. Set Fiscal Year status to close: If checked, this sets the fiscal year to close after running the fiscal close process (not recommended).
  4. Fiscal Calendar: This shows the company's Fiscal Calendar.

Wednesday, July 15, 2015

Customer Service is Essential for Brand Choice and Loyalty

It's no surprise that customer service is important to consumers. The recently released 2015 US State of Multichannel Customer Service Report found that 98% of US consumers listed customer service as an important factor in choosing and staying loyal to a brand.

The level, speed, and convenience of customer service as well as options for service were essential.

  • 92% expect companies to offer self-service customer support or portals online
  • 61% feel more favorably about a company if their online self-service is mobile-friendly
  • Over half expect a response to inquiries within 24 hours
This annual report published by Microsoft Dynamics CRM and Parature covers customer service preferences, top customer frustrations, growing expectations, and more. Learn more about Microsoft Dynamics CRM to keep up with customer demands by keeping your organization on track.

Download the full 2015 US State of Multichannel Customer Service Report to see more on this year's findings.

Wednesday, July 1, 2015

Configuring Bank Transaction Types in Dynamics AX

Configuration and setup of bank transaction types in Dynamics AX 2013 R3 can be very helpful and useful in bank reconciliation. This is especially helpful when the origination of transactions appearing on the bank statement cannot be traced back to the ERP system or when the system’s setup requires a manual general ledger adjustment at the time of reconciliation for the charges that appear on the statement.

Different charges appearing on the bank statement that are either aggregated or do not appear at all in the accounting system (AX) can be configured as “bank transaction types.” Natural accounts can be created in the chart of accounts to be associated with these transactions/charges. Thereafter, you can create the Ledger adjustment or distribution (for an aggregated charges) to different natural accounts right from the Bank Reconciliation form itself, instead of manually going to general ledger and making the record of adjustments.

Below I have demonstrated the configuration of bank transaction types which is a very useful and potent tool in the business scenarios and procedure described above.

Thursday, June 25, 2015

Payables Transaction Approval Workflow in Dynamics GP

Dynamics GP 2015 R2 includes two new features that will allow you to expedite and better control your payables invoice processing.
  1. Payables Transaction Approval workflow object 
  2. Document attachment for email approvals
Using the workflow mechanism in Dynamics GP 2015 R2, you can customize a workflow process to meet your specific control needs. You can create multiple approval levels with groups or individuals, and you can create workflow logic based on several different fields in the transaction and your local system.

It’s also possible to allow for approvers to approve transactions within an email message generated from the workflow. The email message can include line level detail and attachments specific to the transaction being reviewed.

The transactions can be approved or rejected and relevant comments can be tracked along the approval process.

Thursday, June 18, 2015

Nutraceutical Companies Urged to Focus on Quality Assurance

Recent negative press and threats of legal action have sparked questions about the safety and integrity of nutraceuticals. In early 2015, the New York attorney general's office subpeonaed four major retailers of herbal supplements for evidence proving their product claims. They had tested store-brand herbal supplements sold at GNC, Walgreens, Walmart, and Target and discovered most of the products did not contain the ingredients listed on the label. Some even contained ingredients not listed on the label at all.

While there were concerns about the political motivations behind the testing, which industry trade groups have countered was flawed, the recent publicity has focused a spotlight on the need for clear quality assurance issues for nutraceutical companies. One retailer, GNC, has taken steps to ensure the quality of its products, including reaching an agreement with the attorney general's office to expand its testing and supply chain traceability processes.

The activity in NY didn't stop at the state's borders. Fourteen additional states have now requested increased FDA oversight as well as the consideration for more stringent industry-wide requirements. It is essential for nutraceutical companies to ensure higher level quality controls.

While the rules are vague - and unfortunately, open to interpretation - nutraceutical companies can stay ahead of the regulatory requirements and potential changes with well-documented systems and accurate data. Organizations can utilize their ERP system to help set up preventive systems and maintain adequate internal controls to enable adaptability for any future changes.

Read the full articles on quality assurance regulations for nutraceutical companies, As Industry Considers New Controls, Nutraceutical Makers Must Focus on QA and discover additional educational articles and white papers for life sciences industries.