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: PHP Code: // line 111: 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! |