Revision 46f028ef
Von Bernd Bleßmann vor mehr als 4 Jahren hinzugefügt
| SL/DATEV.pm | ||
|---|---|---|
| 575 | 575 |
UNION ALL |
| 576 | 576 |
|
| 577 | 577 |
SELECT ac.acc_trans_id, ac.transdate, ac.gldate, ac.trans_id,gl.id, ac.amount, ac.taxkey, ac.memo, |
| 578 |
gl.reference AS invnumber, NULL AS duedate, ac.amount as umsatz, NULL as deliverydate, gl.itime::date,
|
|
| 578 |
gl.reference AS invnumber, NULL AS duedate, ac.amount as umsatz, gl.deliverydate, gl.itime::date,
|
|
| 579 | 579 |
gl.description AS name, NULL as ustid, '' AS vcname, NULL AS customer_id, NULL AS vendor_id, |
| 580 | 580 |
c.accno, c.description AS accname, c.taxkey_id as charttax, c.datevautomatik, c.id, ac.chart_link AS link, |
| 581 | 581 |
FALSE AS invoice, |
| ... | ... | |
| 1051 | 1051 |
if (($transaction->[$haben]->{'duedate'} // '') ne "") {
|
| 1052 | 1052 |
$datev_data{belegfeld2} = $transaction->[$haben]->{'duedate'};
|
| 1053 | 1053 |
} |
| 1054 |
if (($transaction->[$haben]->{'deliverydate'} // '') ne "") {
|
|
| 1055 |
$datev_data{leistungsdatum} = $transaction->[$haben]->{'deliverydate'};
|
|
| 1056 |
} |
|
| 1054 | 1057 |
} |
| 1055 | 1058 |
$datev_data{umsatz} = abs($umsatz); # sales invoices without tax have a different sign???
|
| 1056 | 1059 |
|
Auch abrufbar als: Unified diff
S:DATEV:CSV: Lieferdatum als Leistungsdatum exportieren