X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIR.pm;h=30f49fd7c6f7bb47da723aff694a6fbbaf7a85b0;hb=0a4891e33e1ee05dd0363d985fb1a2205e25c63c;hp=1d4b9034836588760b3795cb0d48c8af8cc06369;hpb=b6dc5623d93c1be1c54248d4512e80f495af2899;p=kivitendo-erp.git diff --git a/SL/IR.pm b/SL/IR.pm index 1d4b90348..30f49fd7c 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -178,8 +178,6 @@ sub post_invoice { @values = ($form->{"sellprice_$i"}, conv_i($form->{"id_$i"})); do_query($form, $dbh, $query, @values); - $form->update_balance($dbh, "parts", "onhand", qq|id = ?|, $baseqty, $form->{"id_$i"}) if !$form->{shipped}; - # check if we sold the item already and # make an entry for the expense and inventory $query = @@ -572,9 +570,6 @@ sub reverse_invoice { next unless $ref->{inventory_accno_id}; - # update onhand - $form->update_balance($dbh, "parts", "onhand", qq|id = $ref->{parts_id}|, $ref->{qty}); - # if $ref->{allocated} > 0 than we sold that many items next if ($ref->{allocated} <= 0); @@ -814,7 +809,6 @@ sub get_vendor { my ($self, $myconfig, $form, $params) = @_; $params = $form unless defined $params && ref $params eq "HASH"; - $main::lxdebug->message(0, Dumper($params)); # connect to database my $dbh = $form->dbconnect($myconfig); @@ -842,7 +836,7 @@ sub get_vendor { } my $query = qq|SELECT - v.id, v.name AS vendor, v.creditlimit, v.terms, v.notes AS intnotes, + v.name AS vendor, v.creditlimit, v.terms, v.notes AS intnotes, v.email, v.cc, v.bcc, v.language_id, v.payment_id, v.street, v.zipcode, v.city, v.country, v.taxzone_id, $duedate + COALESCE(pt.terms_netto, 0) AS duedate, @@ -1058,6 +1052,8 @@ sub retrieve_item { $stw->finish(); chop $ref->{taxaccounts}; + $ref->{onhand} *= 1; + push @{ $form->{item_list} }, $ref; } @@ -1109,6 +1105,11 @@ sub vendor_details { map { $form->{$_} = $ref->{$_} } keys %$ref; + my $custom_variables = CVar->get_custom_variables('dbh' => $dbh, + 'module' => 'CT', + 'trans_id' => $form->{vendor_id}); + map { $form->{"vc_cvar_$_->{name}"} = $_->{value} } @{ $custom_variables }; + $dbh->disconnect(); $main::lxdebug->leave_sub();