Error: "Currency is not defined in Common Services." when posting Sage 300 Accounts Payable Checks.
Summary
When posting AP Payment checks the error:
“Currency is not defined in Common Services.” or “Currency conversion failed.” occurs.
Disclaimer
Database Warning
These steps require knowledge of database engines and application databases (DBs) used by your Sage product (including Microsoft/Transact SQL, Pervasive SQL, or MySQL, etc.). Customer Support is not responsible for assisting with these steps and cannot be responsible for errors resulting from changes to the database engine or DBs. Before making changes, backup all system and application DBs required for a full restore. Contact an authorized business partner or DB administrator for assistance.
Cause
Missing Currency Rate value in transactions
Possible Resolution
It is about the Tax reporting Currency Code CODECURNRC
Use with caution, and usual backups on single currency companies. Change the ‘XXX’ to match Functional Currency of the Company:
UPDATE APTCR SET CODECURNRC=’XXX’ WHERE CODECURNRC=”UPDATE APOBL SET CODECURNRC=’XXX’ WHERE CODECURNRC=”