Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sales Integrity Check - Missing WHERE Clause?
12-15-2018, 06:32 AM,
#1
Sales Integrity Check - Missing WHERE Clause?
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?
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)