Revision c7cff765
Von Jan Büren vor fast 4 Jahren hinzugefügt
| SL/DATEV.pm | ||
|---|---|---|
| 461 | 461 |
} |
| 462 | 462 |
return $self->{locked};
|
| 463 | 463 |
} |
| 464 |
sub imported {
|
|
| 465 |
my $self = shift; |
|
| 466 |
|
|
| 467 |
if (@_) {
|
|
| 468 |
$self->{imported} = $_[0];
|
|
| 469 |
} |
|
| 470 |
return $self->{imported};
|
|
| 471 |
} |
|
| 464 | 472 |
|
| 465 | 473 |
sub generate_datev_data {
|
| 466 | 474 |
$main::lxdebug->enter_sub(); |
| ... | ... | |
| 514 | 522 |
$ar_accno = "CASE WHEN ac.chart_link = 'AR' THEN ct.customernumber ELSE c.accno END as accno"; |
| 515 | 523 |
$ap_accno = "CASE WHEN ac.chart_link = 'AP' THEN ct.vendornumber ELSE c.accno END as accno"; |
| 516 | 524 |
} |
| 525 |
my $gl_imported; |
|
| 526 |
if ( !$self->imported ) {
|
|
| 527 |
$gl_imported = " AND NOT imported"; |
|
| 528 |
} |
|
| 517 | 529 |
|
| 518 | 530 |
my $query = |
| 519 | 531 |
qq|SELECT ac.acc_trans_id, ac.transdate, ac.gldate, ac.trans_id,ar.id, ac.amount, ac.taxkey, ac.memo, |
| ... | ... | |
| 597 | 609 |
$trans_id_filter |
| 598 | 610 |
$gl_itime_filter |
| 599 | 611 |
$gl_department_id_filter |
| 612 |
$gl_imported |
|
| 600 | 613 |
$filter |
| 601 | 614 |
|
| 602 | 615 |
ORDER BY trans_id, acc_trans_id|; |
Auch abrufbar als: Unified diff
Dialogbuchungen um Boolean imported erweitert.
Buchungen mit diesem Boolean können beim DATEV-Export
gefiltert werden. Anwendungsfall sind bspw. in DATEV
erstellte Lohnbuchungen, die dann in kivi importiert werden