Sage 50: "The session date cannot be set into the new fiscal year
Sage 50 is blocking the move into your new fiscal year because the Retained Earnings account it closes the year into is missing or mislinked.
Sage 50 shows this message when you try to move your session date into a new fiscal year:
“The session date cannot be set into the new fiscal year because the linked account for Retained Earnings is improperly set.”
Despite the wording, the problem is almost never the date. When your session date crosses into a new fiscal year, Sage 50 closes the old year by emptying your income and expense accounts into a designated equity account, Retained Earnings. Before doing that, it checks that this “linked” account exists and is valid. That check is failing, so the program is refusing the year-end step, not the date itself.
Why it happens
- The Retained Earnings account was deleted, renamed, or renumbered at some point, so the link now points at nothing or at the wrong account.
- The account still exists but its class is no longer Equity, often after a spreadsheet import or a manual edit to the chart of accounts.
- The link points at an inactive account, or at a duplicate equity account created during an import or conversion.
- The company file’s internal account-link data is damaged, typically after a crash during a save, an interrupted restore, or a failed import.
Check the linked account setting
Sage 50 keeps its automatic posting accounts in a settings screen usually called Linked Accounts (some editions call these system or default accounts). It lists every account the program posts to on its own: Retained Earnings, and in most companies also accounts for things like sales tax and inventory. The exact route to that screen differs between the US and Canadian editions and between release years, so if you do not spot it right away, a search of the program’s help index for “linked accounts” takes you straight to it. Have other users log out first, since system settings often require exclusive access.
Find the Retained Earnings line. It should point at an existing account with an Equity class. If it is blank, or points at an account that is no longer in your chart of accounts, set it to a valid equity account, save, and try the session date again. In many cases this is all that was wrong.
Check the account itself
Open your chart of accounts and look at the Retained Earnings account:
- Confirm its class is Equity; some editions use a specific Retained Earnings class.
- Confirm it is active and has not been merged into another account.
- If it was deleted, create a new equity account for the role and point the link at it. Sage recalculates the Retained Earnings balance from your prior years, so compare the balance before and after to satisfy yourself nothing shifted.
If the settings look correct
When the link visibly points at a healthy equity account yet the message still appears, the account-link data inside the file is damaged, and no setting you can reach will repair it. Two sane options remain: restore a backup made before the problem first appeared, if the intervening work is small, or have the file examined. Our engineers deal with this kind of damage as part of our Sage 50 database repair service, and the evaluation is free, so you will know exactly what is broken before deciding anything.
Two things not to do: do not force the year through with manual journal entries to Retained Earnings, and do not delete and recreate accounts wholesale. Both add cleanup later without touching the underlying fault.
Until it is fixed
Keep the session date in the old fiscal year and hold off on new-year transactions where you can. Every transaction posted after a broken year-end close makes the eventual repair larger, and the fix itself is usually smaller than this message makes it look.