path: root/bin/cp.pl

#=====================================================================
# LedgerSMB Small Medium Business Accounting
# http://www.ledgersmb.org/
#

# Copyright (C) 2006
# This work contains copyrighted information from a number of sources all used
# with permission.
#
# This file contains source code included with or based on SQL-Ledger which
# is Copyright Dieter Simader and DWS Systems Inc. 2000-2005 and licensed
# under the GNU General Public License version 2 or, at your option, any later
# version.  For a full list including contact information of contributors,
# maintainers, and copyright holders, see the CONTRIBUTORS file.
#
# Original Copyright Notice from SQL-Ledger 2.6.17 (before the fork):
# Copyright (c) 2002
#
#  Author: DWS Systems Inc.
#     Web: http://www.sql-ledger.org
#
# Contributors:
#
#
#  Author: DWS Systems Inc.
#     Web: http://www.ledgersmb.org/
#
# Contributors:
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
#======================================================================
#
# Payment module
#
#======================================================================

use LedgerSMB::CP;
use LedgerSMB::OP;
use LedgerSMB::IS;
use LedgerSMB::IR;
use LedgerSMB::Template;

require "bin/arap.pl";

1;

# end of main

# This may need to get more sophisticated in the future
# Anyway, it provides one point of control for date handling.
sub default_date {
    $form->{date} ||= 'current_date';
}

sub payment {

    if ( $form->{type} eq 'receipt' ) {
        $form->{ARAP}     = "AR";
        $form->{arap}     = "ar";
        $form->{vc}       = "customer";
        $form->{formname} = "receipt";
    }
    if ( $form->{type} eq 'check' ) {
        $form->{ARAP}     = "AP";
        $form->{arap}     = "ap";
        $form->{vc}       = "vendor";
        $form->{formname} = "check";
    }

    $form->{payment} = "payment";

    $form->{callback} =
"$form->{script}?action=payment&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&all_vc=$form->{all_vc}&type=$form->{type}";

    # setup customer/vendor selection for open invoices
    if ( $form->{all_vc} ) {
        $form->all_vc( \%myconfig, $form->{vc}, $form->{ARAP}, undef,
            $form->{datepaid} );
    }
    else {
        CP->get_openvc( \%myconfig, \%$form );
        if ( $myconfig{vclimit} > 0 ) {
            $form->{"all_$form->{vc}"} = $form->{name_list};
        }
    }

    $form->{"select$form->{vc}"} = "";
    if ( @{ $form->{"all_$form->{vc}"} } ) {
        $form->{"$form->{vc}_id"} = $form->{"all_$form->{vc}"}->[0]->{id};
        for ( @{ $form->{"all_$form->{vc}"} } ) {
            $form->{"select$form->{vc}"} .=
              qq|<option value="$_->{name}--$_->{id}">$_->{name}\n|;
        }
    }

    # departments
    if ( @{ $form->{all_department} } ) {
        $form->{selectdepartment} = "<option>\n";
        $form->{department} = "$form->{department}--$form->{department_id}"
          if $form->{department};

        for ( @{ $form->{all_department} } ) {
            $form->{selectdepartment} .=
qq|<option value="$_->{description}--$_->{id}">$_->{description}\n|;
        }
    }

    if ( @{ $form->{all_language} } ) {
        $form->{selectlanguage} = "<option>\n";
        for ( @{ $form->{all_language} } ) {
            $form->{selectlanguage} .=
              qq|<option value="$_->{code}">$_->{description}\n|;
        }
    }

    CP->paymentaccounts( \%myconfig, \%$form );

    $form->{selectaccount} = "";
    $form->{"select$form->{ARAP}"} = "";

    for ( @{ $form->{PR}{"$form->{ARAP}_paid"} } ) {
        $form->{selectaccount} .= "<option>$_->{accno}--$_->{description}\n";
    }
    for ( @{ $form->{PR}{ $form->{ARAP} } } ) {
        $form->{"select$form->{ARAP}"} .=
          "<option>$_->{accno}--$_->{description}\n";
    }

    # currencies
    @curr = split /:/, $form->{currencies};
    $form->{defaultcurrency} = $curr[0];
    chomp $form->{defaultcurrency};

    $form->{selectcurrency} = "";
    for (@curr) { $form->{selectcurrency} .= "<option>$_\n" }

    $form->{currency}    = $form->{defaultcurrency};
    $form->{oldcurrency} = $form->{currency};

    if ( $form->{currency} ne $form->{defaultcurrency} ) {
        $form->{forex} = $form->{exchangerate} =
          $form->check_exchangerate( \%myconfig, $form->{currency},
            $form->{datepaid}, ( $form->{vc} eq 'customer' ) ? "buy" : "sell" );
    }

    $form->{olddatepaid} = $form->{datepaid};

    $form->{media} = $myconfig{printer};
    $form->{format} = "pdf" unless $myconfig{printer};

    &payment_header;
    &payment_footer;

}

sub payments {

    if ( $form->{type} eq 'receipt' ) {
        $form->{ARAP}     = "AR";
        $form->{arap}     = "ar";
        $form->{vc}       = "customer";
        $form->{formname} = "receipt";
    }
    if ( $form->{type} eq 'check' ) {
        $form->{ARAP}     = "AP";
        $form->{arap}     = "ap";
        $form->{vc}       = "vendor";
        $form->{formname} = "check";
    }

    $form->{payment} = "payments";

    $form->{callback} = "$form->{script}?action=$form->{action}";
    for (qw(path login sessionid type)) {
        $form->{callback} .= "&$_=$form->{$_}";
    }

    CP->paymentaccounts( \%myconfig, \%$form );

    if ( @{ $form->{all_language} } ) {
        $form->{selectlanguage} = "<option>\n";
        for ( @{ $form->{all_language} } ) {
            $form->{selectlanguage} .=
              qq|<option value="$_->{code}">$_->{description}\n|;
        }
    }

    # departments
    if ( @{ $form->{all_department} } ) {
        $form->{selectdepartment} = "<option>\n";
        $form->{department} = "$form->{department}--$form->{department_id}"
          if $form->{department};

        for ( @{ $form->{all_department} } ) {
            $form->{selectdepartment} .=
qq|<option value="$_->{description}--$_->{id}">$_->{description}\n|;
        }
    }

    $form->{selectaccount} = "";
    $form->{"select$form->{ARAP}"} = "";

    for ( @{ $form->{PR}{"$form->{ARAP}_paid"} } ) {
        $form->{selectaccount} .= "<option>$_->{accno}--$_->{description}\n";
    }
    for ( @{ $form->{PR}{ $form->{ARAP} } } ) {
        $form->{"select$form->{ARAP}"} .=
          "<option>$_->{accno}--$_->{description}\n";
    }

    # currencies
    @curr = split /:/, $form->{currencies};
    $form->{defaultcurrency} = $curr[0];
    chomp $form->{defaultcurrency};

    $form->{selectcurrency} = "";
    for (@curr) { $form->{selectcurrency} .= "<option>$_\n" }

    $form->{oldcurrency} = $form->{currency} = $form->{defaultcurrency};
    $form->{oldduedateto} = $form->{datepaid};

    $form->{media} = $myconfig{printer};
    $form->{format} = "pdf" unless $myconfig{printer};

    &payments_header;
    &invoices_due;
    &payments_footer;

}

