If you can give us a clue as to what is happening when you use the FiscalPeriod date function, I'm sure we can give you a clue as to why you are having problems!

Please tell us what the exact syntax of your formula is as it exists in Crystal Reports for Adagio.

What is the exact error message you are getting, and at what exact point does it occur? (i.e. when you first open the report or when you print the report - or ??)

Do you have the date field inserted in the detail area of your report?

What is the table name are you using to report on your GL data with? Are you using Adagio Ledger or ACCPAC Plus?

Thank you - regards,

Thought I would update you as well....

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.)

Thank you for reporting this.