Export a Stock Report to Spreadsheet

There are two ways you can export a stock  report to a spreadsheet.

1.With the stock code open, select the appropriate report in the ribbon, then select Print. In the Print dialog box, change to Export and select the Xlsx Report File in the Type field. This can then be saved locally.

2.With the stock code open, select the appropriate report in the ribbon, then select the Excel icon beside it. This will show each report pipeline in a separate sheet, ie. Stock, Stock Price, Vendors, Bins, Attributes, etc.

You can use the Excel icon to produce reports directly to Excel. Permission for use of this is based on security since it accesses the report for the information.

Further information

Add Stock

Add Service Stock

Add a Document to Stock

Add Groups to Stock

Add Images to Stock

Add Multiple Stock Records

Add Vendor Codes

Backfill Stock Sold in Advance

Buy and Sell in Different Measures

Buy your own stock

Change a Serial Number on a Stock Record

Change Stock GL Group

Create a Stock List

Create Similar

Deactivate a Stock Code

Deactivate Stock in Bulk

Generate Backdated Stock on Hand Report

Handle Warranty Stock

Import Vendor Pricing

Make Donations of Stock

Merge Stock Codes/Supersede

Move Stock from Depleting to Asset

Print Shelf Talkers

Print Stock Reports

Sell Stock in Advance

Set up Pricing

Stop Users From Giving Discounts

Track Serial Numbers

Unallocate Stock

Update Existing Stock Pricing

Update Existing Vendor Pricing

Update Lead Time on Vendor Tab

Update Stock Procurement Data

Update Stock Records

Use Stock Select

Use Your Own Inventory

View or Edit Stock

Write off Stock

Use Gift Card for Purchases