Invalid Date/Start Date Error Message

Solved

I am working on our year-end (Sage 50 Accountant Edition 2025.2) and am trying to adjust a posting in the Purchases Journal from June 2025.  Our year-end is July 31st and am now getting an error message that I can't access any posts prior to July 1, 2025 ("invalid date")??  How do I get around this because it makes no sense that I can't access any posts that older than 6 weeks ago!?

  • verified answer

    Under Setup, Settings, Company, System there is a setting to not allow transactions before a specific date.  Someone has turned this on to protect the previous month from inadvertent data entry or it was turned on during the transition to the new fiscal year to allow adjustments in July for year end.  It is possible this is done after each month's bank rec is completed to close the period.  

    If you are still making adjustments before sending the books to the accountant for year end tax preparation, then uncheck the box or change the date to Jun 1/25.  Then you can make adjustments any time in Jun or Jul.

    Once you send the books to the accountant, turn it back on to Aug 1/25.  I would also check with the person who set it up before just going ahead and changing the setting in case there is a specific reason it was set that is not evident.  There may be an alternate way to post the adjustment that the person would prefer.

  • 0 in reply to Richard S. Ridings

    Amazing.  Thanks Richard.  I suspect that is exactly what happened but the box is now unchecked so it won't be an issue going forward.

    I guess there is no way to get those pre-July 1st postings back to adjust, though?  I'm still getting the "Invalid date. The start date must be between July 1, 2025 and ___" error message when I try to look up a journal entry from May 2025.

  • 0 in reply to Sean Cowie

    What are the Clear settings under the Maintenance menu?

    Maintenance, Clear Data, Automatically Clear Data.  Are any checked?

    These settings will cause the program to remove the individual types of transactions checked when you transition to a new fiscal year.  I've never tested turning them on and using zero months as an option but if that is the case, when the file was transitioned to Aug, then it could have cleared everything up to the current period.  It sounds like your settings may be 1 month.

    Otherwise, you may have a scenario where the Last Cleared Date has been set but the data has not really been cleared.  I suspect this has happened to some users but I have never been given the opportunity to see a file to see if that really is the case.  If it is, it might be possible to restore the data, but only if it really exists.  The only way to tell for sure is to look inside the database.

  • 0

    I'm having log in issues after we do a year end roll over so we me and my partner can start working on Oct. 2025 my partner has full rights user as well but she's having this pop-up error " Invalid Date. The Session date must be between 2024-10-01 and 2025-10-01. for my side (I'm using the sysadmin) I don't get this error. We are using Sage 50 Premium Accounting 2025. Please help...