138 |
138 |
currency_id = (SELECT id FROM currencies WHERE name = ?),
|
139 |
139 |
netamount = ?, notes = ?, department_id = ?,
|
140 |
140 |
employee_id = ?, storno = ?, storno_id = ?, globalproject_id = ?,
|
141 |
|
direct_debit = ?
|
|
141 |
direct_debit = ?, transaction_description = ?
|
142 |
142 |
WHERE id = ?|;
|
143 |
143 |
my @values = ($form->{invnumber}, $form->{ordnumber}, conv_date($form->{transdate}), conv_i($form->{customer_id}), $form->{taxincluded} ? 't' : 'f', $form->{amount},
|
144 |
144 |
conv_date($form->{duedate}), conv_date($form->{deliverydate}), conv_date($form->{tax_point}), $form->{paid},
|
145 |
145 |
$form->{currency},
|
146 |
146 |
$form->{netamount}, $form->{notes}, conv_i($form->{department_id}),
|
147 |
147 |
conv_i($form->{employee_id}), $form->{storno} ? 't' : 'f', $form->{storno_id},
|
148 |
|
conv_i($form->{globalproject_id}), $form->{direct_debit} ? 't' : 'f', conv_i($form->{id}));
|
|
148 |
conv_i($form->{globalproject_id}), $form->{direct_debit} ? 't' : 'f', $form->{transaction_description},
|
|
149 |
conv_i($form->{id}));
|
149 |
150 |
do_query($form, $dbh, $query, @values);
|
150 |
151 |
|
151 |
152 |
# add individual transactions for AR, amount and taxes
|
Vorgangsbezeichnung in Debitorenbuchung: Speichern und Laden