This 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 (). When the count is started, the Export/Import option will become available allowing the user to export rhe count data to an Excel worksheet:
Once you are ready to import your numbers into the Stock Count Entry window (). open the stock count which you want to import, and click the Export/Import button on the toolbar:
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.