projekt kivitendo

use Rose::Object::MakeMethods::Generic (

  'scalar --get_set_init' => [ qw(defaults all_warehouses all_weightunits all_languages all_currencies all_templates all_price_sources h_unit_name available_quick_search_modules

                                  all_project_statuses all_project_types zugferd_settings

                                  displayable_name_specs_by_module available_documents_with_no_positions) ],

);

  return SL::DB::Helper::AccountingPeriod::get_balance_startdate_method_options;

}

sub init_all_price_sources {

  my @classes = SL::PriceSource::ALL->all_price_sources;

use Data::Dumper;

use List::Util qw(sum);

use SL::ClientJS;

use SL::DB::Chart;

use SL::DB::GLTransaction;

use SL::DB::Helper::AccountingPeriod qw(get_balance_starting_date get_balance_startdate_method_options);

use Rose::Object::MakeMethods::Generic (

);

__PACKAGE__->run_before('check_auth');

  $self->cb_startdate($::locale->parse_date_to_object($self->get_balance_starting_date($self->cb_date)));

  $self->render('yearend/form',

                title                            => t8('Year-end closing'),

  $self->_parse_form;

  eval {

                        cb_date    => $self->cb_date,

                      );

    1;

    return $self->js->render;

  };

                                                cb_date    => $self->cb_date,

                                                start_date => $self->cb_startdate,

                                               );

  $self->_parse_form;

                                                cb_date   => $self->cb_date,

                                                start_date => $self->cb_startdate,

                                               );

}

sub _year_end_bookings {

  my $start_date = delete $params{start_date};

  my $cb_date    = delete $params{cb_date};

                                                start_date => $start_date,

                                                cb_date    => $cb_date,

                                               );

                              @{$report_data};

    $profit_loss_sum ||= 0;

    my $pl_chart;

      $pl_chart = $profit_chart;

    } else {

      $pl_chart = $loss_chart;

    my $pl_debit_balance  = 0;

    my $pl_credit_balance = 0;

    # soll = debit, haben = credit

      };

    ######### profit-loss transfer #########

    # and finally transfer the new balance of the profit-loss account via the carry-over account

    # we want to use profit_loss_sum with cb!

    if ( $profit_loss_sum != 0 ) {

      my $carry_over_ob_entry = SL::DB::GLTransaction->new(

        employee_id    => $employee_id,

        transdate      => $ob_date,

        $amount2 = 'debit';

      };

      $carry_over_ob_entry->add_chart_booking(

        chart    => $carry_over_chart,

        tax_id   => 0,

      # printf("debit : %s -> %s\n", $_->chart->displayable_name, $_->amount) foreach @{ $carry_over_ob_entry->transactions };

      # printf("credit: %s -> %s\n", $_->chart->displayable_name, $_->amount) foreach @{ $carry_over_ob_entry->transactions };

      $carry_over_ob_entry->post if scalar @{ $carry_over_ob_entry->transactions } > 1;

    };

}

sub _report {

  my $start_date = delete $params{start_date};

  my $cb_date    = delete $params{cb_date};

  die "no carry over account defined"

  my $salden_query = <<SQL;

select c.id as chart_id,

  my $report = selectall_hashref_query($::form, $dbh, $salden_query,

                                       $start_date,

                                       $cb_date,

                                      );

  # profit_loss_sum is the actual profit/loss for the year, without cb, use "amount_without_cb")

  my $profit_loss_sum = sum map { $_->{amount_without_cb} }

sub init_ob_date        { $::locale->parse_date_to_object($::form->{ob_date})      }

sub init_cb_startdate   { $::locale->parse_date_to_object($::form->{cb_startdate}) }

sub init_cb_date        { $::locale->parse_date_to_object($::form->{cb_date})      }

1;

  webdav_sync_extern_url                    => { type => 'text' },

  weightunit                                => { type => 'varchar', length => 5 },

  workflow_po_ap_chart_id                   => { type => 'integer' },

);

