Revision d8e0c6d8
Von Bernd Blessmann vor etwa 13 Jahren hinzugefügt
| SL/AP.pm | ||
|---|---|---|
| 445 | 445 |
$where .= |
| 446 | 446 |
qq|AND ((a.globalproject_id = ?) OR EXISTS | . |
| 447 | 447 |
qq| (SELECT * FROM invoice i | . |
| 448 |
qq| WHERE i.project_id = ? AND i.trans_id = a.id))|; |
|
| 449 |
push(@values, $form->{project_id}, $form->{project_id});
|
|
| 448 |
qq| WHERE i.project_id = ? AND i.trans_id = a.id) | . |
|
| 449 |
qq| OR EXISTS | . |
|
| 450 |
qq| (SELECT * FROM acc_trans at | . |
|
| 451 |
qq| WHERE at.project_id = ? AND at.trans_id = a.id)| . |
|
| 452 |
qq| )|; |
|
| 453 |
push(@values, $form->{project_id}, $form->{project_id}, $form->{project_id});
|
|
| 450 | 454 |
} |
| 451 | 455 |
|
| 452 | 456 |
if ($form->{transdatefrom}) {
|
| SL/AR.pm | ||
|---|---|---|
| 472 | 472 |
$where .= |
| 473 | 473 |
qq|AND ((a.globalproject_id = ?) OR EXISTS | . |
| 474 | 474 |
qq| (SELECT * FROM invoice i | . |
| 475 |
qq| WHERE i.project_id = ? AND i.trans_id = a.id))|; |
|
| 476 |
push(@values, $form->{"project_id"}, $form->{"project_id"});
|
|
| 475 |
qq| WHERE i.project_id = ? AND i.trans_id = a.id) | . |
|
| 476 |
qq| OR EXISTS | . |
|
| 477 |
qq| (SELECT * FROM acc_trans at | . |
|
| 478 |
qq| WHERE at.project_id = ? AND at.trans_id = a.id)| . |
|
| 479 |
qq| )|; |
|
| 480 |
push(@values, $form->{project_id}, $form->{project_id}, $form->{project_id});
|
|
| 477 | 481 |
} |
| 478 | 482 |
|
| 479 | 483 |
if ($form->{transdatefrom}) {
|
| bin/mozilla/ap.pl | ||
|---|---|---|
| 1290 | 1290 |
'transaction_description' => { 'text' => $locale->text('Transaction description'), },
|
| 1291 | 1291 |
'notes' => { 'text' => $locale->text('Notes'), },
|
| 1292 | 1292 |
'employee' => { 'text' => $locale->text('Employee'), },
|
| 1293 |
'globalprojectnumber' => { 'text' => $locale->text('Project Number'), },
|
|
| 1293 |
'globalprojectnumber' => { 'text' => $locale->text('Document Project Number'), },
|
|
| 1294 | 1294 |
'vendornumber' => { 'text' => $locale->text('Vendor Number'), },
|
| 1295 | 1295 |
'country' => { 'text' => $locale->text('Country'), },
|
| 1296 | 1296 |
'ustid' => { 'text' => $locale->text('USt-IdNr.'), },
|
| bin/mozilla/ar.pl | ||
|---|---|---|
| 1364 | 1364 |
'employee' => { 'text' => $locale->text('Employee'), },
|
| 1365 | 1365 |
'shippingpoint' => { 'text' => $locale->text('Shipping Point'), },
|
| 1366 | 1366 |
'shipvia' => { 'text' => $locale->text('Ship via'), },
|
| 1367 |
'globalprojectnumber' => { 'text' => $locale->text('Project Number'), },
|
|
| 1367 |
'globalprojectnumber' => { 'text' => $locale->text('Document Project Number'), },
|
|
| 1368 | 1368 |
'marge_total' => { 'text' => $locale->text('Ertrag'), },
|
| 1369 | 1369 |
'marge_percent' => { 'text' => $locale->text('Ertrag prozentual'), },
|
| 1370 | 1370 |
'customernumber' => { 'text' => $locale->text('Customer Number'), },
|
| doc/changelog | ||
|---|---|---|
| 2 | 2 |
# Veränderungen von Lx-Office ERP # |
| 3 | 3 |
################################### |
| 4 | 4 |
|
| 5 |
- Bei den Berichten für Verkaus- und Einkaufsrechnungen wird auch auf die |
|
| 6 |
positionsbezogenen Projektnummern bei Debitoren- und Kreditorenbuchungen |
|
| 7 |
gefiltert. |
|
| 8 |
|
|
| 5 | 9 |
- Es kann eine Standardsprache eingestellt werden, die automatisch bei neu |
| 6 | 10 |
anzulegenden Kunden und Lieferanten vorausgewählt ist. |
| 7 | 11 |
|
| locale/de/all | ||
|---|---|---|
| 617 | 617 |
'Do you want to carry this shipping address over to the new purchase order so that the vendor can deliver the goods directly to your customer?' => 'Wollen Sie diese Lieferadresse in den neuen Lieferantenauftrag übernehmen, damit der Händler die Waren direkt an Ihren Kunden liefern kann?', |
| 618 | 618 |
'Do you want to store the existing onhand values into a new warehouse?' => 'Möchten Sie die vorhandenen Mengendaten in ein Lager übertragen?', |
| 619 | 619 |
'Document' => 'Dokument', |
| 620 |
'Document Project Number' => 'Projektnummer des Belegs', |
|
| 620 | 621 |
'Documents in the WebDAV repository' => 'Dokumente im WebDAV-Repository', |
| 621 | 622 |
'Done' => 'Fertig', |
| 622 | 623 |
'Download SEPA XML export file' => 'SEPA-XML-Exportdatei herunterladen', |
| locale/de_DE/all | ||
|---|---|---|
| 581 | 581 |
'Do you want to carry this shipping address over to the new purchase order so that the vendor can deliver the goods directly to your customer?' => 'Wollen Sie diese Lieferadresse in den neuen Lieferantenauftrag übernehmen, damit der Händler die Waren direkt an Ihren Kunden liefern kann?', |
| 582 | 582 |
'Do you want to store the existing onhand values into a new warehouse?' => 'Möchten Sie die vorhandenen Mengendaten in ein Lager übertragen?', |
| 583 | 583 |
'Document' => 'Dokument', |
| 584 |
'Document Project Number' => 'Projektnummer des Belegs', |
|
| 584 | 585 |
'Documents in the WebDAV repository' => 'Dokumente im WebDAV-Repository', |
| 585 | 586 |
'Done' => 'Fertig', |
| 586 | 587 |
'Download SEPA XML export file' => 'SEPA-XML-Exportdatei herunterladen', |
| locale/en/all | ||
|---|---|---|
| 584 | 584 |
'Do you want to carry this shipping address over to the new purchase order so that the vendor can deliver the goods directly to your customer?' => '', |
| 585 | 585 |
'Do you want to store the existing onhand values into a new warehouse?' => '', |
| 586 | 586 |
'Document' => '', |
| 587 |
'Document Project Number' => '', |
|
| 587 | 588 |
'Documents in the WebDAV repository' => '', |
| 588 | 589 |
'Done' => '', |
| 589 | 590 |
'Download SEPA XML export file' => '', |
| templates/webpages/ap/search.html | ||
|---|---|---|
| 138 | 138 |
<td align=right><input name="l_subtotal" class=checkbox type=checkbox value=Y></td> |
| 139 | 139 |
<td nowrap>[% 'Subtotal' | $T8 %]</td> |
| 140 | 140 |
<td align=right><input name="l_globalprojectnumber" class=checkbox type=checkbox value=Y></td> |
| 141 |
<td nowrap>[% 'Project Number' | $T8 %]</td> |
|
| 141 |
<td nowrap>[% 'Document Project Number' | $T8 %]</td>
|
|
| 142 | 142 |
</tr> |
| 143 | 143 |
<tr> |
| 144 | 144 |
<td colspan=4 align=left><b>[% 'Vendor' | $T8 %] </td> |
| templates/webpages/ar/search.html | ||
|---|---|---|
| 201 | 201 |
<td align=right><input name="l_subtotal" class=checkbox type=checkbox value=Y></td> |
| 202 | 202 |
<td nowrap>[% 'Subtotal' | $T8 %]</td> |
| 203 | 203 |
<td align=right><input name="l_globalprojectnumber" class=checkbox type=checkbox value=Y></td> |
| 204 |
<td nowrap>[% 'Project Number' | $T8 %]</td> |
|
| 204 |
<td nowrap>[% 'Document Project Number' | $T8 %]</td>
|
|
| 205 | 205 |
<td align=right><input name="l_transaction_description" class=checkbox type=checkbox value=Y></td> |
| 206 | 206 |
<td nowrap>[% 'Transaction description' | $T8 %]</td> |
| 207 | 207 |
</tr> |
Auch abrufbar als: Unified diff
Suchen auch nach positionsbezogenen Projektnummern bei Debitoren- und Kreditorenbuchungen.
Bei den Berichten für Verkaus- und Einkaufsrechnungen wird auch auf die
positionsbezogenen Projektnummern bei Debitoren- und Kreditorenbuchungen
gefiltert.