projekt kivitendo

      phone as customerphone, fax as customerfax, ${ct}number,

      "invnumber", "transdate",

      (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",

      (SELECT $buysell

       FROM exchangerate

       WHERE (${arap}.currency_id = exchangerate.currency_id)

  my $report = SL::ReportGenerator->new(\%myconfig, $form);

  my %column_defs = (

    'statement' => { raw_header_data => SL::Presenter::Tag::checkbox_tag("checkall", checkall => '[name^=statement_]'), 'visible' => $form->{ct} eq 'customer' ? 'HTML' : 0, align => "center" },

    'ct'        => { 'text' => $form->{ct} eq 'customer' ? $locale->text('Customer') : $locale->text('Vendor'), },

    'duedate'   => { 'text' => $locale->text('Due'), },

    'amount'    => { 'text' => $locale->text('Amount'), },

    'open'      => { 'text' => $locale->text('Open'), },

  );

  my %column_alignment = ('statement' => 'center',

  $report->set_options('std_column_visibility' => 1);

  $report->set_columns(%column_defs);

    $form->{title} = sprintf($locale->text('Ap aging on %s'), $form->{todate});

  }

  } else {

  }

  $attachment_basename = $form->{ct} eq 'customer' ? $locale->text('ar_aging_list') : $locale->text('ap_aging_list');

  my $previous_ctid = 0;

  my $row_idx       = 0;

  my %subtotals     = map { $_ => 0 } @periods;

  my %totals        = map { $_ => 0 } @periods;

  'Date Paid'                   => 'Zahlungsdatum',

  'Date and timestamp variables: If the default value equals \'NOW\' then the current date/current timestamp will be used. Otherwise the default value is copied as-is.' => 'Datums- und Uhrzeitvariablen: Wenn der Standardwert \'NOW\' ist, so wird das aktuelle Datum/die aktuelle Uhrzeit eingefügt. Andernfalls wird der Standardwert so wie er ist benutzt.',

  'Date missing!'               => 'Datum fehlt!',

  'Date the payment is due in full' => 'Das Datum, bis die Rechnung in voller Höhe bezahlt werden muss',

  'Date the payment is due with discount' => 'Das Datum, bis die Rechnung unter Abzug von Skonto bezahlt werden kann',

  'Datev export encoding'       => 'DATEV-Export Kodierung',

  'Oops. No valid action found to dispatch. Please report this case to the kivitendo team.' => 'Ups. Es wurde keine gültige Funktion zum Aufrufen gefunden. Bitte berichten Sie diesen Fall den kivitendo-Entwicklern.',

  'Open'                        => 'Offen',

  'Open Amount'                 => 'Offener Betrag',

  'Open Items'                  => 'Offene Posten',

  'Open Orders'                 => 'Offene Aufträge',

  'Open a further kivitendo window or tab' => 'Weiteres kivitendo-Fenster/-Tab öffnen',