From 55c970993842bbd97c28443558452cf896a29e86 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Sun, 24 Feb 2008 03:22:35 +0000 Subject: Merging inventory report fix from branches/1.2 git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2082 4979c152-3d1c-0410-bac9-87ea11338e46 --- LedgerSMB/RP.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'LedgerSMB') diff --git a/LedgerSMB/RP.pm b/LedgerSMB/RP.pm index 40bc3d08..9c937bf6 100644 --- 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} ) { -- cgit v1.2.3