I am getting this error because Company B changed their fiscal year end, and now fiscal year 2006 only has one period.
Now my consolidated FRx reports don't work because if I am reporting on January 31, this is fiscal year end for Company A and C, period 12.
So my report column layout has to show 12 periods for each company. Company A and C are periods 1 thru 12 for fiscal year 2006. Company B is period 2 thru 12 for fiscal 2005 and period 1 for fiscal 2006.
Because there is no period 2 thru 12 for 2006 for company B, I get this error. I cannot set up these periods because Feb06 is period 1 of fiscal 2007 (for all three companies).
Normally I would create 12 periods, even though only one was used, but because we had to use the same database for this company, it's all messed up.
Does anyone know how to get around this error? Our vendor has no idea.
thanks
Now my consolidated FRx reports don't work because if I am reporting on January 31, this is fiscal year end for Company A and C, period 12.
So my report column layout has to show 12 periods for each company. Company A and C are periods 1 thru 12 for fiscal year 2006. Company B is period 2 thru 12 for fiscal 2005 and period 1 for fiscal 2006.
Because there is no period 2 thru 12 for 2006 for company B, I get this error. I cannot set up these periods because Feb06 is period 1 of fiscal 2007 (for all three companies).
Normally I would create 12 periods, even though only one was used, but because we had to use the same database for this company, it's all messed up.
Does anyone know how to get around this error? Our vendor has no idea.
thanks