From 7581a6dd497780979eeebeb4d70b76477c23441e Mon Sep 17 00:00:00 2001
From: mark <mark>
Date: Tue, 1 Jun 2010 17:40:33 +0000
Subject: [PATCH] RT#8460: monthly opening balance

---
 httemplate/search/h_inventory_item.html | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

diff --git a/httemplate/search/h_inventory_item.html b/httemplate/search/h_inventory_item.html
index 2ac00651c..38e5b95e7 100644
--- a/httemplate/search/h_inventory_item.html
+++ b/httemplate/search/h_inventory_item.html
@@ -51,9 +51,17 @@ my @labels = (
   'Closing Balance',
 );
 my @rows = ( map {[ (0) x $numdays ]} @labels);
+my $opening_balance = scalar(
+  qsearch('h_inventory_item', 
+          { 'svcnum' => '',
+            ($classnum ? ('classnum' => $classnum) : () ) },
+          FS::h_inventory_item->sql_h_search($sdate) )
+  ) || 0;
 
 foreach my $day (0..$numdays-1) {
-  $rows[0][$day] = $rows[4][$day-1] if($day > 0);
+  $rows[0][$day] = ($day == 0) ? 
+                    $opening_balance : 
+                    $rows[4][$day-1];
 
   my %history;
   foreach my $action (qw(insert replace_new replace_old)) {
-- 
2.11.0