Annual Budget Worksheet report incorrect.
Posted: Mon Nov 01, 2004 5:08 pm
Have just started using the 10/12/04 release of V9.0. I wonder if anyone else has had the problem of getting incorrect amounts under the 'actual' and 'Budget' columns on the Annual Budget Worksheet report. I suspect if your fiscal year is Jan-Dec you won't see a problem. Our fiscal year runs Oct-Sept, but the amounts in the mentioned columns seem to be correct if you use our data that runs from Jan-Dec. When printing for the fiscal year ending Sept 2004, the amounts under the actual column are equal to the fiscal year amount minus the sum of Oct 2003-Dec 2003. The amount under the 2004 budget column equals the Jan-Sept 2004 budget amounts added to the first quarter fiscal year 2005 monthly budget amounts (Oct-Dec 2004). Under the 2005 budget column, the amount is only for 9 months of the 2005 fiscal year. When I put those same budget numbers into the first 3 months of the 2006 fiscal year budget, Oct-Dec 2005, then I do get the correct FY 2005 budget numbers in that column, which seems to prove to me the report is running Jan - Dec rather than the fiscal year starting in Oct. If I run the Budget Worksheet Report which prints the monthly amounts (and is a lot more pages), that does come out correct for our fiscal year, but I would rather work with the more abreviated annual budget worksheet if it would work correctly.