Where are Posting Accounts set up for Multicurrency and what tables are they held in?
The system will search for Multicurrency Posting Accounts in the following order:
1. Posting Accounts assigned to the Rate Type (Setup-Financial-Rate Types)
2. Posting Accounts assigned to the Currency (Setup-System-Currency)
3. Posting Accounts assigned in Posting Accounts Setup (Setup-Posting-Posting Accounts)
In Select Multicurrency Rate Types (Setup-Financial-Rate Types), the posting accounts are held in the MC40301.
In Currency Setup (Setup - System - Currency - Accounts), even though the accounts are set up at the system level, they are stored on a per company basis in the finance folder. The table number is MC40201.
The Posting Accounts Setup (Setup-Posting-Posting Accounts) under the Financial Series will hold posting accounts for Multicurrency. The table that holds the information is the SY01100.
This article was TechKnowledge Document ID: 1006
MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE.
THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.