sub payments_header {

    if ( $form->{type} eq 'receipt' ) {
        $form->{title} = $locale->text('Receipts');
    }
    if ( $form->{type} eq 'check' ) {
        $form->{title} = $locale->text('Payments');
    }

    for ("department") {
        $form->{"select$_"} = $form->unescape( $form->{"select$_"} );
        $form->{"select$_"} =~ s/ selected//;
        $form->{"select$_"} =~ s/(<option value="\Q$form->{$_}\E")/$1 selected/;
    }

    for ( "account", "currency", "$form->{ARAP}" ) {
        $form->{"select$_"} =~ s/ selected//;
        $form->{"select$_"} =~
          s/option>\Q$form->{$_}\E/option selected>$form->{$_}/;
    }

    if ( $form->{defaultcurrency} ) {
        $exchangerate = qq|
          <tr>
        <th align=right nowrap>| . $locale->text('Currency') . qq|</th>
        <td><select name=currency>$form->{selectcurrency}</select></td>
        <input type=hidden name=selectcurrency value="$form->{selectcurrency}">
        <input type=hidden name=oldcurrency value=$form->{oldcurrency}>
          </tr>
|;
    }

    if ( $form->{currency} ne $form->{defaultcurrency} ) {
        $form->{exchangerate} =
          $form->format_amount( \%myconfig, $form->{exchangerate} );

        if ( $form->{forex} ) {
            $exchangerate .= qq|
          <tr>
        <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th>
        <td colspan=3><input type=hidden name=exchangerate size=10 value=$form->{exchangerate}>$form->{exchangerate}</td>
          </tr>
|;
        }
        else {
            $exchangerate .= qq|
          <tr>
        <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th>
        <td colspan=3><input name=exchangerate size=10 value=$form->{exchangerate}></td>
          </tr>
|;
        }
    }

    $department = qq|
              <tr>
            <th align="right" nowrap>| . $locale->text('Department') . qq|</th>
        <td><select name=department>$form->{selectdepartment}</select>
        <input type=hidden name=selectdepartment value="|
      . $form->escape( $form->{selectdepartment}, 1 ) . qq|">
          </td>
        </tr>
| if $form->{selectdepartment};

    $form->header;

    print qq|
<body>

<form method=post action=$form->{script}>
|;

    $form->hide_form(
        qw(defaultcurrency closedto vc type formname arap ARAP title oldduedatefrom oldduedateto payment olddepartment)
    );

    print qq|
<table width=100%>
  <tr>
    <th class=listtop>$form->{title}</th>
  </tr>
  <tr height="5"></tr>
  <tr>
    <td>
      <table width=100%>
        <tr valign=top>
      <td>
        <table>
          <tr>
            <th align=right>|
      . $locale->text('Due Date')
      . qq|&nbsp;|
      . $locale->text('From')
      . qq|</th>
        <td><input class="date" name=duedatefrom value="$form->{duedatefrom}" title="$myconfig{dateformat}" size=11></td>
            <th align=right>| . $locale->text('To') . qq|</th>
        <td><input class="date" name=duedateto value="$form->{duedateto}" title="$myconfig{dateformat}" size=11></td>
          </tr>
        </table>
      </td>
      </td>
      <td align=right>
        <table>
          $department
          <tr>
            <th align=right nowrap>| . $locale->text( $form->{ARAP} ) . qq|</th>
        <td colspan=3><select name=$form->{ARAP}>$form->{"select$form->{ARAP}"}</select>
        </td>
        <input type=hidden name="select$form->{ARAP}" value="$form->{"select$form->{ARAP}"}">
          </tr>
          <tr>
        <th align=right nowrap>| . $locale->text('Account') . qq|</th>
        <td colspan=3><select name=account>$form->{selectaccount}</select>
        <input type=hidden name=selectaccount value="$form->{selectaccount}">
        </td>
          </tr>
          <tr>
        <th align=right nowrap>| . $locale->text('Date') . qq|</th>
        <td><input class="date" name=datepaid value="$form->{datepaid}" title="$myconfig{dateformat}" size=11></td>
          </tr>
          $exchangerate
        </table>
      </td>
    </tr>
      </table>
    </td>
  </tr>
|;

}

