webERP Forum

Full Version: Sales Integrity Check - Missing WHERE Clause?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

I think Line 175

PHP Code:
$SQL "SELECT stkmoveno, transno FROM stockmoves; 

Should be:

PHP Code:
$SQL "SELECT stkmoveno, transno FROM stockmoves WHERE type BETWEEN 10 AND 11"

As only stock moves of type 10 or 11 are applicable.