Revision cff1389b
Von Moritz Bunkus vor mehr als 9 Jahren hinzugefügt
SL/AR.pm | ||
---|---|---|
qq| c.id as customer_id, | .
|
||
qq| e.name AS employee, | .
|
||
qq| e2.name AS salesman, | .
|
||
qq| dc.dunning_description, | .
|
||
qq| tz.description AS taxzone, | .
|
||
qq| pt.description AS payment_terms, | .
|
||
qq{ ( SELECT ch.accno || ' -- ' || ch.description
|
||
... | ... | |
qq|LEFT JOIN contacts cp ON (a.cp_id = cp.cp_id) | .
|
||
qq|LEFT JOIN employee e ON (a.employee_id = e.id) | .
|
||
qq|LEFT JOIN employee e2 ON (a.salesman_id = e2.id) | .
|
||
qq|LEFT JOIN dunning_config dc ON (a.dunning_config_id = dc.id) | .
|
||
qq|LEFT JOIN project pr ON (a.globalproject_id = pr.id)| .
|
||
qq|LEFT JOIN tax_zones tz ON (tz.id = a.taxzone_id)| .
|
||
qq|LEFT JOIN payment_terms pt ON (pt.id = a.payment_id)| .
|
bin/mozilla/ar.pl | ||
---|---|---|
@columns =
|
||
qw(transdate id type invnumber ordnumber cusordnumber name netamount tax amount paid
|
||
datepaid due duedate transaction_description notes salesman employee shippingpoint shipvia
|
||
marge_total marge_percent globalprojectnumber customernumber country ustid taxzone payment_terms charts customertype direct_debit);
|
||
marge_total marge_percent globalprojectnumber customernumber country ustid taxzone payment_terms charts customertype direct_debit dunning_description);
|
||
|
||
my $ct_cvar_configs = CVar->get_configs('module' => 'CT');
|
||
my @ct_includeable_custom_variables = grep { $_->{includeable} } @{ $ct_cvar_configs };
|
||
... | ... | |
'charts' => { 'text' => $locale->text('Buchungskonto'), },
|
||
'customertype' => { 'text' => $locale->text('Customer type'), },
|
||
'direct_debit' => { 'text' => $locale->text('direct debit'), },
|
||
dunning_description => { 'text' => $locale->text('Dunning level'), },
|
||
%column_defs_cvars,
|
||
);
|
||
|
locale/de/all | ||
---|---|---|
'Dunning Level missing in row ' => 'Mahnlevel fehlt in ',
|
||
'Dunning Process Config saved!' => 'Mahnwesenkonfiguration gespeichert!',
|
||
'Dunning Process started for selected invoices!' => 'Mahnprozess für selektierte Rechnungen gestartet',
|
||
'Dunning level' => 'Mahnstufe',
|
||
'Dunning number' => 'Mahnungsnummer',
|
||
'Dunning overview' => 'Mahnungsübersicht',
|
||
'Dunning status' => 'Mahnstatus',
|
templates/webpages/ar/search.html | ||
---|---|---|
<td nowrap>[% 'Document Project Number' | $T8 %]</td>
|
||
<td align=right><input name="l_transaction_description" id="l_transaction_description" class=checkbox type=checkbox value=Y[% IF INSTANCE_CONF.get_require_transaction_description_ps %] checked[% END %]></td>
|
||
<td nowrap>[% 'Transaction description' | $T8 %]</td>
|
||
<td align=right><input name="l_dunning_description" id="l_dunning_description" class=checkbox type=checkbox value=Y></td>
|
||
<td nowrap>[% 'Dunning level' | $T8 %]</td>
|
||
</tr>
|
||
<tr>
|
||
<td align=right><input name="l_taxzone" id="l_taxzone" class=checkbox type=checkbox value=Y></td>
|
Auch abrufbar als: Unified diff
Rechnungssuche: optionale Spalte Mahnstufe implementiert