projekt kivitendo

   { name => 'local_bank_account_id', description => $::locale->text('ID of own bank account') },

   { name => 'remote_bank_code',      description => $::locale->text('Bank code of the goal/source') },

   { name => 'remote_account_number', description => $::locale->text('Account number of the goal/source') },

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

   { name => 'currency',              description => $::locale->text('Currency') },

   { name => 'currency_id',           description => $::locale->text('Currency (database ID)')          },

      },

      customer     => t8('Customer'),

      employee     => t8('Employee'),

      donumber     => t8('Delivery Order Number'),

      ordnumber     => t8('Order Number'),

    },

  my @filters = (

    [ $filter->{customer}{"name:substr::ilike"}, t8('Customer') ],

  );

  for (@filters) {

        by  => 'transdate',

        dir => 0,

      },

    },

    paginated  => {

      per_page => 10,

    taxkey            => { 'text' => $::locale->text('Taxkey'), },

    tax_accname       => { 'text' => $::locale->text('Tax Account Name'), },

    tax_accno         => { 'text' => $::locale->text('Tax Account'), },

    vcnumber          => { 'text' => $::locale->text('Customer/Vendor Number'), },

  );

  taxkey            => { type => 'Rose::DB::Object::Metadata::Column::Integer', text => t8('Taxkey'), },

  tax_accname       => { type => 'Rose::DB::Object::Metadata::Column::Text',    text => t8('Tax Account Name'), },

  tax_accno         => { type => 'Rose::DB::Object::Metadata::Column::Text',    text => t8('Tax Account'), },

  vcnumber          => { type => 'Rose::DB::Object::Metadata::Column::Text',    text => t8('Customer/Vendor Number'), },

  customer_id       => { type => 'Rose::DB::Object::Metadata::Column::Integer', text => t8('Customer (database ID)'), },

  vendor_id         => { type => 'Rose::DB::Object::Metadata::Column::Integer', text => t8('Vendor (database ID)'), },

  itime             => { type => 'Rose::DB::Object::Metadata::Column::Date',    text => t8('Create Date'), },

);

