Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sales Integrity Check Missing SUM - SOLVED
12-08-2018, 04:00 AM (This post was last modified: 12-08-2018 04:03 AM by VortecCPI.)
Post: #1
Sales Integrity Check Missing SUM - SOLVED
Z_SalesIntegrityCheck.php

To support multiple invoices for one Sales Order this SQL:

PHP Code:
        $invSQL "SELECT transno,
                            type,
                            trandate,
                            settled,
                            rate,
                            ovamount,
                            ovgst
                     FROM debtortrans WHERE order_ = '" 
$myrow['orderno'] . "'"

Must be changed to this:

PHP Code:
        $invSQL "SELECT transno,
                            type,
                            trandate,
                            settled,
                            rate,
                            SUM(ovamount) AS ovamount,
                            ovgst
                     FROM debtortrans WHERE order_ = '" 
$myrow['orderno'] . "'"

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
12-08-2018, 01:48 PM
Post: #2
RE: Sales Integrity Check Missing SUM - SOLVED
Will fix this tomorrow.
Find all posts by this user
Quote this message in a reply
12-09-2018, 02:12 AM
Post: #3
RE: Sales Integrity Check Missing SUM - SOLVED
Change committed.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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