Revision d333cdb7
Von Jan Büren vor mehr als 3 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 463 | 463 |
WHERE ch.link ~ 'AP[[:>:]]' |
| 464 | 464 |
AND at.trans_id = a.id |
| 465 | 465 |
LIMIT 1 |
| 466 |
) AS charts } . |
|
| 466 |
) AS charts, } . |
|
| 467 |
qq{ ( SELECT ch.accno || ' -- ' || ch.description
|
|
| 468 |
FROM acc_trans at |
|
| 469 |
LEFT JOIN chart ch ON ch.id = at.chart_id |
|
| 470 |
WHERE ch.link ~ 'AP_amount' |
|
| 471 |
AND at.trans_id = a.id |
|
| 472 |
LIMIT 1 |
|
| 473 |
) AS debit_chart } . |
|
| 467 | 474 |
qq|FROM ap a | . |
| 468 | 475 |
qq|JOIN vendor v ON (a.vendor_id = v.id) | . |
| 469 | 476 |
qq|LEFT JOIN contacts cp ON (a.cp_id = cp.cp_id) | . |
| bin/mozilla/ap.pl | ||
|---|---|---|
| 1023 | 1023 |
my @columns = |
| 1024 | 1024 |
qw(transdate id type invnumber ordnumber name netamount tax amount paid datepaid |
| 1025 | 1025 |
due duedate transaction_description notes employee globalprojectnumber department |
| 1026 |
vendornumber country ustid taxzone payment_terms charts direct_debit); |
|
| 1026 |
vendornumber country ustid taxzone payment_terms charts debit_chart direct_debit);
|
|
| 1027 | 1027 |
|
| 1028 | 1028 |
my @hidden_variables = map { "l_${_}" } @columns;
|
| 1029 | 1029 |
push @hidden_variables, "l_subtotal", qw(open closed vendor invnumber ordnumber transaction_description notes project_id transdatefrom transdateto |
| ... | ... | |
| 1056 | 1056 |
'taxzone' => { 'text' => $locale->text('Tax rate'), },
|
| 1057 | 1057 |
'payment_terms' => { 'text' => $locale->text('Payment Terms'), },
|
| 1058 | 1058 |
'charts' => { 'text' => $locale->text('Chart'), },
|
| 1059 |
'debit_chart' => { 'text' => $locale->text('Debit Account'), },
|
|
| 1059 | 1060 |
'direct_debit' => { 'text' => $locale->text('direct debit'), },
|
| 1060 | 1061 |
); |
| 1061 | 1062 |
|
| doc/changelog | ||
|---|---|---|
| 28 | 28 |
in den Dokumenten-Tab gesprungen werden kann. |
| 29 | 29 |
- Seriennummer ist jetzt ein Pflichtfeld für Lieferscheine (Einkauf und Verkauf), |
| 30 | 30 |
falls die Ware im Beleg in den Stammdaten mit "Hat eine Serienummer" markiert ist. |
| 31 |
- Einkaufsbericht um Anzeige erstes Sollkonto erweitert |
|
| 31 | 32 |
|
| 32 | 33 |
Bugfixes (Tracker: https://www.kivitendo.de/redmine): |
| 33 | 34 |
|
Auch abrufbar als: Unified diff
Einkaufsbericht um Anzeige erstes Sollkonto erweitert