# add entry for inventory, this one is for the sold item
if ($linetotal != 0) {
- $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
+ $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
transdate)
VALUES ($ref->{trans_id}, $ref->{inventory_accno_id},
$linetotal, '$ref->{transdate}')|;
$dbh->do($query) || $form->dberror($query);
# add expense
- $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
+ $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
transdate, taxkey)
VALUES ($ref->{trans_id}, $ref->{expense_accno_id},
- | . ($linetotal * -1) . qq|, '$ref->{transdate}',
+ | . ($linetotal * -1) . qq|, '$ref->{transdate}',
(SELECT taxkey from tax WHERE chart_id = $ref->{expense_accno_id}))|;
$dbh->do($query) || $form->dberror($query);
}
if ($form->{"projectnumber_$i"}) {
$project_id = $form->{"projectnumber_$i"};
}
- print(STDERR $project_id, " Project_id\n");
$deliverydate =
($form->{"deliverydate_$i"})
? qq|'$form->{"deliverydate_$i"}'|
'$form->{"unit_$i"}', $deliverydate, (SELECT id FROM project WHERE projectnumber = '$project_id'),
'$form->{"serialnumber_$i"}')|;
$dbh->do($query) || $form->dberror($query);
- print(STDERR $query, "\n\n");
}
}
$form->round_amount($form->{amount}{$trans_id}{$accno}, 2)
) != 0
) {
- $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
+ $query = qq|INSERT INTO acc_trans (trans_id, chart_id, amount,
transdate, taxkey)
VALUES ($trans_id, (SELECT c.id FROM chart c
WHERE c.accno = '$accno'),
$contact = "and cp.cp_id = $form->{cp_id}";
}
- $taxincluded = $form->{taxincluded};
-
# get rest for the vendor
# fax and phone and email as vendor*
my $query =
$sth->execute || $form->dberror($query);
$ref = $sth->fetchrow_hashref(NAME_lc);
- map { $form->{$_} = $ref->{$_} } keys %$ref;
- $form->{taxincluded} = $taxincluded;
+ # remove id and taxincluded before copy back
+ delete @$ref{qw(id taxincluded)};
+ map { $form->{$_} = $ref->{$_} } keys %$ref;
$sth->finish;
$dbh->disconnect;
}
1;
-