Revision e6fed669
Von Jan Büren vor 23 Tagen hinzugefügt
- ID e6fed669fb1585b9d541d9e109279df463c1b819
- Vorgänger d0816eaf
SL/DATEV.pm | ||
---|---|---|
$self->from($params{from});
|
||
$self->to($params{to});
|
||
|
||
my $filter_type;
|
||
$filter_type .= ' AND trans_id in (SELECT id from ar) ' if $params{transaction_type} eq 'ar';
|
||
$filter_type .= ' AND trans_id in (SELECT id from ap) ' if $params{transaction_type} eq 'ap';
|
||
|
||
my $fromto = $self->fromto;
|
||
# not all last month ar ap gl booking have an entry -> rent ?
|
||
my $query = qq|
|
||
... | ... | |
left join files on files.object_id=trans_id
|
||
where $fromto
|
||
and object_id is null
|
||
$filter_type
|
||
and trans_id not in (select id from gl)
|
||
LIMIT 1|;
|
||
|
Auch abrufbar als: Unified diff
DATEV: Fallunterschied Debit/Kredit für Dokumenten-Export bei DATEV