Via Sage KB:

One or more transactions were entered with an future or invalid date. To resolve this issue, please try the following:

Verify if future years exist in Fiscal Year Maintenance.

Open General Ledger, Setup, Fiscal year Maintenance.
Click look up in Fiscal Year field
Select the highest fiscal year listed
Verify the each periods ending date are correct

If future years exist, use the GLWURD utility to delete the future year transactions. See related article below, How to Delete Future Years and Transactions

If future years do not exist, please try creating one fiscal year prior to the earliest fiscal year defined. (ex. if the earliest fiscal year listed in fiscal year maintenance is 2001, create 2000 fiscal year)

Can't say I have ever seen this in the gl detail posting file before, but my usual trick is to run a report in ranges on the data and bracketing down on it. Try printing g/l detail reports year by year. When you find a year that errors out then narrow the months down and eventually the g/l accounts until you find it.

If that doesn't work, then try creating a crystal report on the gl_detailposting file and start bracketing in. Usually a bad date returns an error 9.

I usually find the Crystal Report option is fastest. Look at the record count when you get the error...

Thanks, everyone, for responding. Wayne, your answer was the correct one in this case. There were no future years, so I added a year at the beginning of the string of years (in Fiscal Year Maintenance). No more errors and the Recalculate Account Balances Utility successfully completed.

I have a client who has an odd month ending date,(the 25th) with the exception of the last month of the year. One year the last month ended on the 25th also. The new year started on the first of the month, so there were 11 days that did not fall in any year in Fiscal year maintenance and the same problem occurred. When they correct year end date was entered, those dates fell in a defined year and all was well.