sub invoices_due {
    @column_index =
      qw(name invnumber transdate amount due checked paid memo source);
    push @column_index, "language" if $form->{selectlanguage};

    $colspan = $#column_index + 1;

    $invoice = $locale->text('Invoices');
    $vclabel = ucfirst $form->{vc};
    $vclabel = $locale->text($vclabel);

    print qq|
  <input type=hidden name=column_index value="id @column_index">
  <tr>
    <td>
      <table width=100%>
    <tr>
      <th class=listheading colspan=$colspan>$invoice</th>
    </tr>
|;

    $column_data{name} = qq|<th nowrap>$vclabel</th>|;
    $column_data{invnumber} =
      qq|<th nowrap>| . $locale->text('Invoice') . "</th>";
    $column_data{transdate} = qq|<th nowrap>| . $locale->text('Date') . "</th>";
    $column_data{amount} = qq|<th nowrap>| . $locale->text('Amount') . "</th>";
    $column_data{due} = qq|<th nowrap>| . $locale->text('Amount Due') . "</th>";
    $column_data{paid}    = qq|<th nowrap>| . $locale->text('Amount') . "</th>";
    $column_data{checked} = qq|<th nowrap>| . $locale->text('Select') . "</th>";
    $column_data{memo}    = qq|<th nowrap>| . $locale->text('Memo') . "</th>";
    $column_data{source}  = qq|<th nowrap>| . $locale->text('Source') . "</th>";
    $column_data{language} =
      qq|<th nowrap>| . $locale->text('Language') . "</th>";

    print qq|
        <tr>
|;
    for (@column_index) { print "$column_data{$_}\n" }
    print qq|
        </tr>
|;

    $form->{selectlanguage} = $form->unescape( $form->{selectlanguage} );

    for $i ( 1 .. $form->{rowcount} ) {

        for (qw(amount due paid)) {
            $form->{"${_}_$i"} =
              $form->parse_amount( \%myconfig, $form->{"${_}_$i"} );
        }

        $totalamount += $form->{"amount_$i"};
        $totaldue    += $form->{"due_$i"};
        if ( $form->{"paid_$i"} =~ /NaN/ ) {
            $form->{"paid_$i"} = '';
        }
        else {
            $totalpaid += $form->{"paid_$i"};
        }

        for (qw(amount due paid)) {
            $form->{"${_}_$i"} =
              $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 );
        }

        $column_data{invnumber} = qq|<td>$form->{"invnumber_$i"}</td>
      <input type=hidden name="invnumber_$i" value="$form->{"invnumber_$i"}">
      <input type=hidden name="id_$i" value=$form->{"id_$i"}>|;
        $column_data{transdate} = qq|<td>$form->{"transdate_$i"}</td>
      <input type=hidden name="transdate_$i" value=$form->{"transdate_$i"}>|;
        $column_data{amount} = qq|<td align=right>$form->{"amount_$i"}</td>
      <input type=hidden name="amount_$i" value=$form->{"amount_$i"}>|;
        $column_data{due} = qq|<td align=right>$form->{"due_$i"}</td>
      <input type=hidden name="due_$i" value=$form->{"due_$i"}>|;

        if ( $form->{"paid_$i"} =~ /NaN/ ) {
            $form->{"paid_$i"} = '';
        }
        $column_data{paid} =
qq|<td align=right><input name="paid_$i" size=10 value=$form->{"paid_$i"}></td>|;

        if ( $same_id eq $form->{"$form->{vc}_id_$i"} ) {
            for (qw(name memo source language)) {
                $column_data{$_} = qq|<td>&nbsp;</td>|;
            }
        }
        else {
            $column_data{name} = qq|<td>$form->{"name_$i"}</td>|;
            $column_data{memo} =
qq|<td align=right><input name="memo_$i" size=10 value="$form->{"memo_$i"}"></td>|;
            $column_data{source} =
qq|<td align=right><input name="source_$i" size=10 value="$form->{"source_$i"}"></td>|;

            if ( $form->{selectlanguage} ) {
                $selectlanguage = $form->{selectlanguage};
                $selectlanguage =~
s/(<option value="\Q$form->{"language_code_$i"}\E")/$1 selected/;
                $column_data{language} =
qq|<td><select name="language_code_$i">$selectlanguage</select></td>|;
            }

        }

        $column_data{name} .= qq|
      <input type=hidden name="name_$i" value="$form->{"name_$i"}">
      <input type=hidden name="$form->{vc}_id_$i" value="$form->{"$form->{vc}_id_$i"}">|;

        $form->{"checked_$i"} = ( $form->{"checked_$i"} ) ? "checked" : "";
        $column_data{checked} =
qq|<td align=center><input name="checked_$i" type=checkbox class=checkbox $form->{"checked_$i"}></td>|;

        $j++;
        $j %= 2;
        print qq|
    <tr class=listrow$j>
|;
        for (@column_index) { print "$column_data{$_}\n" }
        print qq|
        </tr>
|;

        $same_id = $form->{"$form->{vc}_id_$i"};

    }

    for (@column_index) { $column_data{$_} = "<td>&nbsp;</td>" }

    $column_data{amount} =
        qq|<th class=listtotal align=right>|
      . $form->format_amount( \%myconfig, $totalamount, 2, "&nbsp;" )
      . qq|</th>|;
    $column_data{due} =
        qq|<th class=listtotal align=right>|
      . $form->format_amount( \%myconfig, $totaldue, 2, "&nbsp;" )
      . qq|</th>|;
    $column_data{paid} =
        qq|<th class=listtotal align=right>|
      . $form->format_amount( \%myconfig, $totalpaid, 2, "&nbsp;" )
      . qq|</th>|;

    print qq|
        <tr class=listtotal>
|;
    for (@column_index) { print "$column_data{$_}\n" }
    print qq|
        </tr>
      </table>
    </td>
  </tr>
<input type=hidden name=selectlanguage value="|
      . $form->escape( $form->{selectlanguage}, 1 ) . qq|">
|;

}

sub payments_footer {

    $form->{DF}{ $form->{format} } = "selected";

    $transdate = $form->datetonum( \%myconfig, $form->{datepaid} );
    $closedto  = $form->datetonum( \%myconfig, $form->{closedto} );

    if ( ${LedgerSMB::Sysconfig::latex} ) {

        $media = qq|<select name=media>
          <option value=screen>| . $locale->text('Screen');

        if ( %{LedgerSMB::Sysconfig::printer} ) {
            for ( sort keys %{LedgerSMB::Sysconfig::printer} ) {
                $media .= qq| 
          <option value="$_">$_|;
            }
        }

        $media .= qq|</select>|;
        $format = qq|<select name=format>
            <option value=postscript $form->{DF}{postscript}>|
          . $locale->text('Postscript') . qq|
        <option value=pdf $form->{DF}{pdf}>|
          . $locale->text('PDF')
          . qq|</select>|;
    }

    print qq|
  <tr>
    <td><hr size=3 noshade></td>
  </tr>
</table>
|;

    # type=submit $locale->text('Update')
    # type=submit $locale->text('Post')
    # type=submit $locale->text('Print')
    # type=submit $locale->text('Select all')

    %button = (
        'update' => { ndx => 1, key => 'U', value => $locale->text('Update') },
        'select_all' =>
          { ndx => 2, key => 'A', value => $locale->text('Select all') },
        'print' => { ndx => 3, key => 'P', value => $locale->text('Print') },
        'post'  => { ndx => 4, key => 'O', value => $locale->text('Post') },
    );

    if ( !${LedgerSMB::Sysconfig::latex} ) {
        delete $button{'print'};
    }

    if ( $transdate <= $closedto ) {
        for ( 'post', 'print' ) { delete $button{$_} }
        $media = $format = "";
    }

    for ( sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button ) {
        $form->print_button( \%button, $_ );
    }

    $media =~ s/(<option value="\Q$form->{media}\E")/$1 selected/;

    print qq|
  $format
  $media
|;

    $form->hide_form(qw(callback rowcount path login sessionid));

    if ( $form->{lynx} ) {
        require "bin/menu.pl";
        &menubar;
    }

    print qq|
  </form>

</body>
</html>
|;

}

