Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
08-29-2018, 12:22 PM (This post was last modified: 08-29-2018 12:28 PM by TurboPT.)
Post: #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 ... 
Find all posts by this user
Quote this message in a reply
08-30-2018, 04:31 AM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
08-30-2018, 06:43 AM
Post: #4
RE: Z_CheckDebtorsControl Error? - SOLVED?
Paul... I changed both lines in my script. Sorry about ambiguity...

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
08-30-2018, 09:57 AM
Post: #5
RE: Z_CheckDebtorsControl Error? - SOLVED?
No worries, Paul, just wanted to be sure.
Find all posts by this user
Quote this message in a reply
09-03-2018, 12:07 PM
Post: #6
RE: Z_CheckDebtorsControl Error? - SOLVED?
Calculation fix committed to the bug_fixes branch.
Find all posts by this user
Quote this message in a reply
09-04-2018, 01:27 AM
Post: #7
RE: Z_CheckDebtorsControl Error? - SOLVED?
Thank You!

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)