#===================================================================== # 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) 2001 # # Author: DWS Systems Inc. # Web: http://www.sql-ledger.org # # # 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. #====================================================================== # # Inventory received module # #====================================================================== use LedgerSMB::IR; use LedgerSMB::PE; use LedgerSMB::Tax; require "bin/io.pl"; require "bin/arap.pl"; 1; # end of main sub add { $form->{title} = $locale->text('Add Vendor Invoice'); $form->{callback} = "$form->{script}?action=add&type=$form->{type}&login=$form->{login}&path=$form->{path}&sessionid=$form->{sessionid}" unless $form->{callback}; &invoice_links; &prepare_invoice; &display_form; } sub edit { $form->{title} = $locale->text('Edit Vendor Invoice'); &invoice_links; &prepare_invoice; &display_form; } sub invoice_links { $form->{vc} = "vendor"; $form->{type} = "invoice"; # create links $form->create_links( "AP", \%myconfig, "vendor", 1 ); # currencies @curr = split /:/, $form->{currencies}; $form->{defaultcurrency} = $curr[0]; chomp $form->{defaultcurrency}; for (@curr) { $form->{selectcurrency} .= "<option>$_\n" } if ( @{ $form->{all_vendor} } ) { unless ( $form->{vendor_id} ) { $form->{vendor_id} = $form->{all_vendor}->[0]->{id}; } } AA->get_name( \%myconfig, \%$form ); delete $form->{notes}; IR->retrieve_invoice( \%myconfig, \%$form ); $form->{oldlanguage_code} = $form->{language_code}; $form->get_partsgroup( \%myconfig, { language_code => $form->{language_code} } ); if ( @{ $form->{all_partsgroup} } ) { $form->{selectpartsgroup} = "<option>\n"; foreach $ref ( @{ $form->{all_partsgroup} } ) { if ( $ref->{translation} ) { $form->{selectpartsgroup} .= qq|<option value="$ref->{partsgroup}--$ref->{id}">$ref->{translation}\n|; } else { $form->{selectpartsgroup} .= qq|<option value="$ref->{partsgroup}--$ref->{id}">$ref->{partsgroup}\n|; } } } if ( @{ $form->{all_project} } ) { $form->{selectprojectnumber} = "<option>\n"; for ( @{ $form->{all_project} } ) { $form->{selectprojectnumber} .= qq|<option value="$_->{projectnumber}--$_->{id}">$_->{projectnumber}\n|; } } $form->{oldvendor} = "$form->{vendor}--$form->{vendor_id}"; $form->{oldtransdate} = $form->{transdate}; # vendors $form->{selectvendor} = ""; if ( @{ $form->{all_vendor} } ) { $form->{vendor} = "$form->{vendor}--$form->{vendor_id}"; for ( @{ $form->{all_vendor} } ) { $form->{selectvendor} .= 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_id}; 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|; } } # forex $form->{forex} = $form->{exchangerate}; $exchangerate = ( $form->{exchangerate} ) ? $form->{exchangerate} : 1; foreach $key ( keys %{ $form->{AP_links} } ) { $form->{"select$key"} = ""; foreach $ref ( @{ $form->{AP_links}{$key} } ) { $form->{"select$key"} .= "<option>$ref->{accno}--$ref->{description}\n"; } if ( $key eq "AP_paid" ) { for $i ( 1 .. scalar @{ $form->{acc_trans}{$key} } ) { $form->{"AP_paid_$i"} = "$form->{acc_trans}{$key}->[$i-1]->{accno}--$form->{acc_trans}{$key}->[$i-1]->{description}"; # reverse paid $form->{"paid_$i"} = $form->{acc_trans}{$key}->[ $i - 1 ]->{amount}; $form->{"datepaid_$i"} = $form->{acc_trans}{$key}->[ $i - 1 ]->{transdate}; $form->{"forex_$i"} = $form->{"exchangerate_$i"} = $form->{acc_trans}{$key}->[ $i - 1 ]->{exchangerate}; $form->{"source_$i"} = $form->{acc_trans}{$key}->[ $i - 1 ]->{source}; $form->{"memo_$i"} = $form->{acc_trans}{$key}->[ $i - 1 ]->{memo}; $form->{"cleared_$i"} = $form->{acc_trans}{$key}->[ $i - 1 ]->{cleared}; $form->{paidaccounts} = $i; } } else { $form->{$key} = "$form->{acc_trans}{$key}->[0]->{accno}--$form->{acc_trans}{$key}->[0]->{description}" if $form->{acc_trans}{$key}->[0]->{accno}; } } $form->{paidaccounts} = 1 unless ( exists $form->{paidaccounts} ); $form->{AP} = $form->{AP_1} unless $form->{id}; $form->{locked} = ( $form->{revtrans} ) ? '1' : ( $form->datetonum( \%myconfig, $form->{transdate} ) <= $form->datetonum( \%myconfig, $form->{closedto} ) ); if ( !$form->{readonly} ) { $form->{readonly} = 1 if $myconfig{acs} =~ /AP--Vendor Invoice/; } } sub prepare_invoice { $form->{type} = "invoice"; $form->{currency} =~ s/ //g; $form->{oldcurrency} = $form->{currency}; if ( $form->{id} ) { for (qw(invnumber ordnumber ponumber quonumber)) { $form->{$_} = $form->quote( $form->{$_} ); } foreach $ref ( @{ $form->{invoice_details} } ) { $i++; for ( keys %$ref ) { $form->{"${_}_$i"} = $ref->{$_} } $form->{"projectnumber_$i"} = qq|$ref->{projectnumber}--$ref->{project_id}| if $ref->{project_id}; $form->{"partsgroup_$i"} = qq|$ref->{partsgroup}--$ref->{partsgroup_id}| if $ref->{partsgroup_id}; $form->{"discount_$i"} = $form->format_amount( \%myconfig, $form->{"discount_$i"} * 100 ); ($dec) = ( $form->{"sellprice_$i"} =~ /\.(\d+)/ ); $dec = length $dec; $decimalplaces = ( $dec > 2 ) ? $dec : 2; $form->{"sellprice_$i"} = $form->format_amount( \%myconfig, $form->{"sellprice_$i"}, $decimalplaces ); $form->{"qty_$i"} = $form->format_amount( \%myconfig, $form->{"qty_$i"} ); $form->{"oldqty_$i"} = $form->{"qty_$i"}; for (qw(partnumber sku description unit)) { $form->{"${_}_$i"} = $form->quote( $form->{"${_}_$i"} ); } $form->{rowcount} = $i; } } } sub form_header { # set option selected for (qw(AP currency)) { $form->{"select$_"} =~ s/ selected//; $form->{"select$_"} =~ s/option>\Q$form->{$_}\E/option selected>$form->{$_}/; } for (qw(vendor department)) { $form->{"select$_"} = $form->unescape( $form->{"select$_"} ); $form->{"select$_"} =~ s/ selected//; $form->{"select$_"} =~ s/(<option value="\Q$form->{$_}\E")/$1 selected/; } 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| <tr> <th align=right nowrap>| . $locale->text('Language') . qq|</th> <td><select name=language_code>$form->{selectlanguage}</select></td> <input type=hidden name=oldlanguage_code value=$form->{oldlanguage_code}> <input type=hidden name="selectlanguage" value="| . $form->escape( $form->{selectlanguage}, 1 ) . qq|"> </tr> |; } $form->{exchangerate} = $form->format_amount( \%myconfig, $form->{exchangerate} ); $exchangerate = qq|<tr>|; $exchangerate .= qq| <th align=right nowrap>| . $locale->text('Currency') . qq|</th> <td><select name=currency>$form->{selectcurrency}</select></td> | if $form->{defaultcurrency}; $exchangerate .= qq| <input type=hidden name=selectcurrency value="$form->{selectcurrency}"> <input type=hidden name=defaultcurrency value=$form->{defaultcurrency}> |; if ( $form->{defaultcurrency} && $form->{currency} ne $form->{defaultcurrency} ) { if ( $form->{forex} ) { $exchangerate .= qq| <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th> <td>$form->{exchangerate}<input type=hidden name=exchangerate value=$form->{exchangerate}></td> |; } else { $exchangerate .= qq| <th align=right nowrap>| . $locale->text('Exchange Rate') . qq|</th> <td><input name=exchangerate size=10 value=$form->{exchangerate}></td> |; } } $exchangerate .= qq| <input type=hidden name=forex value=$form->{forex}> </tr> |; if ( $form->{selectvendor} ) { $vendor = qq|<select name=vendor>$form->{selectvendor}</select> <input type=hidden name="selectvendor" value="| . $form->escape( $form->{selectvendor}, 1 ) . qq|">|; } else { $vendor = qq|<input name=vendor value="$form->{vendor}" size=35>|; } $department = qq| <tr> <th align="right" nowrap>| . $locale->text('Department') . qq|</th> <td colspan=3><select name=department>$form->{selectdepartment}</select> <input type=hidden name=selectdepartment value="| . $form->escape( $form->{selectdepartment}, 1 ) . qq|"> </td> </tr> | if $form->{selectdepartment}; $n = ( $form->{creditremaining} < 0 ) ? "0" : "1"; $i = $form->{rowcount} + 1; $focus = "partnumber_$i"; $form->header; print qq| <body onLoad="document.forms[0].${focus}.focus()"> <form method=post action="$form->{script}"> |; $form->{vc} = "vendor"; $form->hide_form( qw(id title vc type terms creditlimit creditremaining closedto locked shipped oldtransdate recurring) ); print qq| <table width=100%> <tr class=listtop> <th>$form->{title}</th> </tr> <tr height="5"></tr> <tr> <td> <table width=100%> <tr valign=top> <td> <table> <tr> <th align=right nowrap>| . $locale->text('Vendor') . qq|</th> <td colspan=3>$vendor</td> <input type=hidden name=vendor_id value=$form->{vendor_id}> <input type=hidden name=oldvendor value="$form->{oldvendor}"> </tr> <tr> <td></td> <td colspan=3> <table> <tr> <th nowrap>| . $locale->text('Credit Limit') . qq|</th> <td>| . $form->format_amount( \%myconfig, $form->{creditlimit}, 0, "0" ) . qq|</td> <td width=20%></td> <th nowrap>| . $locale->text('Remaining') . qq|</th> <td class="plus$n" nowrap>| . $form->format_amount( \%myconfig, $form->{creditremaining}, 0, "0" ) . qq|</td> </tr> </table> </td> <tr> <th align=right>| . $locale->text('Record in') . qq|</th> <td colspan=3><select name=AP>$form->{selectAP}</select></td> <input type=hidden name=selectAP value="$form->{selectAP}"> </tr> $department $exchangerate </table> </td> <td align=right> <table> <tr> <th align=right nowrap>| . $locale->text('Invoice Number') . qq|</th> <td><input name=invnumber size=20 value="$form->{invnumber}"></td> </tr> <tr> <th align=right nowrap>| . $locale->text('Order Number') . qq|</th> <td><input name=ordnumber size=20 value="$form->{ordnumber}"></td> <input type=hidden name=quonumber value="$form->{quonumber}"> </tr> <tr> <th align=right nowrap>| . $locale->text('Invoice Date') . qq|</th> <td><input name=transdate size=11 title="$myconfig{dateformat}" value=$form->{transdate}></td> </tr> <tr> <th align=right nowrap>| . $locale->text('Due Date') . qq|</th> <td><input name=duedate size=11 title="$myconfig{dateformat}" value=$form->{duedate}></td> </tr> <tr> <th align=right nowrap>| . $locale->text('PO Number') . qq|</th> <td><input name=ponumber size=20 value="$form->{ponumber}"></td> </tr> $lang </table> </td> </tr> </table> </td> </tr> |; $form->hide_form(qw(selectcurrency defaultcurrency taxaccounts)); for ( split / /, $form->{taxaccounts} ) { $form->hide_form( "${_}_rate", "${_}_description" ); } } sub form_footer { $form->{invtotal} = $form->{invsubtotal}; if ( ( $rows = $form->numtextrows( $form->{notes}, 35, 8 ) ) < 2 ) { $rows = 2; } if ( ( $introws = $form->numtextrows( $form->{intnotes}, 35, 8 ) ) < 2 ) { $introws = 2; } $rows = ( $rows > $introws ) ? $rows : $introws; $notes = qq|<textarea name=notes rows=$rows cols=35 wrap=soft>$form->{notes}</textarea>|; $intnotes = qq|<textarea name=intnotes rows=$rows cols=35 wrap=soft>$form->{intnotes}</textarea>|; $form->{taxincluded} = ( $form->{taxincluded} ) ? "checked" : ""; $taxincluded = ""; if ( $form->{taxaccounts} ) { $taxincluded = qq| <input name=taxincluded class=checkbox type=checkbox value=1 $form->{taxincluded}> <b>| . $locale->text('Tax Included') . qq|</b> |; } if ( !$form->{taxincluded} ) { my @taxset = Tax::init_taxes( $form, $form->{taxaccounts} ); foreach $taxobj (@taxset) { $item = $taxobj->account; $form->{invtotal} += $form->round_amount( $form->{"${item}_rate"} * $form->{"${item}_base"}, 2); $form->{"${item}_total"} = $form->format_amount( \%myconfig, $form->{"${item}_rate"} * $form->{"${item}_base"}, 2 ); if ( $form->{"${item}_base"} ) { $form->{"${item}_total"} = $form->format_amount( \%myconfig, $form->round_amount( $taxobj->value, 2 ), 2 ); $tax .= qq| <tr> <th align=right>$form->{"${item}_description"}</th> <td align=right>$form->{"${item}_total"}</td> </tr> |; } } $form->{invsubtotal} = $form->format_amount( \%myconfig, $form->{invsubtotal}, 2, 0 ); $subtotal = qq| <tr> <th align=right>| . $locale->text('Subtotal') . qq|</th> <td align=right>$form->{invsubtotal}</td> </tr> |; } $form->{oldinvtotal} = $form->{invtotal}; $form->{invtotal} = $form->format_amount( \%myconfig, $form->{invtotal}, 2, 0 ); print qq| <tr> <td> <table width=100%> <tr valign=bottom> <td> <table> <tr> <th align=left>| . $locale->text('Notes') . qq|</th> <th align=left>| . $locale->text('Internal Notes') . qq|</th> <th align=left>| . $locale->text('Import Text') . qq|</th> </tr> <tr valign=top> <td>$notes</td> <td>$intnotes</td> <td><textarea name=import_text rows=$rows cols=25></textarea> </tr> </table> </td> <td align=right> $taxincluded <br> <table> $subtotal $tax <tr> <th align=right>| . $locale->text('Total') . qq|</th> <td align=right>$form->{invtotal}</td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td> <table width=100%> <tr> <th colspan=6 class=listheading>| . $locale->text('Payments') . qq|</th> </tr> |; if ( $form->{currency} eq $form->{defaultcurrency} ) { @column_index = qw(datepaid source memo paid AP_paid); } else { @column_index = qw(datepaid source memo paid exchangerate AP_paid); } $column_data{datepaid} = "<th>" . $locale->text('Date') . "</th>"; $column_data{paid} = "<th>" . $locale->text('Amount') . "</th>"; $column_data{exchangerate} = "<th>" . $locale->text('Exch') . "</th>"; $column_data{AP_paid} = "<th>" . $locale->text('Account') . "</th>"; $column_data{source} = "<th>" . $locale->text('Source') . "</th>"; $column_data{memo} = "<th>" . $locale->text('Memo') . "</th>"; print qq| <tr> |; for (@column_index) { print "$column_data{$_}\n" } print qq| </tr> |; $form->{paidaccounts}++ if ( $form->{"paid_$form->{paidaccounts}"} ); for $i ( 1 .. $form->{paidaccounts} ) { $form->hide_form("cleared_$i"); print qq| <tr> |; $form->{"selectAP_paid_$i"} = $form->{selectAP_paid}; $form->{"selectAP_paid_$i"} =~ s/option>\Q$form->{"AP_paid_$i"}\E/option selected>$form->{"AP_paid_$i"}/; # format amounts $totalpaid += $form->{"paid_$i"}; $form->{"paid_$i"} = $form->format_amount( \%myconfig, $form->{"paid_$i"}, 2 ); $form->{"exchangerate_$i"} = $form->format_amount( \%myconfig, $form->{"exchangerate_$i"} ); $exchangerate = qq| |; if ( $form->{currency} ne $form->{defaultcurrency} ) { if ( $form->{"forex_$i"} ) { $exchangerate = qq|<input type=hidden name="exchangerate_$i" value=$form->{"exchangerate_$i"}>$form->{"exchangerate_$i"}|; } else { $exchangerate = qq|<input name="exchangerate_$i" size=10 value=$form->{"exchangerate_$i"}>|; } } $exchangerate .= qq| <input type=hidden name="forex_$i" value=$form->{"forex_$i"}> |; $column_data{"paid_$i"} = qq|<td align=center><input name="paid_$i" size=11 value=$form->{"paid_$i"}></td>|; $column_data{"exchangerate_$i"} = qq|<td align=center>$exchangerate</td>|; $column_data{"AP_paid_$i"} = qq|<td align=center><select name="AP_paid_$i">$form->{"selectAP_paid_$i"}</select></td>|; $column_data{"datepaid_$i"} = qq|<td align=center><input name="datepaid_$i" size=11 title="$myconfig{dateformat}" value=$form->{"datepaid_$i"}></td>|; $column_data{"source_$i"} = qq|<td align=center><input name="source_$i" size=11 value="$form->{"source_$i"}"></td>|; $column_data{"memo_$i"} = qq|<td align=center><input name="memo_$i" size=11 value="$form->{"memo_$i"}"></td>|; for (@column_index) { print qq|$column_data{"${_}_$i"}\n| } print qq| </tr> |; } $form->{oldtotalpaid} = $totalpaid; $form->hide_form(qw(paidaccounts selectAP_paid oldinvtotal oldtotalpaid)); print qq| </table> </td> </tr> <tr> <td><hr size=3 noshade></td> </tr> </table> <br> |; $transdate = $form->datetonum( \%myconfig, $form->{transdate} ); $closedto = $form->datetonum( \%myconfig, $form->{closedto} ); # type=submit $locale->text('Update') # type=submit $locale->text('Post') # type=submit $locale->text('Post as new') # type=submit $locale->text('Schedule') # type=submit $locale->text('Purchase Order') # type=submit $locale->text('Delete') if ( !$form->{readonly} ) { %button = ( 'update' => { ndx => 1, key => 'U', value => $locale->text('Update') }, 'post' => { ndx => 3, key => 'O', value => $locale->text('Post') }, 'post_as_new' => { ndx => 5, key => 'N', value => $locale->text('Post as new') }, 'purchase_order' => { ndx => 6, key => 'L', value => $locale->text('Purchase Order') }, 'schedule' => { ndx => 7, key => 'H', value => $locale->text('Schedule') }, 'delete' => { ndx => 8, key => 'D', value => $locale->text('Delete') }, ); if ( $form->{id} ) { if ( $form->{locked} ) { for ( "post", "delete" ) { delete $button{$_} } } } else { if ( $transdate > $closedto ) { for ( 'update', 'post', 'schedule' ) { $allowed{$_} = 1 } for ( keys %button ) { delete $button{$_} if !$allowed{$_} } } elsif ($closedto) { %buttons = (); } } for ( sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button ) { $form->print_button( \%button, $_ ); } } if ( $form->{lynx} ) { require "bin/menu.pl"; &menubar; } $form->hide_form(qw(rowcount callback path login sessionid)); print qq| </form> </body> </html> |; } sub import_text { my @o_list; my @i_lines = split( /(\n|\r|\r\n)/, $form->{import_text} ); foreach $i (@i_lines) { chomp($i); if ( $i ne "" ) { # Strip out blank lines push @o_list, $i; } } my $c = 1; my $linenumber = 0; foreach $l (@o_list) { if ( $c % 2 ) { $linenumber += 1; $form->{"partnumber_$linenumber"} = $l; } else { $form->{"qty_$linenumber"} = $l; } $c += 1; $form->{rowcount} = $linenumber; IR->retrieve_item( \%myconfig, \%$form ); $rows = scalar @{ $form->{item_list} }; $rows = 0 unless $rows; $i = $form->{rowcount}; if ( $rows = 0 ) { $form->{"id_$i"} = 0; $form->{"unit_$i"} = $locale->text('ea'); &new_item; } elsif ( $rows > 1 ) { &select_item; exit; } else { map { $form->{item_list}[$i]{$_} = $form->quote( $form->{item_list}[$i]{$_} ) } qw(partnumber description unit); map { $form->{"${_}_$i"} = $form->{item_list}[0]{$_} } keys %{ $form->{item_list}[0] }; $s = ($sellprice) ? $sellprice : $form->{"sellprice_$i"}; ($dec) = ( $s =~ /\.(\d+)/ ); $dec = length $dec; $decimalplaces = ( $dec > 2 ) ? $dec : 2; $amount = $form->{"sellprice_$i"} * $form->{"qty_$i"} * ( 1 - $form->{"discount_$i"} / 100 ); map { $form->{"${_}_base"} = 0 } ( split / /, $form->{taxaccounts} ); map { $form->{"${_}_base"} += $amount } ( split / /, $form->{"taxaccounts_$i"} ); if ( !$form->{taxincluded} ) { my @taxes = Tax::init_taxes( $form, $form->{taxaccounts} ); $amount += ( Tax::calculate_taxes( \@taxes, $form, $amount, 0 ) ); } $form->{creditremaining} -= $amount; $form->{"sellprice_$i"} = $form->format_amount( \%myconfig, $form->{"sellprice_$i"}, $decimalplaces ); $form->{"qty_$i"} = $form->format_amount( \%myconfig, $form->{"qty_$i"} ); } $form->{item_list} = []; } ++$form->{rowcount}; } sub update { if ( $form->{import_text} ) { &import_text; } $form->{exchangerate} = $form->parse_amount( \%myconfig, $form->{exchangerate} ); if ( $newname = &check_name(vendor) ) { &rebuild_vc( vendor, AP, $form->{transdate}, 1 ); } if ( $form->{transdate} ne $form->{oldtransdate} ) { $form->{duedate} = ( $form->{terms} ) ? $form->current_date( \%myconfig, $form->{transdate}, $form->{terms} * 1 ) : $form->{duedate}; $form->{oldtransdate} = $form->{transdate}; &rebuild_vc( vendor, AP, $form->{transdate}, 1 ) if !$newname; if ( $form->{currency} ne $form->{defaultcurrency} ) { delete $form->{exchangerate}; $form->{exchangerate} = $exchangerate if ( $form->{forex} = ( $exchangerate = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{transdate}, 'sell' ) ) ); $form->{oldcurrency} = $form->{currency}; } } if ( $form->{currency} ne $form->{oldcurrency} ) { delete $form->{exchangerate}; $form->{exchangerate} = $exchangerate if ( $form->{forex} = ( $exchangerate = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{transdate}, 'sell' ) ) ); } $j = 1; for $i ( 1 .. $form->{paidaccounts} ) { if ( $form->{"paid_$i"} ) { for (qw(datepaid source memo cleared)) { $form->{"${_}_$j"} = $form->{"${_}_$i"}; } for (qw(paid exchangerate)) { $form->{"${_}_$j"} = $form->parse_amount( \%myconfig, $form->{"${_}_$i"} ); } $form->{"exchangerate_$j"} = $exchangerate if ( $form->{"forex_$j"} = ( $exchangerate = $form->check_exchangerate( \%myconfig, $form->{currency}, $form->{"datepaid_$j"}, 'sell' ) ) ); if ( $j++ != $i ) { for (qw(datepaid source memo cleared paid exchangerate forex)) { delete $form->{"${_}_$i"}; } } } else { for (qw(datepaid source memo cleared paid exchangerate forex)) { delete $form->{"${_}_$i"}; } } $form->{paidaccounts} = $j; } $i = $form->{rowcount}; $exchangerate = ( $form->{exchangerate} ) ? $form->{exchangerate} : 1; for (qw(partsgroup projectnumber)) { $form->{"select$_"} = $form->unescape( $form->{"select$_"} ) if $form->{"select$_"}; } if ( ( $form->{"partnumber_$i"} eq "" ) && ( $form->{"description_$i"} eq "" ) && ( $form->{"partsgroup_$i"} eq "" ) ) { $form->{creditremaining} += ( $form->{oldinvtotal} - $form->{oldtotalpaid} ); &check_form; } else { IR->retrieve_item( \%myconfig, \%$form ); my $rows = scalar @{ $form->{item_list} }; if ( $form->{language_code} && $rows == 0 ) { $language_code = $form->{language_code}; $form->{language_code} = ""; IR->retrieve_item( \%myconfig, \%$form ); $form->{language_code} = $language_code; $rows = scalar @{ $form->{item_list} }; } if ($rows) { if ( $rows > 1 ) { &select_item; exit; } else { $form->{"qty_$i"} = ( $form->{"qty_$i"} * 1 ) ? $form->{"qty_$i"} : 1; $sellprice = $form->parse_amount( \%myconfig, $form->{"sellprice_$i"} ); for (qw(partnumber description unit)) { $form->{item_list}[$i]{$_} = $form->quote( $form->{item_list}[$i]{$_} ); } for ( keys %{ $form->{item_list}[0] } ) { $form->{"${_}_$i"} = $form->{item_list}[0]{$_}; } $form->{"discount_$i"} = $form->{discount} * 100; if ($sellprice) { $form->{"sellprice_$i"} = $sellprice; ($dec) = ( $form->{"sellprice_$i"} =~ /\.(\d+)/ ); $dec = length $dec; $decimalplaces = ( $dec > 2 ) ? $dec : 2; } else { ($dec) = ( $form->{"sellprice_$i"} =~ /\.(\d+)/ ); $dec = length $dec; $decimalplaces = ( $dec > 2 ) ? $dec : 2; $form->{"sellprice_$i"} /= $exchangerate; } $amount = $form->{"sellprice_$i"} * $form->{"qty_$i"} * ( 1 - $form->{"discount_$i"} / 100 ); for ( split / /, $form->{taxaccounts} ) { $form->{"${_}_base"} = 0; } for ( split / /, $form->{"taxaccounts_$i"} ) { $form->{"${_}_base"} += $amount; } if ( !$form->{taxincluded} ) { my @taxes = Tax::init_taxes( $form, $form->{"taxaccounts_$i"}, $form->{"taxaccounts"} ); $amount += ( Tax::calculate_taxes( \@taxes, $form, $amount, 0 ) ); } $form->{creditremaining} -= $amount; $form->{"sellprice_$i"} = $form->format_amount( \%myconfig, $form->{"sellprice_$i"}, $decimalplaces ); $form->{"oldqty_$i"} = $form->{"qty_$i"}; for (qw(qty discount)) { $form->{"{_}_$i"} = $form->format_amount( \%myconfig, $form->{"${_}_$i"} ); } } &display_form; } else { # ok, so this is a new part # ask if it is a part or service item if ( $form->{"partsgroup_$i"} && ( $form->{"partsnumber_$i"} eq "" ) && ( $form->{"description_$i"} eq "" ) ) { $form->{"discount_$i"} = ""; &display_form; } else { $form->{"id_$i"} = 0; $form->{"unit_$i"} = $locale->text('ea'); &new_item; } } } } sub post { $form->isblank( "transdate", $locale->text('Invoice Date missing!') ); $form->isblank( "vendor", $locale->text('Vendor missing!') ); # if the vendor changed get new values if ( &check_name(vendor) ) { &update; exit; } &validate_items; $closedto = $form->datetonum( \%myconfig, $form->{closedto} ); $transdate = $form->datetonum( \%myconfig, $form->{transdate} ); $form->error( $locale->text('Cannot post invoice for a closed period!') ) if ( $transdate <= $closedto ); $form->isblank( "exchangerate", $locale->text('Exchange rate missing!') ) if ( $form->{currency} ne $form->{defaultcurrency} ); for $i ( 1 .. $form->{paidaccounts} ) { if ( $form->{"paid_$i"} ) { $datepaid = $form->datetonum( \%myconfig, $form->{"datepaid_$i"} ); $form->isblank( "datepaid_$i", $locale->text('Payment date missing!') ); $form->error( $locale->text('Cannot post payment for a closed period!') ) if ( $datepaid <= $closedto ); if ( $form->{currency} ne $form->{defaultcurrency} ) { $form->{"exchangerate_$i"} = $form->{exchangerate} if ( $transdate == $datepaid ); $form->isblank( "exchangerate_$i", $locale->text('Exchange rate for payment missing!') ); } } } if ( !$form->{repost} ) { if ( $form->{id} ) { &repost; exit; } } ( $form->{AP} ) = split /--/, $form->{AP}; ( $form->{AP_paid} ) = split /--/, $form->{AP_paid}; if ( IR->post_invoice( \%myconfig, \%$form ) ) { $form->redirect( $locale->text( 'Invoice [_1] posted!', $form->{invnumber} ) ); } else { $form->error( $locale->text('Cannot post invoice!') ); } } sub delete { $form->header; print qq| <body> <form method=post action=$form->{script}> |; $form->{action} = "yes"; $form->hide_form; print qq| <h2 class=confirm>| . $locale->text('Confirm!') . qq|</h2> <h4>| . $locale->text( 'Are you sure you want to delete Invoice Number [_1]?', $form->{invnumber} ) . qq|</h4> <p> <button name="action" class="submit" type="submit" value="yes">| . $locale->text('Yes') . qq|</button> </form> |; } sub yes { if ( IR->delete_invoice( \%myconfig, \%$form ) ) { $form->redirect( $locale->text('Invoice deleted!') ); } else { $form->error( $locale->text('Cannot delete invoice!') ); } }