sub select_all {

    for ( 1 .. $form->{rowcount} ) { $form->{"checked_$_"} = 1 }
    &{"update_$form->{payment}"}

}

sub update {
    my ($new_name_selected) = @_;

    &{"update_$form->{payment}"};

}

sub update_payments {

    if ( $form->{ARAP} eq 'AR' ) {
        $buysell = "buy";
    }
    else {
        $buysell = "sell";
    }

    if (   ( $form->{oldduedatefrom} ne $form->{duedatefrom} )
        || ( $form->{oldduedateto} ne $form->{duedateto} )
        || ( $form->{department}   ne $form->{olddepartment} ) )
    {
        CP->get_openinvoices( \%myconfig, \%$form );
        $form->{redo} = 1;
    }

    if ( $form->{currency} ne $form->{oldcurrency} ) {
        $form->{oldcurrency} = $form->{currency};
        if ( !$form->{redo} ) {
            CP->get_openinvoices( \%myconfig, \%$form );
            $form->{redo} = 1;
        }
    }

    for (qw(duedatefrom duedateto department)) {
        $form->{"old$_"} = $form->{$_};
    }

    $form->{exchangerate} = $exchangerate
      if (
        $form->{forex} = (
            $exchangerate = $form->check_exchangerate(
                \%myconfig, $form->{currency}, $form->{datepaid}, $buysell
            )
        )
      );

    if ( $form->{redo} ) {
        $form->{rowcount} = 0;

        $i = 0;
        foreach $ref ( @{ $form->{PR} } ) {
            $i++;
            for (qw(id name invnumber transdate)) {
                $form->{"${_}_$i"} = $ref->{$_};
            }
            $form->{"$form->{vc}_id_$i"} = $ref->{"$form->{vc}_id"};
            $ref->{exchangerate} = 1 unless $ref->{exchangerate};
            $form->{"amount_$i"} = $ref->{amount} / $ref->{exchangerate};
            $form->{"due_$i"} =
              ( $ref->{amount} - $ref->{paid} ) / $ref->{exchangerate};
            $form->{"checked_$i"} = "";
            $form->{"paid_$i"}    = "";

            # need to format
            for (qw(amount due)) {
                $form->{"${_}_$i"} =
                  $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 );
            }
        }

        $form->{rowcount} = $i;
    }

    $form->{amount} = $form->parse_amount( \%myconfig, $form->{amount} );

    # recalculate
    $amount = 0;
    for $i ( 1 .. $form->{rowcount} ) {

        for (qw(amount due paid)) {
            $form->{"${_}_$i"} =
              $form->parse_amount( \%myconfig, $form->{"${_}_$i"} );
        }

        if ( $form->{"checked_$i"} ) {

            # calculate paid_$i
            if ( !$form->{"paid_$i"} ) {
                $form->{"paid_$i"} = $form->{"due_$i"};
            }

            $amount += $form->{"paid_$i"};
            $form->{redo} = 1;
        }
        else {
            $form->{"paid_$i"} = "";
        }

        for (qw(amount due paid)) {
            $form->{"${_}_$i"} =
              $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 )
        if $form->{"${_}_$i"};
        }
    }

    $form->{amount} += ( $amount - $form->{oldamount} ) if $form->{redo};

    &payments_header;
    &invoices_due;
    &payments_footer;

}

sub update_payment {

    if ( $form->{vc} eq 'customer' ) {
        $buysell = "buy";
    }
    else {
        $buysell = "sell";
    }

    $department = $form->{department};

    # get customer/vendor
    &check_openvc;
    $form->{department} = $department;

    if ( $form->{datepaid} ne $form->{olddatepaid} ) {
        $form->{olddatepaid} = $form->{datepaid};
        $form->{oldall_vc} = !$form->{oldall_vc} if $form->{all_vc};
    }

    if ( $form->{department} ne $form->{olddepartment} ) {
        $form->{olddepartment} = $form->{department};
        $form->{redo}          = 1;
    }

    # if we switched to all_vc
    if ( $form->{all_vc} ne $form->{oldall_vc} ) {

        if ( $form->{"select$form->{vc}"} ) {
            $form->{redo} = ( $form->{"old$name"} ne $form->{$name} );
        }
        else {
            $form->{redo} =
              ( $form->{"old$name"} ne
                  qq|$form->{$name}--$form->{"${name}_id"}| );
        }

        $form->{"select$form->{vc}"} = "";

        if ( $form->{all_vc} ) {
            $form->all_vc( \%myconfig, $form->{vc}, $form->{ARAP}, undef,
                $form->{datepaid} );

            if ( @{ $form->{"all_$form->{vc}"} } ) {
                for ( @{ $form->{"all_$form->{vc}"} } ) {
                    $form->{"select$form->{vc}"} .=
                      qq|<option value="$_->{name}--$_->{id}">$_->{name}\n|;
                }
            }

        }
        else {
            if ( ( $myconfig{vclimit} * 1 ) > 0 ) {
                $form->{ $form->{vc} } = "";
            }

            CP->get_openvc( \%myconfig, \%$form );

            if ( ( $myconfig{vclimit} * 1 ) > 0 ) {
                $form->{"all_$form->{vc}"} = $form->{name_list};
            }

            if ( @{ $form->{"all_$form->{vc}"} } ) {
                $newvc =
qq|$form->{"all_$form->{vc}"}[0]->{name}--$form->{"all_$form->{vc}"}[0]->{id}|;
                for ( @{ $form->{"all_$form->{vc}"} } ) {
                    $form->{"select$form->{vc}"} .=
                      qq|<option value="$_->{name}--$_->{id}">$_->{name}\n|;
                }

                # if the name is not the same
                if ( $form->{"select$form->{vc}"} !~ /$form->{$form->{vc}}/ ) {
                    $form->{ $form->{vc} } = $newvc;
                    &check_openvc;
                }
            }
        }

        if ( @{ $form->{all_language} } ) {
            $form->{selectlanguage} = "<option>\n";
            for ( @{ $form->{all_language} } ) {
                $form->{selectlanguage} .=
                  qq|<option value="$_->{code}">$_->{description}\n|;
            }
        }

    }

    if ( $new_name_selected || $form->{redo} ) {
        CP->get_openinvoices( \%myconfig, \%$form );
        ($newvc) = split /--/, $form->{ $form->{vc} };
        $form->{"old$form->{vc}"} = qq|$newvc--$form->{"$form->{vc}_id"}|;
        $form->{redo} = 1;
    }

    if ( $form->{currency} ne $form->{oldcurrency} ) {
        $form->{oldcurrency} = $form->{currency};
        if ( !$form->{redo} ) {
            CP->get_openinvoices( \%myconfig, \%$form );
            $form->{redo} = 1;
        }
    }

    $form->{exchangerate} = $exchangerate
      if (
        $form->{forex} = (
            $exchangerate = $form->check_exchangerate(
                \%myconfig, $form->{currency}, $form->{datepaid}, $buysell
            )
        )
      );

    if ( $form->{redo} ) {
        $form->{rowcount} = 0;

        $i = 0;
        foreach $ref ( @{ $form->{PR} } ) {
            $i++;
            $form->{"id_$i"}        = $ref->{id};
            $form->{"invnumber_$i"} = $ref->{invnumber};
            $form->{"transdate_$i"} = $ref->{transdate};
            $ref->{exchangerate} = 1 unless $ref->{exchangerate};
            $form->{"amount_$i"} = $ref->{amount} / $ref->{exchangerate};
            $form->{"due_$i"} =
              ( $ref->{amount} - $ref->{paid} ) / $ref->{exchangerate};
            $form->{"checked_$i"} = "";
            $form->{"paid_$i"}    = "";

            # need to format
            for (qw(amount due)) {
                $form->{"${_}_$i"} =
                  $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 );
            }
        }
        $form->{rowcount} = $i;
    }

    $form->{amount} = $form->parse_amount( \%myconfig, $form->{amount} );

    # recalculate
    $amount = 0;
    for $i ( 1 .. $form->{rowcount} ) {

        for (qw(amount due paid)) {
            $form->{"${_}_$i"} =
              $form->parse_amount( \%myconfig, $form->{"${_}_$i"} );
        }

        if ( $form->{"checked_$i"} ) {

            # calculate paid_$i
            if ( !$form->{"paid_$i"} ) {
                $form->{"paid_$i"} = $form->{"due_$i"};
            }

            $amount += $form->{"paid_$i"};
            $form->{redo} = 1;
        }
        else {
            $form->{"paid_$i"} = "";
        }

        for (qw(amount due paid)) {
            $form->{"${_}_$i"} =
              $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 )
        if $form->{"${_}_$i"};
        }
    }

    $form->{amount} += ( $amount - $form->{oldamount} ) if $form->{redo};

    &payment_header;
    &list_invoices;
    &payment_footer;

}

