Further testing indicates that for some reason, when you first create the report and run it - the FiscalPeriod(date) works (i.e. is loaded by Crystal) - however, after exiting Crystal Reports for Adagio then coming back in and trying to print the report, it fails (i.e. the function is not being re-loaded). BTW, this problem exists for the other Fiscal functions that are specific to Adagio/ACCPAC Plus reporting from Crystal Reports 8.5 for Adagio - it is not just the FiscalPeriod(date) function.

When it works, you should be able to see the function listed under the heading 'Additional Functions' in Crystal Reports for Adagio. Notice that when it gives you errors, the function does not appear in this list any longer...the big question is why?!

For now, R&D is looking into it. I do not know when they will have a resolution - however, there are other ways to get the information you want. Please refer to the original post that we replied to you with - some examples were listed that you can use to work around this problem for now.

(i.e. For example, if you want columns on your report for specific fiscal periods, you could custom design some formulas to accomodate this. For example, if your Fiscal Calendar is June 1 through May 31, your formulas would look something like this:

For your fiscal period 12 (May, 2002):
if Month(date) in 5 to 5 and Year(date)= 2002 then amount

You can then format the formula field to 'suppress if 0' to clean up the report.)

Once again, thank you for reporting this.