Thread Rating:
  • 0 Vote(s) - 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.)
#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
Reply
12-08-2018, 01:48 PM,
#2
RE: Sales Integrity Check Missing SUM - SOLVED
Will fix this tomorrow.
Reply
12-09-2018, 02:12 AM,
#3
RE: Sales Integrity Check Missing SUM - SOLVED
Change committed.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)