sub payment_header {

    $vclabel = ucfirst $form->{vc};
    $vclabel = $locale->text($vclabel);

    if ( $form->{type} eq 'receipt' ) {
        $form->{title} = $locale->text('Receipt');
    }
    if ( $form->{type} eq 'check' ) {
        $form->{title} = $locale->text('Payment');
    }

    # $locale->text('Customer')
    # $locale->text('Vendor')

    if ( $form->{ $form->{vc} } eq "" ) {
        for (qw(address1 address2 city zipcode state country)) {
            $form->{$_} = "";
        }
    }

    for ( "$form->{vc}", "department" ) {
        $form->{"select$_"} = $form->unescape( $form->{"select$_"} );
        $form->{"select$_"} =~ s/ selected//;
        $form->{"select$_"} =~ s/(<option value="\Q$form->{$_}\E")/$1 selected/;
    }

    for ( "account", "currency", "$form->{ARAP}" ) {
        $form->{"select$_"} =~ s/ selected//;
        $form->{"select$_"} =~
          s/option>\Q$form->{$_}\E/option selected>$form->{$_}/;
    }

    if ( $form->{defaultcurrency} ) {
        $exchangerate = qq|
          <tr>
        <th align=right nowrap>| . $locale->text('Currency') . qq|</th>
        <td><select name=currency>$form->{selectcurrency}</select></td>
        <input type=hidden name=selectcurrency value="$form->{selectcurrency}">
        <input type=hidden name=oldcurrency value=$form->{oldcurrency}>
          </tr>
|;
    }

    if ( $form->{currency} ne $form->{defaultcurrency} ) {
        $form->{exchangerate} =
          $form->format_amount( \%myconfig, $form->{exchangerate} );

        if ( $form->{forex} ) {
            $exchangerate .= qq|
          <tr>
        <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th>
        <td colspan=3><input type=hidden name=exchangerate size=10 value=$form->{exchangerate}>$form->{exchangerate}</td>
          </tr>
|;
        }
        else {
            $exchangerate .= qq|
          <tr>
        <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th>
        <td colspan=3><input name=exchangerate size=10 value=$form->{exchangerate}></td>
          </tr>
|;
        }
    }

    $vc =
      ( $form->{"select$form->{vc}"} )
      ? qq|<select name=$form->{vc}>$form->{"select$form->{vc}"}\n</select>|
      : qq|<input name=$form->{vc} size=35 value="$form->{$form->{vc}}">|;

    if ( $form->{all_vc} ) {
        $allvc = "checked";
    }
    else {
        $allvc = "";
    }

    # $locale->text('AR')
    # $locale->text('AP')

    $department = qq|
              <tr>
            <th align="right" nowrap>| . $locale->text('Department') . qq|</th>
        <td><select name=department>$form->{selectdepartment}</select>
        <input type=hidden name=selectdepartment value="|
      . $form->escape( $form->{selectdepartment}, 1 ) . qq|">
          </td>
        </tr>
| if $form->{selectdepartment};

    $form->header;

    print qq|
<body>

<form method=post action=$form->{script}>
|;

    $form->hide_form(
        qw(defaultcurrency closedto vc type ARAP arap title formname payment olddepartment)
    );

    print qq|

<table width=100%>
  <tr>
    <th class=listtop>$form->{title}</th>
  </tr>
  <tr height="5"></tr>
  <tr>
    <td>
      <table width=100%>
        <tr valign=top>
      <td>
        <table>
          <tr>
            <td align=right>
        <input name=all_vc type=checkbox class=checkbox value=Y $allvc>
        <input type=hidden name="oldall_vc" value="$form->{all_vc}"></td>
        <th align=left>| . $locale->text('All') . qq|</th>
          </tr>
          <tr>
        <th align=right>$vclabel</th>
        <td>$vc</td>
                <input type=hidden name="select$form->{vc}" value="|
      . $form->escape( $form->{"select$form->{vc}"}, 1 ) . qq|">
                <input type=hidden name="$form->{vc}_id" value=$form->{"$form->{vc}_id"}>
        <input type=hidden name="old$form->{vc}" value="$form->{"old$form->{vc}"}">
          </tr>
          <tr valign=top>
        <th align=right nowrap>| . $locale->text('Address') . qq|</th>
        <td colspan=2>
          <table>
            <tr>
              <td>$form->{address1}</td>
            </tr>
            <tr>
              <td>$form->{address2}</td>
            </tr>
              <td>$form->{city}</td>
            </tr>
            </tr>
              <td>$form->{state}</td>
            </tr>
            </tr>
              <td>$form->{zipcode}</td>
            </tr>
            <tr>
              <td>$form->{country}</td>
            </tr>
          </table>
        </td>
        <input type=hidden name=address1 value="$form->{address1}">
        <input type=hidden name=address2 value="$form->{address2}">
        <input type=hidden name=city value="$form->{city}">
        <input type=hidden name=state value="$form->{state}">
        <input type=hidden name=zipcode value="$form->{zipcode}">
        <input type=hidden name=country value="$form->{country}">
          </tr>
          <tr>
        <th align=right>| . $locale->text('Memo') . qq|</th>
        <td colspan=2><input name="memo" size=30 value="$form->{memo}"></td>
          </tr>
        </table>
      </td>
      <td align=right>
        <table>
          $department
          <tr>
            <th align=right nowrap>| . $locale->text( $form->{ARAP} ) . qq|</th>
        <td colspan=3><select name=$form->{ARAP}>$form->{"select$form->{ARAP}"}</select>
        </td>
        <input type=hidden name="select$form->{ARAP}" value="$form->{"select$form->{ARAP}"}">
          </tr>
          <tr>
        <th align=right nowrap>| . $locale->text('Account') . qq|</th>
        <td colspan=3><select name=account>$form->{selectaccount}</select>
        <input type=hidden name=selectaccount value="$form->{selectaccount}">
        </td>
          </tr>
          <tr>
        <th align=right nowrap>| . $locale->text('Date') . qq|</th>
        <td><input class="date" name=datepaid value="$form->{datepaid}" title="$myconfig{dateformat}" size=11></td>
        <input type=hidden name=olddatepaid value=$form->{olddatepaid}>
          </tr>
          $exchangerate
          <tr>
        <th align=right nowrap>| . $locale->text('Source') . qq|</th>
        <td colspan=3><input name=source value="$form->{source}" size=10></td>
          </tr>
          <tr>
        <th align=right nowrap>| . $locale->text('Amount') . qq|</th>
        <td colspan=3><input name=amount size=10 value=|
      . $form->format_amount( \%myconfig, $form->{amount}, 2 )
      . qq|></td>
        <input type=hidden name=oldamount value=$form->{amount}>
          </tr>
        </table>
      </td>
    </tr>
      </table>
    </td>
  </tr>
|;

}

