Product Movement Report

I have run the Product Movement Report and can see only the products in stock that have moved.  Where are the rest of my products?

Solution

The report will print a product code in the selected date range if:

There is a closing quantity on hand at the last date and they have ticked the box for no movements

OR

There has been some movement – invoice, receipt, manual sale, writeoff, stock take adjustment or used to make a kitset or been created as a kitset.  But it is not reporting on Transfers currently see ticket 13029.

This is the PRINT WHEN on the columns

(z_closed <> 0 and nzf_nomove) or z_invoice <> 0 or z_receipt <> 0 or z_manual <>0 or z_writeoff <> 0 or z_stktake <> 0 or z_kitset <> 0 or z_produce <> 0

The report works out (using the current qty on hand, and the product transactions in PRODAUD )

What the closing stock on hand is for the TO DATE, and finds all the transactions between the FROM DATE and the TO DATE, and classifies them, and then can calculate what the opening balance was on the FROM DATE.

But, if the Include Products with NO Movements is ticked, all products will show.

NOTE: This report will also show products set to "Not Track Quantities" see ticket 12882. 

Partners See Stock Turn Formula