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

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

What should we write about next?





Your Name (required) –
Your Email (required) –

Leave a Reply

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