The Spreadsheet report - Stock movement will list the total stock quantities for each stock item in and out for the selected period. 

The data in this spreadsheet is similar to the "Stock In / Out" report (Reports → Stock items → Stock In / Out - (Reports ribbon)).

The following will be included in the spreadsheet:

  • Only documents (i.e. invoices, credit notes, purchase and supplier return documents) which is posted (updated to the ledger) will be included. 
  • Only the default stock type (trading stock items (Stock item type = 0))  will be included. 

The following will be excluded from the spreadsheet:

  • All the other ten (10) stock types (e.g. Sales, Sales (no stock), Purchases, Purchases (no stock), Financial entry, Option item, Option item (no stock), BOM, BOM (Production) and Linked item) will be excluded in the spreadsheet import.

To import Stock movements (Stock In / Out) into a spreadsheet: 

  1. On the Reports ribbon, select Spreadsheet reports → Sales analysis → Stock movement. 
  2. On the parameters ("Params") screen, select the period and click OK. The total quantities for each stock item will be listed in the spreadsheet:

The Document type in column, E is as follows:

10 - Invoice

11 - Credit note

12 - Purchase 

13 - Supplier return

14 - Quote

15 - Order 

16 - Adjustment

Quotes and Orders will be excluded in the spreadsheet import.