Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Z_CheckDebtorsControl Error? - SOLVED?
08-15-2018, 06:59 AM, (This post was last modified: 08-15-2018, 09:52 AM by VortecCPI.)
#1
Z_CheckDebtorsControl Error? - SOLVED?
I ran Z_CheckDebtorsControl.php and came up with some discrepancies. Before I go digging into this I wanted to first ask what is the purpose of this script?

Looks like we need to change:

PHP Code:
$SQL "SELECT SUM((ovamount+ovgst)/rate) 

To this:

PHP Code:
$SQL "SELECT SUM((ovamount+ovgst+ovfreight+ovdiscount)/rate) 

At least that's what worked in our case...
https://www.linkedin.com/in/eclipsepaulbecker
Reply
08-29-2018, 12:22 PM, (This post was last modified: 08-29-2018, 12:28 PM by TurboPT.)
#2
RE: Z_CheckDebtorsControl Error? - SOLVED?
Paul, was that change applied at two places in this file?

I show:
PHP Code:
// line 99:
$SQL "SELECT SUM((ovamount+ovgst)/rate) AS totinvnetcrds ... 
PHP Code:
// line 111:
$SQL "SELECT SUM((ovamount+ovgst)/rate) AS totreceipts ... 
Reply
08-30-2018, 04:31 AM,
#3
RE: Z_CheckDebtorsControl Error? - SOLVED?
Am pretty sure that ovdiscount is only filled in by the receipt script but it won't actually do anything harm to change both.

Tim
Reply
08-30-2018, 06:43 AM,
#4
RE: Z_CheckDebtorsControl Error? - SOLVED?
Paul... I changed both lines in my script. Sorry about ambiguity...
https://www.linkedin.com/in/eclipsepaulbecker
Reply
08-30-2018, 09:57 AM,
#5
RE: Z_CheckDebtorsControl Error? - SOLVED?
No worries, Paul, just wanted to be sure.
Reply
09-03-2018, 12:07 PM,
#6
RE: Z_CheckDebtorsControl Error? - SOLVED?
Calculation fix committed to the bug_fixes branch.
Reply
09-04-2018, 01:27 AM,
#7
RE: Z_CheckDebtorsControl Error? - SOLVED?
Thank You!
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)