}
if ($form->{project_id}) {
$where .=
- qq|AND ((a.globalproject_id = ?) OR EXISTS | .
+ qq| AND ((a.globalproject_id = ?) OR EXISTS | .
qq| (SELECT * FROM invoice i | .
qq| WHERE i.project_id = ? AND i.trans_id = a.id) | .
qq| OR EXISTS | .
if ($form->{parts_partnumber}) {
$where .= <<SQL;
- AND EXISTS (
+ AND EXISTS (
SELECT invoice.trans_id
FROM invoice
LEFT JOIN parts ON (invoice.parts_id = parts.id)
if ($form->{parts_description}) {
$where .= <<SQL;
- AND EXISTS (
+ AND EXISTS (
SELECT invoice.trans_id
FROM invoice
WHERE (invoice.trans_id = a.id)
}
$index = $form->{acc_trans}{$key}->[$i - 1]->{index};
- $form->{"tax_$index"} = $form->{acc_trans}{$key}->[$i - 1]->{amount} * -1;
+ $form->{"tax_$index"} = $form->round_amount($form->{acc_trans}{$key}->[$i - 1]->{amount} * -1 / $exchangerate, 2);
$totaltax += $form->{"tax_$index"};
} else {