How To Import and Export Inventory Stock Counts

One favorite year-end activity is inventory stock counts!  A new feature, added in GP 18.3 (October 2020 release), is the ability to export and import Stock Count data to and from Excel.

The Stock Count Schedule window has a new “Export/Import” button.  This button becomes available once the schedule has been Started.  The export action will create a file called stockcountmmddyy.xlsx in whatever file location you choose.

inventory stock count import or export

Once you’ve entered your counts in the spreadsheet, go to the Stock County Entry window.  Click on the Export/Import window, select Import and browse out to and select your file.  Counts can still be manually edited after the import has been run.

If you need to reimport the file, you’ll first need to click on Clear Count.

We hope this is a helpful tip for importing or exporting year-end inventory stock counts in GP. Need help? Please contact CSSI.