my @datev_columns = qw(

    title   => $::locale->text('GL Transactions'),

    type    => 'gl_transaction',

    columns => [

      [ $::locale->text('Reference'),   'reference'                                                    ],

      [ $::locale->text('Description'), sub { $self->gl_transaction($_[0 ], display => 'table-cell') } ],

    ],

    'ustid'                   => { 'text' => $locale->text('USt-IdNr.'), },

    'taxzone'                 => { 'text' => $locale->text('Tax rate'), },

    'payment_terms'           => { 'text' => $locale->text('Payment Terms'), },

    'direct_debit'            => { 'text' => $locale->text('direct debit'), },

  );

    'ustid'                   => { 'text' => $locale->text('USt-IdNr.'), },

    'taxzone'                 => { 'text' => $locale->text('Steuersatz'), },

    'payment_terms'           => { 'text' => $locale->text('Payment Terms'), },

    'customertype'            => { 'text' => $locale->text('Customer type'), },

    'direct_debit'            => { 'text' => $locale->text('direct debit'), },

    'department'              => { 'text' => $locale->text('Department'), },

  my $ml = ($form->{ml} =~ /(A|E|Q)/) ? -1 : 1;

  my @columns = qw(

    notes          source   doccnt  debit          debit_accno

    credit         credit_accno     debit_tax      debit_tax_accno

    credit_tax     credit_tax_accno projectnumbers balance employee

  push @options,      $locale->text('Description') . " : $form->{description}"                        if ($form->{description});

  push @options,      $locale->text('Notes')       . " : $form->{notes}"                              if ($form->{notes});

  push @options,      $locale->text('Employee')    . " : $employee"                                   if $employee;

  push @date_options,      "$datesorttext"                              if ($form->{datesort} and ($form->{datefrom} or $form->{dateto}));

  push @date_options, $locale->text('From'), $locale->date(\%myconfig, $form->{datefrom}, 1)          if ($form->{datefrom});

  push @date_options, $locale->text('Bis'),  $locale->date(\%myconfig, $form->{dateto},   1)          if ($form->{dateto});

  my %column_defs = (

    'id'               => { 'text' => $locale->text('ID'), },

    'reference'        => { 'text' => $locale->text('Reference'), },

    'source'           => { 'text' => $locale->text('Source'), },

    'doccnt'           => { 'text' => $locale->text('Document Count'), },

    'serialnumber'       => { 'text' => $locale->text('Serial Number'), },

    'soldtotal'          => { 'text' => $locale->text('Qty in Selected Records'), },

    'name'               => { 'text' => $locale->text('Name in Selected Records'), },

    'unit'               => { 'text' => $locale->text('Unit'), },

    'weight'             => { 'text' => $locale->text('Weight'), },

    'shop'               => { 'text' => $locale->text('Shop article'), },

  'Bcc E-mail'                  => 'BCC (E-Mail)',

  'Because the useability gets worse if one partnumber is used for several parts (for example if you are searching a position for an invoice), partnumbers should be unique.' => 'Da die Benutzerfreundlichkeit durch doppelte Artikelnummern erheblich verschlechtert wird (zum Beispiel, wenn man einen Artikel für eine Rechnung sucht), sollten Artikelnummern eindeutig vergeben sein.',

  'Before saving a sales order, this article will be checked and a warning is generated.' => 'Vor dem Speichern eines Angebots oder Auftrags wird überprüft, ob die hier definierte Artikelnummer vorhanden ist (Versandkosten01, etc.) und eine entsprechende Hinweiswarnung angezeigt',

  'Belgium'                     => 'Belgien',

  'Beratername'                 => 'Beratername',

  'Beraternummer'               => 'Beraternummer',

  'Bis Konto: '                 => 'bis Konto: ',

  'Body'                        => 'Text',

  'Body:'                       => 'Text:',

  'Booking group'               => 'Buchungsgruppe',

  'Booking group #1 needs a valid expense account' => 'Buchungsgruppe #1 braucht ein gültiges Aufwandskonto',

  'Booking group #1 needs a valid income account' => 'Buchungsgruppe #1 braucht ein gültiges Erfolgskonto',

  'Bought'                      => 'Gekauft',

  'Break down by'               => 'Aufschlüsseln nach',

  'Break up the update and contact a service provider.' => 'Diese Option bricht das Update ab. Bitte kontaktieren Sie Ihren Administrator oder beauftragen einen Dienstleister.',

  'Business'                    => 'Kunden-/Lieferantentyp',

  'Business Discount'           => 'Kunden-/Lieferantentyp-Rabatt',

  'Business Number'             => 'Firmennummer',

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

  'Datevautomatik'              => 'Datev-Automatik',

  'Germany'                     => 'Deutschland',

  'Git revision: #1, #2 #3'     => 'Git-Revision: #1, #2 #3',

  'Given Name'                  => 'Vorname',

  'Global Attachments'          => 'Allgemeine Dokumentenanhänge',

  'Global Record BCC'           => 'Globale BCC-Adresse',

  'GoBD Export'                 => 'GoBD Export',

  'Transactions without account:' => 'Buchungen ohne Konto:',

  'Transactions without reference:' => 'Buchungen ohne Referenz:',

  'Transactions, AR transactions, AP transactions' => 'Dialogbuchen, Debitorenrechnungen, Kreditorenrechnungen',

  'Transdate from'              => 'Kontoauszugsdatum von',

  'Transdate is #1'             => 'Belegdatum ist #1',

  'Transdate is after #1'       => 'Belegdatum ist nach #1',

  'Transdate is before #1'      => 'Belegdatum ist vor #1',

  'Transfer'                    => 'Umlagern',

  'Transfer Quantity'           => 'Umlagermenge',

  'Transfer To Stock'           => 'Lagereingang',

  'Valid until'                 => 'gültig bis',

  'Valid/Obsolete'              => 'Gültig/ungültig',

  'Value'                       => 'Wert',

  'Valutadate from'             => 'Valutadatum von',

  'Valutadate to'               => 'Valutadatum bis',

  'Variable'                    => 'Variable',

  'Bcc E-mail'                  => '',

  'Because the useability gets worse if one partnumber is used for several parts (for example if you are searching a position for an invoice), partnumbers should be unique.' => '',

  'Before saving a sales order, this article will be checked and a warning is generated.' => '',

  'Belgium'                     => '',

  'Beratername'                 => '',

  'Beraternummer'               => '',

  'Bis Konto: '                 => '',

  'Body'                        => '',

  'Body:'                       => '',

  'Booking group'               => '',

  'Booking group #1 needs a valid expense account' => '',

  'Booking group #1 needs a valid income account' => '',

  'Bought'                      => '',

  'Break down by'               => '',

  'Break up the update and contact a service provider.' => '',

  'Business'                    => '',

  'Business Discount'           => '',

  'Business Number'             => '',

  'Date Paid'                   => '',

  '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.' => '',

  'Date missing!'               => '',

  'Date the payment is due in full' => '',

  'Date the payment is due with discount' => '',

  'Datevautomatik'              => '',

  'Germany'                     => '',

  'Git revision: #1, #2 #3'     => '',

  'Given Name'                  => '',

  'Global Attachments'          => '',

  'Global Record BCC'           => '',

  'GoBD Export'                 => '',

  'Transactions without account:' => '',

  'Transactions without reference:' => '',

  'Transactions, AR transactions, AP transactions' => '',

  'Transdate from'              => '',

  'Transdate to'                => '',

  'Transfer'                    => '',

  'Transfer Quantity'           => '',

  'Valid until'                 => '',

  'Valid/Obsolete'              => '',

  'Value'                       => '',

  'Valutadate from'             => '',

  'Valutadate to'               => '',

  'Variable'                    => '',

           <td align=right><input name="l_payment_terms" class=checkbox type=checkbox value=Y></td>

           <td nowrap>[% 'Payment Terms' | $T8 %]</td>

           <td align=right><input name="l_charts" class=checkbox type=checkbox value=Y></td>

           <td align=right><input name="l_direct_debit" id="l_direct_debit" class=checkbox type=checkbox value=Y></td>

           <td nowrap>[% 'direct debit' | $T8 %]</td>

          </tr>

           <td align=right><input name="l_payment_terms" id="l_payment_terms" class=checkbox type=checkbox value=Y></td>

           <td nowrap>[% 'Payment Terms' | $T8 %]</td>

           <td align=right><input name="l_charts" id="l_charts" class=checkbox type=checkbox value=Y></td>

           <td align=right><input name="l_direct_debit" id="l_direct_debit" class=checkbox type=checkbox value=Y></td>

           <td nowrap>[% 'direct debit' | $T8 %]</td>

          </tr>

    <th>[%- LxERP.t8("Amount") %]</th>

    <th>[%- LxERP.t8("Open amount") %]</th>

    <th>[%- LxERP.t8("Amount less skonto") %]</th>

    <th>[%- LxERP.t8("Customer/Vendor number") %]</th>

    <th>[%- LxERP.t8("Customer/Vendor name") %]</th>

   </tr>

  <table>

    <tr>

      <th class="listheading">[% 'Database ID' | $T8 %]</th>

      <th class="listheading">[% 'Amount' | $T8 %]</th>

      <th class="listheading">[% 'Source' | $T8 %]</th>

      <th class="listheading">[% 'Reference / Invoice Number' | $T8 %]</th>

      <th class="listheading">[% 'Description' | $T8 %]</th>

  <table>

    <tr>

      <th class="listheading">[% 'Database ID' | $T8 %]</th>

      <th class="listheading">[% 'Amount' | $T8 %]</th>

      <th class="listheading">[% 'Source' | $T8 %]</th>

      <th class="listheading">[% 'Account Number' | $T8 %]</th>

          <td align=left>

            <table>

              <tr>

                <td>[% L.date_tag('transdate', transdate, readonly=readonly) %]</td>

              </tr>

            </table>

        </tr>

[%- IF id %]

        <tr>

          <td>[% L.input_tag('id', id,  size=20, readonly=readonly) %]</td>

          <td align=left>

          <table>

              <tr>

                <td align=left>[% L.date_tag('gldate', gldate, readonly=1) %]</td>

              </tr>

            </table>

  <tr>

    <th align=right>[% 'Filter date by' | $T8 %]</th>

    <td colspan=3>

  </td>

  </tr>

  <tr>

                    <td align=right><input name="l_id" class=checkbox type=checkbox value=Y></td>

                    <td>[% 'ID' | $T8 %]</td>

                    <td align=right><input name="l_transdate" class=checkbox type=checkbox value=Y checked></td>

                    <td align=right><input name="l_gldate" class=checkbox type=checkbox value=Y checked></td>

                    <td align=right><input name="l_reference" class=checkbox type=checkbox value=Y checked></td>

                    <td>[% 'Reference' | $T8 %]</td>

                    <td align=right><input name="l_description" class=checkbox type=checkbox value=Y checked></td>

         </tr>

         <tr>

          <td>[%- L.checkbox_tag('l_ean', label=LxERP.t8('EAN'), value='Y') %]</td>

         </tr>

         <tr>

         </tr>

         <tr>

          <td>[%- L.checkbox_tag('l_name', label=LxERP.t8('Name in Selected Records'), value='Y') %]</td>

         </tr>

         [% CUSTOM_VARIABLES_INCLUSION_CODE %]

     <th align="right">[% LxERP.t8('Customer') %]</th>

     <td>[% L.input_tag('filter.customer.name:substr::ilike', filter.customer.name_substr__ilike, size = 20) %]</td>

    </tr>

     <td>[% L.date_tag('filter.transdate:date::ge', filter.transdate_date__ge) %]</td>

    </tr>

    <tr>

     <td>[% L.date_tag('filter.transdate:date::le', filter.transdate_date__le) %]</td>

    </tr>

  </table>

  <th>[%- LxERP.t8("Part")           %]</th>

  <th>[%- LxERP.t8("Customer")       %]</th>

  <th>[%- LxERP.t8("Order")          %]</th>

  <th>[%- LxERP.t8("Qty")            %]</th>

  <th>[%- LxERP.t8("Delivered")      %]</th>

  <th>[%- LxERP.t8("Price")          %]</th>

   <td>[% L.date_tag('filter.item_type_matches[].reqdate', FORM.filter.item_type_matches.0.reqdate, style='width: 300px') %]</td>

  </tr>

  <tr>

   <td>[% L.date_tag('filter.item_type_matches[].transdate', FORM.filter.item_type_matches.0.transdate, style='width: 300px') %]</td>

  </tr>

  <tr>

  [% CASE 'reqdate' %]

    [% 'Reqdate' | $T8 %] [% L.select_tag('price_rule.items[].op', date_compare_ops, default=item.op) %] [% L.date_tag('price_rule.items[].value_date', item.value_date) %]

  [% CASE 'transdate' %]

  [% CASE 'pricegroup' %]

    [% 'Pricegroup' | $T8 %] [% 'is' | $T8 %] [% L.select_tag('price_rule.items[].value_int', SELF.pricegroups, title_key='pricegroup', default=item.value_int) %]

  [% CASE %]