webERP Forum
Z_CheckDebtorsControl Error? - SOLVED? - Printable Version

+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1)
+--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8)
+--- Thread: Z_CheckDebtorsControl Error? - SOLVED? (/showthread.php?tid=8188)



Z_CheckDebtorsControl Error? - SOLVED? - VortecCPI - 08-15-2018

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...


RE: Z_CheckDebtorsControl Error? - SOLVED? - TurboPT - 08-29-2018

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 ... 



RE: Z_CheckDebtorsControl Error? - SOLVED? - TimSchofield - 08-30-2018

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


RE: Z_CheckDebtorsControl Error? - SOLVED? - VortecCPI - 08-30-2018

Paul... I changed both lines in my script. Sorry about ambiguity...


RE: Z_CheckDebtorsControl Error? - SOLVED? - TurboPT - 08-30-2018

No worries, Paul, just wanted to be sure.


RE: Z_CheckDebtorsControl Error? - SOLVED? - TurboPT - 09-03-2018

Calculation fix committed to the bug_fixes branch.


RE: Z_CheckDebtorsControl Error? - SOLVED? - VortecCPI - 09-04-2018

Thank You!