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