About Running General Ledger Reconcile in Dynamics GP

                  

Figure 1 -  The RECONCILE FINANCIAL window in Dynamics GP

Last week, there was a large storm in Alberta that stretched from Edmonton down through Calgary and south, and east into Saskatchewan.  The winds knocked down trees and branches, which ended up knocking out some power.

Microsoft recommends running the reconcile utilities after a power outage or server issue. Microsoft suggests that:

"companies use the Reconcile Financial Information window to reset account totals in the chart of accounts so they match the posted transaction amounts. Reconciling an open year ensures that amounts on the financial statements are the same as the totals printed on the Detailed Trial Balance. Reconciling recalculates account summary amounts for the open periods."

This information discusses how to run the reconcile on the Dynamics

1.   Financial (Tools > Utilities > Financial > Reconcile). The options to reconcile in the General Ledger are fairly straightforward, as listed below.

             a)   Allocation Accounts - Mark this option to verify that all allocation accounts, distribution accounts, and account types are valid.

If you reconcile allocation accounts, the system verifies the validity of all allocation accounts, distribution and breakdown accounts, and account types. If the allocation accounts contain errors, the Reconcile Report is printed. The reconciliation process doesn't correct allocation account errors, you must enter those corrections manually.

             b) Year – Select this option to review the transaction detail for each general ledger account and update the Summary totals for the selected year. You would run this reconcile if the information in the Summary Inquiry (Inquiry > Financial > Summary) or History Summary Inquiry (Inquiry > Financial > History Summary) is incorrect when compared to the transaction totals.

 NOTE: Only reconcile your historical years if you keep account and transaction history

             c) Batches – Choose this option to review the transactions that are assigned to a batch in general ledger and update the batch header information. Use this reconcile if your batch total is not correct, or if there are transactions that are not appearing in a batch.

If you reconcile batches and identifying records are added, the Reconcile Report is printed.

2.    Choose Posting Numbers to open the Reconcile Posting Numbers window, where you can reconcile posting numbers so that no gaps in the posting number sequence exist.

The Posting Numbers buttons appears only if you have marked the Enable Posting Numbers in General Ledger option in the Company Setup Options window. Sequential posting numbers are a legal requirement in some European countries.

3.     Choose Reconcile to reconcile account totals, batch information, or both.

Contact us  at Dynamics MCT Consulting to get assistance on executing the Financial Reconcile or to get mor 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

www.dynamicsmct.com

New Features in HR and Payroll in Dynamics GP 2016 R2

 

Figure 1 – how to get to the new employment history window in GP 2016 R2 – US Payroll only

A very simple, but powerful improvement made to the payroll and human resource module is the new ability to track history on termination and rehire dates for employees. Any time a hire date, adjusted hire date, date inactivated, last day worked or termination date is updated in the system, that information will be saved and can be viewed through the employee history inquiry window. Tracking employee history with the company has now become simple.

Other payroll and human resource improvements include:

• Vendor addresses and accounts can be established in the payroll vendor setup window, allowing for a different distribution than those currently assigned to the vendor.
• A warning is now available for potential double deductions for mandatory arrears deductions due to a previous posting.
• Tip tax amounts are now included in distribution pre-posting reports for viewing before posting.
• An option is now available to exclude inactive pay codes from lookup windows throughout payroll.
• An enhanced payroll posting accounts setup now exits with navigation lists having filter and sort capabilities along with excel export and import functionality.

Are you a Dynamics MCT client interested in installing Microsoft Dynamics GP 2016 R2? Contact us first. Dynamics MCT Consulting - email to Support@dynamicsmct.com or call us at Toll Free:  +1 780-555-6144.

Submitted by Terence Graw CPA, CMA – Consultant   www.dynamicsmct.com

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