Stock Movements Report

Stock Movements Report (#127)

This report displays the contents of the stock movements audit trail. All movements of stock that involve quantity changes are recorded in this report, including kit components. Such movements include invoices, purchase order deliveries, stock receipts, stocktakes, assemblying, direct adjustments (through Stock Control), and so on.

From Start Date

Click on to select or enter the first date to view movements from.

To End Date

Click on to select or enter the last date to view movements to.

Product Code

Enter a product code here or leave blank to print a report for all products or for stock or supplier groups.

The next three settings are ignored if a product code is specified.

Moving Stock

Select this option if you only want stock that has moved to be printed on this report.

Include All Products

Select this option if you wish to list all products on the report, even if there has been no movement for the indicated date range.

Only Non-Moving

Select this option to only list stock that has not moved in any way for the indicated date range.

Movement Details

Tick to include details relating to the source transactions that make up the movement history of listed stock items. For example, if the movement history shows 5 sales, ticking this option would list the invoice transactions that make up these 5 sales, below the movement totals.

Show Variance

The report may be printed in two styles.

Standard Style

The standard style displays the opening/starting stock quantity at the beginning of the selected date range, and then deliveries/receipts, sales, adjustments, and the final ending/closing quantity balance by the end date.

Variance Style

In this format sales, deliveries/receipts, returns, assemblies and other adjustments are shown and a variance column indicates the total quantity changed between the two selected dates.

Include Only Kits

Tick this option to list kit related movements only.

Box Quantities

Tick to show quantities in box quantities where applicable.

Hints & Tips

For 'variance style' reporting positive numbers on the report indicate sales/reductions in stock. Negative numbers indicate purchases/stock/receipts and other increases in stock.
Movements are recorded and reported at the component or unit level. Keep in mind that many stock sales analysis reports will display information summarised at the "kit" level if stock kits are in use.

If you have selected Movement Details and purchase order or stock receipt deliveries are listed, then the quantities shown are those after any box conversions have taken place. Caution is required if the box conversion factor of a stock item has changed between deliveries of stock, as the quantities listed on this report are always based on the current/last box conversion factor recorded against a stock item.

____________________________