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?
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
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.
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