Revision 517ed14d
Von Bernd Bleßmann vor mehr als 4 Jahren hinzugefügt
| SL/IR.pm | ||
|---|---|---|
| 730 | 730 |
|
| 731 | 731 |
# save AP record |
| 732 | 732 |
$query = qq|UPDATE ap SET |
| 733 |
invnumber = ?, ordnumber = ?, quonumber = ?, transdate = ?, |
|
| 734 |
orddate = ?, quodate = ?, vendor_id = ?, amount = ?, |
|
| 735 |
netamount = ?, paid = ?, duedate = ?, |
|
| 736 |
invoice = ?, taxzone_id = ?, notes = ?, taxincluded = ?, |
|
| 733 |
invnumber = ?, ordnumber = ?, quonumber = ?, transdate = ?,
|
|
| 734 |
orddate = ?, quodate = ?, vendor_id = ?, amount = ?,
|
|
| 735 |
netamount = ?, paid = ?, duedate = ?, deliverydate = ?,
|
|
| 736 |
invoice = ?, taxzone_id = ?, notes = ?, taxincluded = ?,
|
|
| 737 | 737 |
intnotes = ?, storno_id = ?, storno = ?, |
| 738 | 738 |
cp_id = ?, employee_id = ?, department_id = ?, delivery_term_id = ?, |
| 739 | 739 |
currency_id = (SELECT id FROM currencies WHERE name = ?), |
| ... | ... | |
| 742 | 742 |
@values = ( |
| 743 | 743 |
$form->{invnumber}, $form->{ordnumber}, $form->{quonumber}, conv_date($form->{invdate}),
|
| 744 | 744 |
conv_date($form->{orddate}), conv_date($form->{quodate}), conv_i($form->{vendor_id}), $amount,
|
| 745 |
$netamount, $form->{paid}, conv_date($form->{duedate}),
|
|
| 745 |
$netamount, $form->{paid}, conv_date($form->{duedate}), conv_date($form->{deliverydate}),
|
|
| 746 | 746 |
'1', $taxzone_id, $restricter->process($form->{notes}), $form->{taxincluded} ? 't' : 'f',
|
| 747 | 747 |
$form->{intnotes}, conv_i($form->{storno_id}), $form->{storno} ? 't' : 'f',
|
| 748 | 748 |
conv_i($form->{cp_id}), conv_i($form->{employee_id}), conv_i($form->{department_id}), conv_i($form->{delivery_term_id}),
|
| ... | ... | |
| 999 | 999 |
|
| 1000 | 1000 |
# retrieve invoice |
| 1001 | 1001 |
$query = qq|SELECT cp_id, invnumber, transdate AS invdate, duedate, |
| 1002 |
orddate, quodate, globalproject_id, |
|
| 1002 |
orddate, quodate, deliverydate, globalproject_id,
|
|
| 1003 | 1003 |
ordnumber, quonumber, paid, taxincluded, notes, taxzone_id, storno, gldate, |
| 1004 | 1004 |
mtime, itime, |
| 1005 | 1005 |
intnotes, (SELECT cu.name FROM currencies cu WHERE cu.id=ap.currency_id) AS currency, direct_debit, |
Auch abrufbar als: Unified diff
Lieferdatum in Einkaufsrechnung erfassen können
Das DB-Feld gab es schon, wurde aber nicht befüllt.