Sage 50: "You cannot use a foreign currency with a linked control account
Sage 50 blocks foreign currency on accounts it posts to automatically, such as A/R and A/P; the linked account must stay in home currency.
“You cannot use a foreign currency with a linked control account.” Sage 50 (sold as Peachtree in the US and Simply Accounting in Canada) shows this when you try to give a foreign currency to an account the program posts to automatically, or when you try to designate a foreign-currency account as one of those linked accounts. It is a design rule, not a sign of damage: control accounts such as accounts receivable, accounts payable, payroll, sales tax, and retained earnings must stay in your home currency, because Sage 50 balances them itself and cannot reconcile an automatic posting against a moving exchange rate.
Why it happens
- You edited an account’s currency while it is still designated as a linked account in your settings.
- You opened the linked accounts settings and picked an account that already carries a foreign currency.
- You turned multicurrency on, or are reorganizing the chart of accounts around it, and are moving currencies onto accounts that are still linked.
- The message appeared after an import or conversion that mapped a foreign-currency account into a control account slot.
Undo the change first
The safest fix is the one that changes the least. Set the account back to the home currency, or choose a different home-currency account for the link, and save. If you were mid-edit when the message appeared, closing the window without saving is often enough. Nothing has usually gone wrong with your data at this point; Sage 50 refused the combination before anything was written.
If the account really must be foreign currency
Unlink it first. Remove it from the linked accounts settings (the exact window and labels depend on your edition), put a home-currency account in its place, and only then change its currency. Be aware that receivable and payable control accounts can never be foreign: foreign-currency customers and vendors are handled at the customer and vendor level, with exchange differences flowing to your currency gain and loss accounts. So if the goal is a US dollar receivable, the structure is a home-currency control account plus customers set to the foreign currency, not a foreign-currency control account. Bank accounts are the common exception: a foreign-currency bank account is fine as long as it is not serving as a linked control account.
If the message appears on its own
If you see this when opening the file, or repeatedly without touching any currency setting, the links between your settings and the chart of accounts are inconsistent. Restore a backup made before the change if you have one. If the message arrived after an import or a conversion, the account mapping needs correcting and the import retrying; the right fix depends on how the file was mapped, which varies from file to file.
When the file needs professional attention
If the setting will not clear, the message loops, or the chart of accounts is half-reorganized and the file refuses to save either way, the link data inside the file needs repair rather than more settings changes. Our engineers do this kind of Sage 50 database repair regularly, and we can examine your file and give a free evaluation and quote before you commit to anything.
Next step
Before making further changes, note which account triggered the message and what you altered immediately before it appeared. That one detail usually identifies which of the fixes above applies, and it makes any discussion with us, or with your accountant, much shorter.