X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FDATEV.pm;h=2aff208e6d9d2c5a45399cf82f9f1b9a9f128c2f;hb=cc1f1d856a432cd669fcec19dfb6938d8c638767;hp=c6ce5b2a099e80d7d5c64587ff240144f5d5ce41;hpb=4dc48e117cfdb6e59c2d8b9d8087ef8a3bc245a4;p=kivitendo-erp.git diff --git a/SL/DATEV.pm b/SL/DATEV.pm index c6ce5b2a0..2aff208e6 100644 --- a/SL/DATEV.pm +++ b/SL/DATEV.pm @@ -461,6 +461,14 @@ sub locked { } return $self->{locked}; } +sub imported { + my $self = shift; + + if (@_) { + $self->{imported} = $_[0]; + } + return $self->{imported}; +} sub generate_datev_data { $main::lxdebug->enter_sub(); @@ -514,6 +522,10 @@ sub generate_datev_data { $ar_accno = "CASE WHEN ac.chart_link = 'AR' THEN ct.customernumber ELSE c.accno END as accno"; $ap_accno = "CASE WHEN ac.chart_link = 'AP' THEN ct.vendornumber ELSE c.accno END as accno"; } + my $gl_imported; + if ( !$self->imported ) { + $gl_imported = " AND NOT imported"; + } my $query = qq|SELECT ac.acc_trans_id, ac.transdate, ac.gldate, ac.trans_id,ar.id, ac.amount, ac.taxkey, ac.memo, @@ -597,6 +609,7 @@ sub generate_datev_data { $trans_id_filter $gl_itime_filter $gl_department_id_filter + $gl_imported $filter ORDER BY trans_id, acc_trans_id|;