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