Export a Stock Report to Spreadsheet

Back Top Prev Next Print

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.

stockexcel

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.

excelstock

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

Stock Security

Consignment Stock

Consignment Stock for Customers

Kitting v Packaging v Manufacturing

Kitting

Packaging

Promotional Pricing

Stock Adjustments

Stock Attributes

Stock Flow

Stock List

Create a Stock List

Stock Preview Pane

Stock Pricing

Order of Pricing

Stock Procurement

Stock Reports

Stock Transfers

Stocktake

Tabs in the Footer

Tabs in the Header

Warehouse Management

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

Buying your own stock

Change a Serial Number on a Stock Record

Change Stock GL Group

Create Similar

Deactivate a Stock Code

Deactivate Stock in Bulk

Donations of Stock

Generate Backdated Stock on Hand Report

Handle Warranty Stock

Import Vendor Pricing

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