$form->{AR_amounts}{"amount_$i"} =
(split(/--/, $form->{"AR_amount_$i"}))[0];
}
- ($form->{AR_amounts}{receivables}) = split(/--/, $form->{ARselected});
- ($form->{AR}{receivables}) = split(/--/, $form->{ARselected});
+ $form->{AR_amounts}{receivables} = $form->{ARselected};
+ $form->{AR}{receivables} = $form->{ARselected};
$form->{exchangerate} =
($exchangerate)
$query = qq|INSERT INTO ar (id, invnumber, employee_id) VALUES (?, 'dummy', ?)|;
do_query($form, $dbh, $query, $form->{id}, $form->{employee_id});
+
+ if (!$form->{invnumber}) {
+ $form->{invnumber} = $form->update_defaults($myconfig, "invnumber", $dbh);
+ }
}
# update department
$form->get_exchangerate($dbh, $form->{currency}, $form->{transdate},
"buy");
- my ($accno_ar) = split(/--/, $form->{ARselected});
+ my $accno_ar = $form->{ARselected};
# record payments and offsetting AR
for my $i (1 .. $form->{paidaccounts}) {
my @a = (transdate, invnumber, name);
push @a, "employee" if $form->{l_employee};
my $sortorder = join(', ', @a);
- $sortorder = $form->{sort} if ($form->{sort} && grep({ $_ eq $form->{sort} } @a));
+
+ if (grep({ $_ eq $form->{sort} }
+ qw(id transdate duedate invnumber ordnumber name
+ datepaid employee shippingpoint shipvia))) {
+ $sortorder = $form->{sort};
+ }
$query .= " WHERE $where ORDER by $sortorder";