sub list_invoices {

    @column_index = qw(invnumber transdate amount due checked paid);

    $colspan = $#column_index + 1;

    $invoice = $locale->text('Invoices');

    print qq|
  <input type=hidden name=column_index value="id @column_index">
  <tr>
    <td>
      <table width=100%>
    <tr>
      <th class=listheading colspan=$colspan>$invoice</th>
    </tr>
|;

    $column_data{invnumber} =
      qq|<th nowrap>| . $locale->text('Invoice') . "</th>";
    $column_data{transdate} = qq|<th nowrap>| . $locale->text('Date') . "</th>";
    $column_data{amount} = qq|<th nowrap>| . $locale->text('Amount') . "</th>";
    $column_data{due} = qq|<th nowrap>| . $locale->text('Amount Due') . "</th>";
    $column_data{paid}    = qq|<th nowrap>| . $locale->text('Amount') . "</th>";
    $column_data{checked} = qq|<th nowrap>| . $locale->text('Select') . "</th>";

    print qq|
        <tr>
|;
    for (@column_index) { print "$column_data{$_}\n" }
    print qq|
        </tr>
|;

    for $i ( 1 .. $form->{rowcount} ) {

        for (qw(amount due paid)) {
            $form->{"${_}_$i"} =
              $form->parse_amount( \%myconfig, $form->{"${_}_$i"} );
        }

        $totalamount += $form->{"amount_$i"};
        $totaldue    += $form->{"due_$i"};
        if ( $form->{"paid_$i"} !~ /NaN/ ) {
            $totalpaid += $form->{"paid_$i"};
        }

        for (qw(amount due paid)) {
            $form->{"${_}_$i"} =
              $form->format_amount( \%myconfig, $form->{"${_}_$i"}, 2 );
        }

        $column_data{invnumber} = qq|<td>$form->{"invnumber_$i"}</td>
      <input type=hidden name="invnumber_$i" value="$form->{"invnumber_$i"}">
      <input type=hidden name="id_$i" value=$form->{"id_$i"}>|;
        $column_data{transdate} = qq|<td width=15%>$form->{"transdate_$i"}</td>
      <input type=hidden name="transdate_$i" value=$form->{"transdate_$i"}>|;
        $column_data{amount} =
          qq|<td align=right width=15%>$form->{"amount_$i"}</td>
      <input type=hidden name="amount_$i" value=$form->{"amount_$i"}>|;
        $column_data{due} = qq|<td align=right width=15%>$form->{"due_$i"}</td>
      <input type=hidden name="due_$i" value=$form->{"due_$i"}>|;

        if ( $form->{"paid_$i"} =~ /NaN/ ) {
            $form->{"paid_$i"} = '';
        }

        $column_data{paid} =
qq|<td align=right width=15%><input name="paid_$i" size=10 value=$form->{"paid_$i"}></td>|;

        $form->{"checked_$i"} = ( $form->{"checked_$i"} ) ? "checked" : "";
        $column_data{checked} =
qq|<td align=center width=10%><input name="checked_$i" type=checkbox class=checkbox $form->{"checked_$i"}></td>|;

        $j++;
        $j %= 2;
        print qq|
    <tr class=listrow$j>
|;
        for (@column_index) { print "$column_data{$_}\n" }
        print qq|
        </tr>
|;
    }

    for (@column_index) { $column_data{$_} = "<td>&nbsp;</td>" }

    $column_data{amount} =
        qq|<th class=listtotal align=right>|
      . $form->format_amount( \%myconfig, $totalamount, 2, "&nbsp;" )
      . qq|</th>|;
    $column_data{due} =
        qq|<th class=listtotal align=right>|
      . $form->format_amount( \%myconfig, $totaldue, 2, "&nbsp;" )
      . qq|</th>|;
    $column_data{paid} =
        qq|<th class=listtotal align=right>|
      . $form->format_amount( \%myconfig, $totalpaid, 2, "&nbsp;" )
      . qq|</th>|;

    print qq|
        <tr class=listtotal>
|;
    for (@column_index) { print "$column_data{$_}\n" }
    print qq|
        </tr>
      </table>
    </td>
  </tr>
|;

}

