It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Report Bugs here → Bug in report 110
Hello,
it seems there is a bug in report 110 "Print Deliveries"
the bug appears when you create a new sales order and add a shipping value.
the shipping value would be shown correctly in the sales order report.
but when printing deliveries the shipping value w'll always appear as "0" even though the total balance is correct.
i tested it on the default demo page and i got the same result.
please check the attached image
https://ibb.co/cATmYb
Replace line 161 in reporting/rep110.php:
$DisplayFreight = number_format2($sign*$myrow["ov_freight"],$dec);with:
$DisplayFreight = number_format2($myrow["ov_freight"],$dec);The $sign is not defined anywhere in the report and may be present through some include when a sales order is being printed. The $sign was not present in FA 2.3.x.
@joe: Should this be committed?
works great now.. but wondering why $sign works just fine in other reports like 107.
I will look at this in a while.
Joe
Addendum to your commit:
In rep102.php, $sign is computed and then used in the sql so it is okay.
In rep107.php $sign is assigned 1 and used and hence it can be fully eliminated unless there are some CAST issues.
In rep113.php, $sign is assigned -1 and used and may be removed likewise and the sign made inline.
In rep109.php, rep111.php and rep209.php just as in rep110.php here, $sign is not assigned anywhere in the script and hence can be removed as done herein.
FrontAccounting forum → Report Bugs here → Bug in report 110
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.