projekt kivitendo

    SELECT ${ct}.id AS ctid, ${ct}.name,

      street, zipcode, city, country, contact, email,

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

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

      "duedate", invoice, ${arap}.id, date_part('days', now() - duedate) as overduedays, datepaid, (amount - paid) as current_open,

      (SELECT $buysell

# $locale->text('Payments')

# $locale->text('Project Transactions')

# $locale->text('Business evaluation')

# $form->parse_html_template('rp/html_report_susa')

  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'), },

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

    'datepaid'  => { 'text' => $locale->text('Date of Last Payment'), visible => ($form->{reporttype} eq 'custom') },

    'current_open' => { 'text' => $locale->text('Open Amount at Last Payment Date'), visible => ($form->{reporttype} eq 'custom') },

  );

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

    }

    $row->{invnumber}->{link} =  build_std_url("script=$ref->{module}.pl", 'action=edit', 'callback', 'id=' . E($ref->{id}));

    if ($previous_ctid != $ref->{ctid}) {

      $row->{statement}->{raw_data} =

  'Filter record template'      => 'Filter für Buchungsvorlagen',

  'Final Invoice'               => 'Schlussrechnung',

  'Final Invoice (one letter abbreviation)' => 'F',

  'Financial Controlling'       => 'Finanzcontrolling',

  'Financial Controlling Report' => 'Finanzcontrollingbericht',

  'Financial Overview'          => 'Finanzübersicht',