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

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

Dynamics GP 2016 R2–Accounts Receivable Module Improvements

 

Figure 1 – Cash Receipts entry window in Dynamics GP 2016 R2

In an attempt to streamline accounts receivables processes, functionality has been added to Dynamics GP that will allow the deposit of cash receipts in a batch to occur automatically. If this option is enabled, a single deposit will be created that includes all cash receipts in the batch, or if receivables are posted at the transaction level each cash receipt will result in a separate deposit being created and posted. This functionality will save steps and time in dealing with cash receipts.

Other Accounts Receivable improvements include:

• Batch approval workflows now have default word templates for edit lists to be emailed to approvers and supply them with complete information about the transactions in the batch.

Talk to us, at Dynamics MCT Consulting, about upgrading to Dynamics GP 2016 R2.  Contact Support@Dynamicsmct.com.

Submitted by Terence Graw CPA, CMA – Consultant

How To Import Stock Count into Dynamics GP–Stock Count Import Tool

 

 

Figure 1 from Armanino LLP

Companies do routine stock counts based on the Count Cycle in Dynamics GP.  Sometime, the stock count actual entry can take a very long time if there are lots of items to enter.

A handy tool for entering and importing data into the stock count in GP comes from Armanino LLP.  Armanino’s Stock Count Import module makes it easy to update Microsoft Dynamics GP with actual inventory count information.

This module enhances Microsoft Dynamics GP by:

• Creating import templates in conjunction with the standard Dynamics GP Cycle Count process
• Allowing splitting of count sheets to multiple people
• Allowing count entry via laptops or other mobile devices
• Importing inventory count information in conjunction with the standard Dynamics GP Cycle Count process
• Automatically marking the Verification Check Box upon import, saving countless hours of tagging files
• Supporting serial and lot numbers
• Enhancing variance reporting

If you want to explore new ways to upload your count information into 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