Microsoft Dynamics GP Fall 2020 Release New Features: Export/Import stock counts to Excel

Microsoft Dynamics GPThis post is part of the Microsoft Dynamics GP Fall 2020 Release New Features series where I am going to echo the posts from the Dynamics GP Support and Services Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP Fall 2020 Release which is now available.

This post is on the Export/Import stock counts to Excel Distribution enhancement.

The Stock Count Schedule and Stock Count Entry windows have had an Export/Import option added. When a stock count schedule is created, you can now export the data to excel. Then once the stock has been counted, Excel spreadsheet can be imported into the Stock Count Entry window where the Inventory variance can be posted.

To use this functionality, open the Stock Count Schedule window (Inventory area page » Transactions » Stock Count Schedule). When the count is started, the Export/Import option will become available allowing the user to export rhe count data to an Excel worksheet:

Stock Count Schedule

Once you are ready to import your numbers into the Stock Count Entry window (Inventory area page » Transactions » Stock Count Entry). open the stock count which you want to import, and click the Export/Import button on the toolbar:

Stock Count Entry

This is a feature which has long been overdue and will be warmly welcomed by a number of clients. I’ve always struggled to think of a good reason why there was not an import/export routine for stock counts.

Click to show/hide the Microsoft Dynamics GP Fall 2020 Release New Features Series Index

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

Your email address will not be published. Required fields are marked *