0012417: Inactive Products appeat in the stock report

Description

Even if a product is inactive and it's quantity is 0, it will still appear in the stock report and in the valued stock report.

Steps To Reproduce

Select a product that have been through some movement (Goods receipt, Goods Shipment or Inventory) but whose quantity is curently 0 (for all Warehouses).
Uncheck the "Active checkbox" in the Product screen
Generate the Stock Report --> The product still appears with Quantity 0 in the warehouses it has been through
Generate the Valued Stock Report --> The product still appears with Quantity 0 in the warehouses it has been through

Proposed Solution

Add the following SQL in the report query (In the WHERE Clause)
AND m_product.is_active = 'Y'

both in the xsql file related to Stock report and valued Stock report

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0040989) psarobe (manager) 2011-09-16 09:02	Now products with no stock or stock = 0 don't appear anymore

Issue History
Date Modified	Username	Field	Change
2010-02-23 15:22	Guillaume_Jump	New Issue
2010-02-23 15:22	Guillaume_Jump	Assigned To	=> adrianromero
2010-12-29 11:24	RenateNieuwkoop	Issue Monitored: RenateNieuwkoop
2011-06-03 10:58	dalsasua	Assigned To	adrianromero => dalsasua
2011-07-20 18:13	dalsasua	Assigned To	dalsasua => jonalegriaesarte
2011-09-16 09:02	psarobe	Note Added: 0040989
2011-09-16 09:02	psarobe	Status	new => closed
2011-09-16 09:02	psarobe	Resolution	open => out of date