Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sales Integrity Check - Missing WHERE Clause?
12-15-2018, 06:32 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)