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

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