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, March 3, 2015

Dynamics GP Stock Count Import Module for Inventory Updates

Posted by Steve Chapman

The Dynamics GP Stock Count Import module makes it easy to update GP with actual inventory count information. The module works in conjunction with the standard stock count functionality in Dynamics GP.

Basically, it creates a count template in a tab delimited or comma delimited file. You can use this file in Excel to enter your count information.

Once the physical count is completed and you have entered the count information into the count template in Excel, import the count results into Dynamics GP.

Here are the basic steps to perform this process:

  1. Create Stock Count Schedule.
  2. Save Stock Count Schedule.
  3. Start Stock Count.
  4. Create Stock Count Import template.
  5. Complete stock count.
  6. Import completed Stock Count Import template.
  7. Review count in Stock Count Entry screen.
  8. Process Stock Count Entry.

Once you’ve started the Stock Count, you can create the count template with the Stock Count Import screen:

Dynamics GP Stock Count Import Module

This is an example of the stock count template with some count information already input. You can see multiple inventory sites, and some lot controlled items, with the existing lot numbers:

Dynamics GP Stock Count Import Module

Once you’ve entered all the count data into Excel, you can save the file and import it into GP with the Stock Count Import screen.

After the count information is imported, a Count Variance report prints out and the relevant Stock Count Entry screen opens, ready for review and analysis. You can make any changes here, and then process the count.

Dynamics GP Stock Count Import Module

The Dynamics Stock Count Import module will speed up your physical counts, requiring less time to complete, and with higher accuracy.

Take a look at this short video showing this process in action to see the functionality visually.

Discover more about the Stock Count Import module for Dynamics GP and find more custom modules and integrations in the Armanino Marketplace.

Steve has over 15 years of experience in business systems consulting, and 20 years of experience in management accounting and finance with small and mid-sized businesses in the construction, distribution, service, and technology industries.


comments powered by Disqus
« | »