diff options
| -rwxr-xr-x | LedgerSMB/RP.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/LedgerSMB/RP.pm b/LedgerSMB/RP.pm index 320e6a32..5d15bf6a 100755 --- a/LedgerSMB/RP.pm +++ b/LedgerSMB/RP.pm @@ -48,12 +48,12 @@ sub inventory_activity { my $where = ''; if ( $form->{fromdate} ) { $where .= - "AND coalesce(ar.duedate, ap.duedate) >= " + "AND coalesce(ar.transdate, ap.transdate) >= " . $dbh->quote( $form->{fromdate} ); } if ( $form->{todate} ) { $where .= - "AND coalesce(ar.duedate, ap.duedate) < " + "AND coalesce(ar.transdate, ap.transdate) < " . $dbh->quote( $form->{todate} ) . " "; } if ( $form->{partnumber} ) { |