sub payment_footer {

    $form->{DF}{ $form->{format} } = "selected";

    $transdate = $form->datetonum( \%myconfig, $form->{datepaid} );
    $closedto  = $form->datetonum( \%myconfig, $form->{closedto} );

    if ( ${LedgerSMB::Sysconfig::latex} ) {
        if ( $form->{selectlanguage} ) {
            $form->{"selectlanguage"} =
              $form->unescape( $form->{"selectlanguage"} );
            $form->{"selectlanguage"} =~ s/ selected//;
            $form->{"selectlanguage"} =~
              s/(<option value="\Q$form->{language_code}\E")/$1 selected/;
            $lang =
              qq|<select name=language_code>$form->{selectlanguage}</select>
      <input type=hidden name=selectlanguage value="|
              . $form->escape( $form->{selectlanguage}, 1 ) . qq|">|;
        }

        $media = qq|<select name=media>
          <option value=screen>| . $locale->text('Screen');

        if ( %{LedgerSMB::Sysconfig::printer} ) {
            for ( sort keys %{LedgerSMB::Sysconfig::printer} ) {
                $media .= qq| 
          <option value="$_">$_|;
            }
        }

        $media .= qq|</select>|;
        $format = qq|<select name=format>
            <option value=postscript $form->{DF}{postscript}>|
          . $locale->text('Postscript') . qq|
        <option value=pdf $form->{DF}{pdf}>|
          . $locale->text('PDF')
          . qq|</select>|;
    }

    print qq|
  <tr>
    <td><hr size=3 noshade></td>
  </tr>
</table>
|;

    %button = (
        'update' => { ndx => 1, key => 'U', value => $locale->text('Update') },
        'select_all' =>
          { ndx => 2, key => 'A', value => $locale->text('Select all') },
        'print' => { ndx => 3, key => 'P', value => $locale->text('Print') },
        'post'  => { ndx => 4, key => 'O', value => $locale->text('Post') },
    );

    if ( !${LedgerSMB::Sysconfig::latex} ) {
        delete $button{'print'};
    }

    if ( $transdate <= $closedto ) {
        for ( 'post', 'print' ) { delete $button{$_} }
        $media = $format = "";
    }

    for ( sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button ) {
        $form->print_button( \%button, $_ );
    }

    $media =~ s/(<option value="\Q$form->{media}\E")/$1 selected/;

    print qq|
  $lang
  $format
  $media
|;

    $form->hide_form(qw(callback rowcount path login sessionid));

    if ( $form->{lynx} ) {
        require "bin/menu.pl";
        &menubar;
    }

    print qq|
  </form>

</body>
</html>
|;

}

sub post {
    &default_date;
    &{"post_$form->{payment}"};
}

sub post_payments {

    if ( $form->{currency} ne $form->{defaultcurrency} ) {
        $form->error( $locale->text('Exchange rate missing!') )
          unless $form->{exchangerate};
    }

    if ( CP->post_payments( \%myconfig, \%$form ) ) {
        $form->redirect( $locale->text('Payments posted!') );
    }
    else {
        $form->error( $locale->text('Posting failed!') );
    }

}

sub post_payment {

    &check_form;

    if ( $form->{currency} ne $form->{defaultcurrency} ) {
        $form->error( $locale->text('Exchange rate missing!') )
          unless $form->{exchangerate};
    }

    $msg1 = "$form->{title} posted!";
    $msg2 = "Cannot post $form->{title}!";

    # $locale->text('Payment posted!')
    # $locale->text('Receipt posted!')
    # $locale->text('Cannot post Payment!')
    # $locale->text('Cannot post Receipt!')

    $form->{amount} = $form->format_amount( \%myconfig, $form->{amount}, 2 );

    $source = $form->{source};
    $source =~ s/(\d+)/$1 + 1/e;

    if ( $form->{callback} ) {
        $form->{callback} .= "&source=$source";
    }

    if ( CP->post_payment( \%myconfig, \%$form ) ) {
        $form->redirect( $locale->text($msg1) );
    }
    else {
        $form->error( $locale->text($msg2) );
    }

}

sub print {

    &{"print_$form->{payment}"};
    &update if $form->{media} ne 'screen';

}

sub print_payments {

    $form->error( $locale->text('Select postscript or PDF!') )
      if ( $form->{format} !~ /(postscript|pdf)/ );

    $SIG{INT} = 'IGNORE';

    for (qw(company address)) { $form->{$_} = $myconfig{$_} }
    $form->{address} =~ s/\\n/\n/g;

    %oldform = ();
    for ( keys %$form ) { $oldform{$_} = $form->{$_} }

    @a =
      qw(name company address text_amount text_decimal address1 address2 city state zipcode country memo);
    for (@a) { $temp{$_} = $form->{$_} }

    $form->format_string(@a);

    $ok             = 0;
    $j              = 0;
    $temp{rowcount} = $form->{rowcount};

    for $i ( 1 .. $temp{rowcount} ) {

        if ( $form->{"$form->{vc}_id_$i"} ne $form->{"$form->{vc}_id"} ) {

            $form->{rowcount} = $j;
            for ( 1 .. $j ) { $form->{"id_$_"} = $temp{"id_$_"} }
            &print_form if $ok;

            $ok             = 0;
            $j              = 0;
            $form->{amount} = 0;
            for (qw(invnumber invdate due paid)) { @{ $form->{$_} } = () }
            for (qw(language_code source memo)) {
                $form->{$_} = $form->{"${_}_$i"};
            }

        }

        if ( $form->{"checked_$i"} ) {
            $j++;
            $ok                   = 1;
            $temp{"id_$j"}        = $form->{"id_$i"};
            $form->{"invdate_$i"} = $form->{"transdate_$i"};
            for (qw(invnumber invdate due paid)) {
                push @{ $form->{$_} }, $form->{"${_}_$i"};
            }
            $form->{amount} +=
              $form->parse_amount( \%myconfig, $form->{"paid_$i"} );
            $form->{"$form->{vc}_id"} = $form->{"$form->{vc}_id_$i"};
        }

    }

    $form->{rowcount} = $j;
    for ( 1 .. $j ) { $form->{"id_$_"} = $temp{"id_$_"} }

    &print_form if $ok;

    for ( keys %oldform ) { $form->{$_} = $oldform{$_} }

}

