Dynamics ERP – Free Tools #2 Performance Analyzer for Microsoft Dynamics

 

Have you ever had your Dynamics product, for example, Dynamics GP, run really slow, then speed up, and then slow down again?  What's up with that performance?

Well, now you can find out what is going on with the PERFORMANCE ANALYZER, a free tool from Microsoft Premier Field Engineering.

Performance Analyzer for Microsoft Dynamics (DynamicsPerf 2.0) is a toolset developed by Microsoft Premier Field Engineering. This toolset is a set of SQL scripts to collect SQL Server DMV data and Microsoft Dynamics specific product data persisted into a singular database called DynamicsPerf. This allows for quick resolution of performance issues on Microsoft Dynamics products (CRM, AX, GP, NAV, SL)

You can download this tool at https://dynamicsperf.codeplex.com/.

Note that this site may be archived soon, and you will need to find the tool at another location.

Contact us  at Dynamics MCT Consulting to get more information on Dynamics products.  Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP

Dynamics GP–Free Tools #1–Consulting Toolkit from Willoware

 

Companies are always looking for ways to save time and money.  Free tools, especially time saving tools, are one way that IT departments can help the accounting departments move through data more quickly.

Willoware has a Consulting Toolkit with both modules for purchase and with some free tools.  The free tools include:

• SQL Database Manager
• SQL Query
• SQL Trace
• GP Finder
• GP Resource Explorer
• GP View Wizard

Of the free tools, my favorite is the View Wizard.  The View Wizard is a utility for creating SQL Views of Dynamics GP tables that using “human readable” column names.  For example, instead of ITMTRKOP the column name would be ItemTrackingOption.  This is a great tool for building user-friendly tables for reporting, or for use in complex queries creating views for SmartList Builder.

You can check out the list of tools in the Consulting Toolkit at https://willoware.com/products/consulting-toolkit/.

Contact us  at Dynamics MCT Consulting to get more information on the Willoware tools.  Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Watch for further Free Tools blogs in upcoming posts.

Submitted by Judith Hirst CPA, CMA MCP

Dynamics GP 2016 R2–Saving an new Fixed Asset with a Suffix Greater Than 1

Figure 1 – Asset Card showing new asset with suffix of 05

The Dynamics GP Fixed Asset module is improving with each release of Dynamics GP.  In the current release, Dynamics GP 2016 R2, users are able to save the Asset ID with a suffix other than 1. 

New assets can now be listed as:

• Forklift 1040 Orange-12 instead of Forklift 1040 Orange-1
• Toyota Camry SSE Grey-10 instead of Toyota Camry SSE Grey-1

Here are the reasons that this change will make life easier for the fixed asset manager:

• This change will make creating new assets easier/faster
•   If a company buys a block of assets from another company, they no longer have to change the asset id if the suffix is not a 1
• Importing assets will be easier without the suffix being 1
• Companies can create suffix lists for certain assets for easier tracking

To see a short video of all of the GP 2016 R2 features, check out Microsoft's video HERE.

If you want more information about  Dynamics GP, contact us at Dynamics MCT Consulting.  Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP

Dynamics GP - The Historical Inventory Trial Balance Reset Tool and Report

 

 

If your company has ever wanted to have historical information about inventory, the Historical Inventory Trial Balance (HITB) Reset Tool  is a tool you will want to add to your Dynamics GP toolkit.  And, yes, it is different that the Historical Stock Status report that users can find under Inventory>Reports>Activity>Historical Stock Status.

The Historical Inventory Trial Balance  report shows your inventory value as of a specific date or date range and the value of the five different quantity types. You can use this report to balance your inventory value with the appropriate accounts in General Ledger. 

Microsoft created this tool so that it creates a starting point where the General Ledger and Inventory Control Balance, and then the tool creates the report.

• The HITB Report was specifically designed to balance IV to GL
• The report shows your inventory value as of a specific date or date range and the value of the five-different quantity types. (On Hand, In Use, In Service, Damaged, Returned) The Historical Stock Status report only shows on hand quantities.
• The HITB Report shows specific cost adjustments which can cause the inventory balance to differ from the General Ledger balance
• The HITB Report always updates when a transaction is posted to the General Ledger. 
• The HITB Report works faster that the Historical Stock Status report

The Historical Inventory Trial Balance Reset Tool has specific steps that must be followed to correctly install it.  Microsoft Partners and Customers can find the system requirements and installation notes at https://mbs.microsoft.com/customersource/northamerica/GP/downloads/service-packs/MDGP10_HITB#Downloads.

For more information on Microsoft Dynamics GP or available tools for Dynamics GP, contact us at Dynamics MCT Consulting.  Send an email to Support@dynamicsmct.com or call us at Toll Free:  +1.780-555-6144.

Submitted by Judith Hirst CPA, CMA MCP