From ad853136bb1ca4841c09a70379bbafbefe098fa5 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
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(-)

(limited to 'LedgerSMB')

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