__PACKAGE__->meta->primary_key_columns([ 'id' ]);

    verschiedenen Lagerplätzen oder mit verschiedenen Chargen, so können diese

    gewählt ausgewählt werden. Das Mindeshaltbarkeitsdatum wird dabei (noch

    nicht) berücksichtigt.

Kleinere neue Features und Detailverbesserungen:

  'Please choose for which categories the taxes should be displayed (otherwise remove the ticks):' => 'Bitte wählen Sie für welche Kontoart die Steuer angezeigt werden soll (ansonsten einfach die Häkchen entfernen)',

  'Please choose the action to be processed for your target quantity:' => 'Bitte wählen Sie eine Aktion, die mit Ihrer gezählten Zielmenge durchgeführt werden soll:',

  'Please configure the carry over and profit and loss accounts for year-end closing in the client configuration!' => 'Bitte konfigurieren Sie in der Mandantenkonfiguration das Saldenvortragskonto, das Gewinnvortragskonto und das Verlustvortragskonto!',

  'Please contact your administrator or a service provider.' => 'Bitte kontaktieren Sie Ihren Administrator oder einen Dienstleister.',

  'Please contact your administrator.' => 'Bitte wenden Sie sich an Ihren Administrator.',

  'Please correct the settings and try again or deactivate that client.' => 'Bitte korrigieren Sie die Einstellungen und versuchen Sie es erneut, oder deaktivieren Sie diesen Mandanten.',

  'Profit and loss accounts'    => 'Erfolgskonten',

  'Profit carried forward account' => 'Gewinnvortragskonto',

  'Profit determination'        => 'Gewinnermittlung',

  'Proforma Invoice'            => 'Proformarechnung',

  'Program'                     => 'Programm',

  'Project'                     => 'Projekt',

  'This option controls the inventory system.' => 'Dieser Parameter legt die Warenbuchungsmethode fest.',

  'This option controls the method used for determining the startdate for the balance report.' => 'Diese Option bestimmt, wie das Startdatum für den Bilanzbericht ermittelt wird',

  'This option controls the method used for profit determination.' => 'Dieser Parameter legt die Berechnungsmethode für die Gewinnermittlung fest.',

  'This option controls the posting and calculation behavior for the accounting method.' => 'Dieser Parameter steuert die Buchungs- und Berechnungsmethoden für die Versteuerungsart.',

  'This order has already a final invoice.' => 'Dieser Auftrag hat schon eine Schlussrechnung.',

  'This part has already been added.' => 'Dieser Artikel wurde schon hinzugefügt',

  'Year'                        => 'Jahr',

  'Year-end bookings were successfully completed!' => 'Die Jahresabschlußbuchungen wurden erfolgreich durchgeführt!',

  'Year-end closing'            => 'Jahresabschluß',

  'Year-end date'               => 'Jahresabschlußdatum',

  'Year-end date missing'       => 'Jahresabschlußdatum fehlt',

  'Yearly'                      => 'jährlich',

  'Yearly taxreport not yet implemented' => 'Jährlicher Steuerreport für dieses Ausgabeformat noch nicht implementiert',

  'Yes'                         => 'Ja',

  'cp_greeting to cp_gender migration' => 'Datenumwandlung von Titel nach Geschlecht (cp_greeting to cp_gender)',

  'customer_list'               => 'kundenliste',

  'dated'                       => 'datiert',

  'default exchange rate'       => 'Tageskurs',

  'delete'                      => 'Löschen',

  'delete item'                 => 'Position löschen',

  'service_list'                => 'dienstleistungsliste',

  'shipped'                     => 'verschickt',

  'shipped_br'                  => 'Verschk.',

  'singular first char'         => 'S',

  'sort items'                  => 'Positionen sortieren',

  'start upload'                => 'Hochladen beginnt',

  'Please choose for which categories the taxes should be displayed (otherwise remove the ticks):' => '',

  'Please choose the action to be processed for your target quantity:' => '',

  'Please configure the carry over and profit and loss accounts for year-end closing in the client configuration!' => '',

  'Please contact your administrator or a service provider.' => '',

  'Please contact your administrator.' => '',

  'Please correct the settings and try again or deactivate that client.' => '',

  'Profit and loss accounts'    => '',

  'Profit carried forward account' => '',

  'Profit determination'        => '',

  'Proforma Invoice'            => '',

  'Program'                     => '',

  'Project'                     => '',

  'Purchase Credit Notes'       => '',

  'Purchase Delivery Order'     => '',

  'Purchase Delivery Orders'    => '',

  'Purchase Invoice'            => '',

  'Purchase Invoices'           => '',

  'Purchase Order'              => '',

  'Purchase Order Confirmations' => '',

  'Purchase Orders'             => '',

  'Purchase Orders Services are deliverable' => '',

  'Purchase Price Rules'        => '',

  'Purchase Price Rules '       => '',

  'Purchase Quotation Intake'   => '',

  'Purchase Quotation Intakes'  => '',

  'Purchase Reclamation'        => '',

  'Purchase Reclamations'       => '',

  'Purchase basket'             => '',

  'Purchase basket item not existing any more for position(s): #1.' => '',

  'Purchase delivery order'     => '',

  'Sales (typeabbreviation)'    => 'S',

  'Sales Delivery Order'        => '',

  'Sales Delivery Orders'       => '',

  'Sales Invoice'               => '',

  'Sales Invoices'              => '',

  'Sales Order'                 => '',

  'Sales Orders'                => '',

  'Sales Orders Advance'        => '',

  'Sales Orders Services are deliverable' => '',

  'Sales Price Rules'           => '',

  'Sales Price Rules '          => '',

  'Sales Price information'     => '',

  'Sales Quotations'            => '',

  'Sales Reclamation'           => '',

  'Sales Reclamations'          => '',

  'Sales Report'                => '',

  'Sales and purchase invoices with inventory transactions with taxkeys' => '',

  'Sales delivery order'        => '',

  'Show custom variable search inputs' => '',

  'Show delete button in purchase delivery orders?' => '',

  'Show delete button in purchase orders?' => '',

  'Show delete button in sales delivery orders?' => '',

  'Show delete button in sales orders?' => '',

  'Show delivery plan'          => '',

  'Show delivery value report'  => '',

  'Show detail informationen'   => '',

  'This option controls the inventory system.' => '',

  'This option controls the method used for determining the startdate for the balance report.' => '',

  'This option controls the method used for profit determination.' => '',

  'This option controls the posting and calculation behavior for the accounting method.' => '',

  'This order has already a final invoice.' => '',

  'This part has already been added.' => '',

  'Year'                        => '',

  'Year-end bookings were successfully completed!' => '',

  'Year-end closing'            => '',

  'Year-end date'               => '',

  'Year-end date missing'       => '',

  'Yearly'                      => '',

  'Yearly taxreport not yet implemented' => '',

  'Yes'                         => '',

  'cp_greeting to cp_gender migration' => '',

  'customer_list'               => '',

  'dated'                       => '',

  'default exchange rate'       => '',

  'delete'                      => '',

  'delete item'                 => '',

  'service_list'                => '',

  'shipped'                     => '',

  'shipped_br'                  => 'shipped',

  'singular first char'         => '',

  'sort items'                  => '',

  'start upload'                => '',

