3125401 - Migrate Open Items Receivable/Payable With more Than Two Currencies - Currency Missing but Needed in Set of Books

Your company works with several, for example, three different set of books or more, all of which are using different currencies.

When migrating Open Items Payable or Receivable an error message is reported during Import Simulation: "Currency XYZ missing but needed in set of books XXXX, company ABC" (XYZ represents the missing currency, XXXX represents the set of books using currency XYZ, ABC represents the company using set of books XXXX).

SAP Business ByDesign

1. Enter the Migration of Accounting Transaction data activity in the Business Configuration work center.  
2. Access the Migrate accounting transaction data using the migration tool link. 
3. Select the respective migration unit and press Execute Migration.
4. In the Open Items Receivable/Payable migration object you maintain open items with three different currencies, such as transaction currency, company currency and second company currency. 
5. In step 1c - Process File - Simulate import the import simulation is not successful and finishes with the error "Currency XYZ missing but needed in set of books XXXX, company ABC", 

Currently it is only supported to migrate two different currencies for the migration of Open Items in accounting.

It is possible to migrate open items for more than two currencies applying the following workaround:

1. Maintain the Open Items with the three currencies allowed in the file: Transaction currency DEF, Company Currency GHI, Second Company Currency XYZ (DEF and GHI represent two further currencies used by two different set of books). 
2. Ensure that there are historical exchange rates present in your system, valid on the Migration Posting Date, for all currencies involved. 
3. Send an incident to the SAP Cloud Product Support with written approval to apply a temporary code change from the backend that allows the migration of open items with more than two currencies.
4. Once the migration is completed the code change must be reverted back. 

migration open items receivable, open items payable, currency missing but needed in set of books, Migration of Accounting, Payable, Receivable, Open Item, Currency, Multiple Currencies. , KBA , ap migration , ar migration , SRD-FIN-ACP , Payables , How To