737 |
737 |
invoice = ?, taxzone_id = ?, notes = ?, taxincluded = ?,
|
738 |
738 |
intnotes = ?, storno_id = ?, storno = ?,
|
739 |
739 |
cp_id = ?, employee_id = ?, department_id = ?, delivery_term_id = ?,
|
|
740 |
payment_id = ?,
|
740 |
741 |
currency_id = (SELECT id FROM currencies WHERE name = ?),
|
741 |
742 |
globalproject_id = ?, direct_debit = ?
|
742 |
743 |
WHERE id = ?|;
|
... | ... | |
747 |
748 |
'1', $taxzone_id, $restricter->process($form->{notes}), $form->{taxincluded} ? 't' : 'f',
|
748 |
749 |
$form->{intnotes}, conv_i($form->{storno_id}), $form->{storno} ? 't' : 'f',
|
749 |
750 |
conv_i($form->{cp_id}), conv_i($form->{employee_id}), conv_i($form->{department_id}), conv_i($form->{delivery_term_id}),
|
|
751 |
conv_i($form->{payment_id}),
|
750 |
752 |
$form->{"currency"},
|
751 |
753 |
conv_i($form->{globalproject_id}),
|
752 |
754 |
$form->{direct_debit} ? 't' : 'f',
|
... | ... | |
1004 |
1006 |
ordnumber, quonumber, paid, taxincluded, notes, taxzone_id, storno, gldate,
|
1005 |
1007 |
mtime, itime,
|
1006 |
1008 |
intnotes, (SELECT cu.name FROM currencies cu WHERE cu.id=ap.currency_id) AS currency, direct_debit,
|
1007 |
|
delivery_term_id
|
|
1009 |
payment_id, delivery_term_id
|
1008 |
1010 |
FROM ap
|
1009 |
1011 |
WHERE id = ?|;
|
1010 |
1012 |
$ref = selectfirst_hashref_query($form, $dbh, $query, conv_i($form->{id}));
|
Zahlungsbedingungen auch in Ek-Rechnung angeben können
Diese werden im Bericht EK-Rechnungen schon aus den DB-Daten der Rechnung
angezeigt und nicht aus den Lieferanten-Stammdaten. Die Zahlungsbedingungen
können ja durchaus mal von denen abweichen, die in den Lieferanten-Stammdaten
hinterlegt sind.
Zudem ist es dann gleich dem Verhalten im Verkauf.
Behebt #35 (redmine)
Refs #36 (redmine)