sub print_form {

    $c =
      CP->new( ( $form->{language_code} )
        ? $form->{language_code}
        : $myconfig{countrycode} );
    $c->init;

    ( $whole, $form->{decimal} ) = split /\./, $form->{amount};
    $form->{amount} = $form->format_amount( \%myconfig, $form->{amount}, 2 );
    $form->{decimal} .= "00";
    $form->{decimal}        = substr( $form->{decimal}, 0, 2 );
    $form->{text_decimal}   = $c->num2text( $form->{decimal} * 1 );
    $form->{text_amount}    = $c->num2text($whole);
    $form->{integer_amount} = $form->format_amount( $myconfig, $whole );

    $datepaid = $form->datetonum( \%myconfig, $form->{datepaid} );
    ( $form->{yyyy}, $form->{mm}, $form->{dd} ) = $datepaid =~ /(....)(..)(..)/;

    &{"$form->{vc}_details"};

    $form->{templates} = "$myconfig{templates}";
    $form->{IN}        = "$form->{formname}.tex";

    if ( $form->{media} ne 'screen' ) {
        $form->{OUT}       = "${LedgerSMB::Sysconfig::printer}{$form->{media}}";
        $form->{printmode} = '|-';
    }

    my $template = LedgerSMB::Template->new( user => \%myconfig, 
      template => $form->{'formname'}, format => uc $form->{format} );
    try {
        $template->render($form);
        $template->output(%{$form});
    }
    catch Error::Simple with {
        my $E = shift;
        $form->error( $E->stacktrace );
    };

}

sub print_payment {

    &check_form;

    for (qw(company address)) { $form->{$_} = $myconfig{$_} }
    $form->{address} =~ s/\\n/\n/g;

    @a =
      qw(rowcount name company address text_amount text_decimal address1 address2 city state zipcode country memo);

    %temp = ();
    for (@a) { $temp{$_} = $form->{$_} }

    if (
        scalar @{ $form->{invnumber} } >
        ${LedgerSMB::Sysconfig::check_max_invoices} )
    {
        $#{ $form->{invnumber} } =
          ${LedgerSMB::Sysconfig::check_max_invoices} - 1;
        $form->{invnumbers_maxed} = 1;
        $form->{message} =
          $locale->text(
            "Please see attatched report for list of invoices paid.");
    }

    $form->format_string(@a);

    &print_form;

    for ( keys %temp ) { $form->{$_} = $temp{$_} }

}

sub customer_details { IS->customer_details( \%myconfig, \%$form ) }
sub vendor_details { IR->vendor_details( \%myconfig, \%$form ) }

sub check_form {

    &check_openvc;

    if ( $form->{currency} ne $form->{oldcurrency} ) {
        &update;
        exit;
    }

    $form->error( $locale->text('Date missing!') ) unless $form->{datepaid};

    $closedto = $form->datetonum( \%myconfig, $form->{closedto} );
    $datepaid = $form->datetonum( \%myconfig, $form->{datepaid} );

    $form->error( $locale->text('Cannot post payment for a closed period!') )
      if ( $datepaid <= $closedto );

    $form->{datepaid} = $locale->date( \%myconfig, $form->{datepaid} );

    $amount = $form->parse_amount( \%myconfig, $form->{amount} );
    $form->{amount} = $amount;

    for $i ( 1 .. $form->{rowcount} ) {
        if ( $form->{"paid_$i"} ) {
            $amount -= $form->parse_amount( \%myconfig, $form->{"paid_$i"} );

            push( @{ $form->{paid} },      $form->{"paid_$i"} );
            push( @{ $form->{due} },       $form->{"due_$i"} );
            push( @{ $form->{invnumber} }, $form->{"invnumber_$i"} );
            push( @{ $form->{invdate} },   $form->{"transdate_$i"} );
        }
    }

    if ( $form->round_amount( $amount, 2 ) != 0 ) {
        push(
            @{ $form->{paid} },
            $form->format_amount( \%myconfig, $amount, 2 )
        );
        push( @{ $form->{due} }, $form->format_amount( \%myconfig, 0, "0" ) );
        push(
            @{ $form->{invnumber} },
            ( $form->{ARAP} eq 'AR' )
            ? $locale->text('Deposit')
            : $locale->text('Prepayment')
        );
        push( @{ $form->{invdate} }, $form->{datepaid} );
    }

}

sub check_openvc {

    $name = $form->{vc};
    ( $new_name, $new_id ) = split /--/, $form->{$name};

    if ( $form->{all_vc} ) {
        if ( $form->{"select$name"} ) {
            $ok = ( $form->{"old$name"} ne $form->{$name} );
        }
        else {
            $ok =
              ( $form->{"old$name"} ne
                  qq|$form->{$name}--$form->{"${name}_id"}| );
        }

        if ($ok) {
            $form->{redo} = 1;
            if ( $form->{"select$name"} ) {
                $form->{"${name}_id"} = $new_id;
                AA->get_name( \%myconfig, \%$form );
                $form->{$name} = $form->{"old$name"} = "$new_name--$new_id";
            }
            else {
                &check_name( $form->{vc} );
            }
        }

    }
    else {

        # if we use a selection
        if ( $form->{"select$name"} ) {
            if ( $form->{"old$name"} ne $form->{$name} ) {

                $form->{"${name}_id"} = $new_id;
                AA->get_name( \%myconfig, \%$form );

                $form->{$name} = $form->{"old$name"} = "$new_name--$new_id";
                $form->{redo} = 1;
            }
        }
        else {

            # check name, combine name and id
            if ( $form->{"old$name"} ne
                qq|$form->{$name}--$form->{"${name}_id"}| )
            {

                # return one name or a list of names in $form->{name_list}
                if ( ( $rv = CP->get_openvc( \%myconfig, \%$form ) ) > 1 ) {
                    $form->{redo} = 1;
                    &select_name($name);
                    exit;
                }

                if ( $rv == 1 ) {

                    # we got one name
                    $form->{"${name}_id"} = $form->{name_list}[0]->{id};
                    $form->{$name} = $form->{name_list}[0]->{name};
                    $form->{"old$name"} =
                      qq|$form->{$name}--$form->{"${name}_id"}|;

                    AA->get_name( \%myconfig, \%$form );

                }
                else {

                    # nothing open
                    $form->error( $locale->text('Nothing open!') );
                }

                $form->{redo} = 1;
            }
        }
    }

}