<table class="tbl-horizontal">

  <caption>[% LxERP.t8("Year-end closing") %]</caption>

  <tbody>

    <tr>

      <th>[% LxERP.t8("Carry over account for year-end closing") %]</th>

      <td>[% P.chart.picker('defaults.carry_over_account_chart_id', SELF.defaults.carry_over_account_chart_id, category='A', choose=1, style=style) %]</td>

      <th>[% LxERP.t8("Loss carried forward account") %]</th>

      <td>[% P.chart.picker('defaults.loss_carried_forward_chart_id', SELF.defaults.loss_carried_forward_chart_id, category='A', choose=1, style=style) %]</td>

    </tr>

    <tr>

   <th>[% LxERP.t8("Transit Items account") %]</th>

   <td>[% P.chart.picker('defaults.transit_items_chart_id', SELF.defaults.transit_items_chart_id , category='A', choose=1, style=style) %]<td>

      <td>[% L.select_tag('defaults.balance_startdate_method', SELF.balance_startdate_method_options, value_key = 'value', title_key = 'title', default = SELF.defaults.balance_startdate_method, class='wi-morewide') %]</td>

      <td class="longdesc">[% LxERP.t8('This option controls the method used for determining the startdate for the balance report.') %]</td>

    </tr>

    <tr>

      <th>[% LxERP.t8('Set valid until date for Sales Quotation') %]</th>

      <td>[% L.yes_no_tag('defaults.reqdate_on', SELF.defaults.reqdate_on) %]</td>

