Hi Georgina,

Thanks for using Sage City.

Try hiding the inactive stock records from the product list and then run the report again. To hide them go into Products and services and clear the Include inactive check box at the top-right.

If this has answered your question please click More > Verify Answer.

Regards,

Paul
Sage UKI

Thanks Paul for your response unfortunalty I had already tried that and it didnt work.