Inventory Shortages Export

This article assumes you have already set up the Inventory Shortages functionality of AcctVantage.

See here for more info.

1. Open the Inventory Shortages screen

Navigate to Purchasing > Inventory Shortages and select your Data Source(s).

See here for more info on Processing Auto Purchase Orders.

Inventory Shortages - Data Source(s)

2. Export the Inventory Shortages data

At the bottom of the Inventory Shortages window, click the Export button. Select a save destination for the export file.

Inventory Shortages list

3. Export is complete

The exported file will be a tab-delimited text file, which will contain the exact same rows and columns that you see in the Inventory Shortages window.

You can open this file in your favorite spreadsheet program.

Export complete

3.1. Open the file in Excel

The export file is a tab-delimited text file. You can open it in Excel by going to Data > From Text, set the delimiter to "tab" and then open the file.