X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FRC.pm;h=63a41f434c1e8bab99e1c5047cbf1f36593cfddd;hb=f257623461bda92a232a238a322f207b8964faab;hp=f9e789161c5ac91c10882ea2051025d025d77d06;hpb=d319704a66e9be64da837ccea10af6774c2b0838;p=kivitendo-erp.git diff --git a/SL/RC.pm b/SL/RC.pm index f9e789161..63a41f434 100644 --- a/SL/RC.pm +++ b/SL/RC.pm @@ -117,11 +117,11 @@ sub payment_transactions { $query .= " AND ac.transdate <= '$form->{todate}'" if $form->{todate}; $query .= qq| - + UNION SELECT v.name, ac.source, ac.transdate, ac.cleared, ac.fx_transaction, ac.amount, a.id, - $oid{$myconfig->{dbdriver}} AS oid + $oid{$myconfig->{dbdriver}} AS oid FROM vendor v, acc_trans ac, ap a, chart ch WHERE v.id = a.vendor_id -- AND NOT ac.fx_transaction @@ -135,11 +135,11 @@ sub payment_transactions { $query .= " AND ac.transdate <= '$form->{todate}'" if $form->{todate}; $query .= qq| - + UNION SELECT g.description, ac.source, ac.transdate, ac.cleared, ac.fx_transaction, ac.amount, g.id, - $oid{$myconfig->{dbdriver}} AS oid + $oid{$myconfig->{dbdriver}} AS oid FROM gl g, acc_trans ac, chart ch WHERE g.id = ac.trans_id -- AND NOT ac.fx_transaction @@ -201,4 +201,3 @@ sub reconcile { } 1; -