$uid = substr($uid, 2, 75);
$query =
- qq|INSERT INTO ap (invnumber, employee_id) | .
- qq|VALUES (?, (SELECT e.id FROM employee e WHERE e.login = ?))|;
- do_query($form, $dbh, $query, $uid, $form->{login});
+ qq|INSERT INTO ap (invnumber, employee_id,currency_id) | .
+ qq|VALUES (?, (SELECT e.id FROM employee e WHERE e.login = ?),
+ (SELECT id FROM currencies WHERE name = ?) )|;
+ do_query($form, $dbh, $query, $uid, $form->{login}, $form->{currency});
$query = qq|SELECT a.id FROM ap a
WHERE a.invnumber = ?|;
$query =
qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, fx_transaction, cleared, project_id, taxkey, tax_id, chart_link) | .
qq|VALUES (?, (SELECT id FROM chart WHERE accno = ?), ?, ?, 't', 'f', ?, | .
- qq| (SELECT taxkey_id FROM chart WHERE accno = ?)| .
+ qq| (SELECT taxkey_id FROM chart WHERE accno = ?),| .
qq| (SELECT tax_id| .
qq| FROM taxkeys| .
qq| WHERE chart_id= (SELECT id | .
dbh => $dbh,
from => $transdate,
to => $transdate,
+ trans_id => $form->{id},
);
$datev->export;
qq|LEFT JOIN payment_terms pt ON (pt.id = v.payment_id)|;
my $where = '';
+
+ unless ( $main::auth->check_right($form->{login}, 'show_ap_transactions') ) {
+ $where .= " AND NOT invoice = 'f' "; # remove ap transactions from Sales -> Reports -> Invoices
+ };
+
my @values;
if ($form->{vendor_id}) {
}
1;
-