We have identified a bug with the Job Summary – Project at YTD Actual (PA300c) report that occurs in sites using the Indirect Rate Calculator. This wasn’t an issue the first year using Indirect Rate Calculator, but beginning the next year we noticed inconsistent indirect rates for several projects.
The PA300c report uses a subreport called IC_Data to display the rates and amounts. IC_Data is using a stored procedure called PJvICprojYTD. This stored procedure calculates the rate as the average of rates from a view called PJvYTDSummary for the period and year being reported. PJvYTDSummary is pulling the data from PJYTDAIC and the records in that table have the correct rate – when there is data. If a task had activity in the previous year, but did not have any activity in 01-2015 (for example), then a rate of 0.00% is being included in the average. This will cause the rate on the PAC300c report to display a lower percentage than what was calculated with Indirect Rate Calculator.
This was fixed in SL 2015 CU2 (Bug #35488), but we have been able to update the view, in previous versions, to ensure the PA300c report prints the correct rate. Please contact us if you need assistance with this temporary fix.