Revision 606b2190
Von Jan Büren vor mehr als 3 Jahren hinzugefügt
| SL/RP.pm | ||
|---|---|---|
| 1298 | 1298 |
phone as customerphone, fax as customerfax, ${ct}number,
|
| 1299 | 1299 |
"invnumber", "transdate", |
| 1300 | 1300 |
(amount - COALESCE((SELECT sum(amount)*$ml FROM acc_trans WHERE chart_link ilike '%paid%' AND acc_trans.trans_id=${arap}.id AND acc_trans.transdate <= (date $todate)),0)) as "open", "amount",
|
| 1301 |
"duedate", invoice, ${arap}.id, date_part('days', now() - duedate) as overduedays,
|
|
| 1301 |
"duedate", invoice, ${arap}.id, date_part('days', now() - duedate) as overduedays, datepaid,
|
|
| 1302 | 1302 |
(SELECT $buysell |
| 1303 | 1303 |
FROM exchangerate |
| 1304 | 1304 |
WHERE (${arap}.currency_id = exchangerate.currency_id)
|
| bin/mozilla/rp.pl | ||
|---|---|---|
| 1006 | 1006 |
|
| 1007 | 1007 |
my $report = SL::ReportGenerator->new(\%myconfig, $form); |
| 1008 | 1008 |
|
| 1009 |
my @columns = qw(statement ct invnumber transdate duedate amount open); |
|
| 1010 |
|
|
| 1009 |
my @columns = qw(statement ct invnumber transdate duedate amount open datepaid); |
|
| 1011 | 1010 |
my %column_defs = ( |
| 1012 | 1011 |
'statement' => { raw_header_data => SL::Presenter::Tag::checkbox_tag("checkall", checkall => '[name^=statement_]'), 'visible' => $form->{ct} eq 'customer' ? 'HTML' : 0, align => "center" },
|
| 1013 | 1012 |
'ct' => { 'text' => $form->{ct} eq 'customer' ? $locale->text('Customer') : $locale->text('Vendor'), },
|
| ... | ... | |
| 1016 | 1015 |
'duedate' => { 'text' => $locale->text('Due'), },
|
| 1017 | 1016 |
'amount' => { 'text' => $locale->text('Amount'), },
|
| 1018 | 1017 |
'open' => { 'text' => $locale->text('Open'), },
|
| 1018 |
'datepaid' => { 'text' => $locale->text('Date Paid'), visible => ($form->{reporttype} eq 'custom') },
|
|
| 1019 | 1019 |
); |
| 1020 | 1020 |
|
| 1021 | 1021 |
my %column_alignment = ('statement' => 'center',
|
Auch abrufbar als: Unified diff
#485 Forderungsliste um Zahlungsdatum erweitert
Für nachträgliche Auswertungen der OPOS-Liste (Werthaltigkeit
im nachfolgendem Buchungsjahr)