We're implementing PC version 2.5, and after several months of messing around in our sandbox, I'm still struggling with how timeframes work, particularly with our fiscal calendar. Our year is 52 or 53 weeks, with months assigned 4 or 5 weeks in a 4-5-4 pattern. In addition, the first month of the year is Feb, so months 11 & 12 (Dec & Jan) cross over to the next "standard" calendar year.
I have no trouble setting up one year of customized year/month/quarter timeframes, but I'd really like to define several years in advance, and I can't figure out how to do it. Because each month begins and ends on a different date each year (ex. Apr 2009 goes from 4/5 to 5/2, while Apr 2010 goes from 4/4 to 5/1), I've concluded that I must define a unique timeframe for every month/year combination. Unfortunately, when I schedule an automatic control for a year, the job log displays a line for every month defined -- I defined 2 full fiscal years and have 23 lines (one prior year's month fell outside the current year's month/day boundaries).
Does anyone here have a suggestion on how I can define these calendars? Can I tie a set of months to a specific year? Or, will I have to annually create the next year and delete the last?
Thanks, in advance, for your consideration.
Jeff