webERP Forum
Sales Integrity Check - Missing WHERE Clause? - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Sales Integrity Check - Missing WHERE Clause? (/showthread.php?tid=8311)



Sales Integrity Check - Missing WHERE Clause? - VortecCPI - 12-15-2018

Z_SalesIntegrityCheck

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.

Thoughts?