AnsweredAssumed Answered

Project labor_actsum totals issue

Question asked by picis on May 10, 2012
Latest reply on May 11, 2012 by Dave
Looking for some help.

One of my projects is showing incorrect total Actual hours. At the beginning of April, a project had 10,349.11 actual hours. Throughout April, an additional 233 hours posted, which should have brought my total Actuals to 10,582.11. The project is showing 10,530.61 (delta of 51.50 hrs). I drafted a SQL query to check the SLICES (monthly), and totaled up the hours from project inception to the end of April, and it is reflecting the correct # (10,582.11). What could be causing the inv_investments.labor_actsum field to display the incorrect value (short 51.50 hours)? I ran the time-slice, and re-sliced the project, but it's still not adding up correctly. All the resources are tagged as "Labor". I checked to make sure I didn't have any "adjusted" timesheets that may have caused an unexpected issue. What populates the inv_investments.labor_actsum field, and/or what could be causing it to not be capturing all of the actual hours?

Thanks,
- Mark


inv_investments.labor_actsum = 10530.61

Monthly Slice Details:
Project..Month..........totalhours
289......7/1/2009.......94.75
289......8/1/2009.......260.25
289......9/1/2009.......404
289......10/1/2009......226.77
289......11/1/2009......281.42
289......12/1/2009......266
289......1/1/2010.......389.25
289......2/1/2010.......414.25
289......3/1/2010.......456
289......4/1/2010.......401
289......5/1/2010.......386.5
289......6/1/2010.......448.75
289......7/1/2010.......950.35
289......8/1/2010.......580.4
289......9/1/2010.......825.65
289......10/1/2010......422
289......11/1/2010......569.5
289......12/1/2010......448.85
289......1/1/2011.......621.25
289......2/1/2011.......143.75
289......3/1/2011.......199.25
289......4/1/2011.......62.5
289......5/1/2011.......183
289......6/1/2011.......208.5
289......7/1/2011.......103.67
289......8/1/2011.......91
289......9/1/2011.......86
289......10/1/2011......108
289......11/1/2011......150.5
289......12/1/2011......96
289......1/1/2012.......265
289......2/1/2012.......108.5
289......3/1/2012.......96.5
289......4/1/2012.......233
.............................10582.11

Outcomes