From ad853136bb1ca4841c09a70379bbafbefe098fa5 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Sun, 24 Feb 2008 03:21:47 +0000 Subject: Correcting inventory report bug which uses duedate instead of invoice date git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2081 4979c152-3d1c-0410-bac9-87ea11338e46 --- LedgerSMB/RP.pm | 4 ++-- 1 file 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} ) { -- cgit v1.2.3