<div class="wrapper">

<form id="filter" name="filter" method="post" action="controller.pl">

<table class="tbl-horizontal">

  <tr>

    <td>[% 'Start date' | $T8 %]</td>

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

  </tr>

  <tr>

    <td>[% 'Carry over account for year-end closing' | $T8 %]</td>

    <td>[% carry_over_chart.displayable_name | html %]</td>

    <td>[% 'Loss carried forward account' | $T8 %]</td>

    <td>[% loss_chart.displayable_name | html %]</td>

  </tr>

</table>

</form>

[% ELSE %]

  [% 'Please configure the carry over and profit and loss accounts for year-end closing in the client configuration!' | $T8 %]

[% END %]

  <tr>

    <th align="right">[% LxERP.t8("Year-end closing") %]</th>

  </tr>

  <tr>

   <td align="right">[% LxERP.t8("Carry over account for year-end closing") %]</td>

   <td>[% P.chart.picker('defaults.carry_over_account_chart_id', SELF.defaults.carry_over_account_chart_id, category='A', choose=1, style=style) %]<td>

   <td align="right">[% LxERP.t8("Loss carried forward account") %]</td>

   <td>[% P.chart.picker('defaults.loss_carried_forward_chart_id', SELF.defaults.loss_carried_forward_chart_id, category='A', choose=1, style=style) %]<td>

  </tr>

  <tr>

   <td align="right">[% LxERP.t8("Transit Items account") %]</td>

   <td>[% P.chart.picker('defaults.transit_items_chart_id', SELF.defaults.transit_items_chart_id , category='A', choose=1, style=style) %]<td>

   <td>[% L.select_tag('defaults.balance_startdate_method', SELF.balance_startdate_method_options, value_key = 'value', title_key = 'title', default = SELF.defaults.balance_startdate_method) %]</td>

   <td>[% LxERP.t8('This option controls the method used for determining the startdate for the balance report.') %]</td>

  </tr>

  <tr>

   <td align="right">[% LxERP.t8('Set valid until date for Sales Quotation') %]</td>

   <td>[% L.yes_no_tag('defaults.reqdate_on', SELF.defaults.reqdate_on) %]</td>

[%- INCLUDE 'common/flash.html' %]

<form id="filter" name="filter" method="post" action="controller.pl">

<table>

  <tr>

    <td align="right">[% 'Start date' | $T8 %]</td>

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

  </tr>

  <tr>

    <td align="right">[% 'Carry over account for year-end closing' | $T8 %]</td>

    <td>[% carry_over_chart.displayable_name | html %]</td>

    <td align="right">[% 'Loss carried forward account' | $T8 %]</td>

    <td>[% loss_chart.displayable_name | html %]</td>

  </tr>

</table>

</form>

[% ELSE %]

  [% 'Please configure the carry over and profit and loss accounts for year-end closing in the client configuration!' | $T8 %]

[% END %]