SAP Knowledge Base Article - Preview

2712069 - Values Migrated to the Wrong Customer Accounts


You have migrated Accounts Payables and Accounts Receivable, however you noticed that it was posted to the wrong Master Data Record.

 E.g.: You have a migration file for the following Customer Numbers and Customer Names:

10 Customer A

20 Customer B

30 Customer C


When you migrated it to the system, the system has renumbered to the following numbers:

10 Customer D (a customer that was manually added before the import)

20 Customer A

30 Customer B

40 Customer C


Then, when you imported AR/AP, you changed the file to reflect the Customer IDs that the system used:

10 Customer D open $100

20 Customer A open $105

30 Customer B open $110

40 Customer C open $115


The migration of Open AR/AP looked up the numbers on the original migration template and it got posted to the original customer from the file, and hence the following behavior occurs:

 Customer D $100 posted to Customer Account A

Customer A $105 posted to Customer Account B

Customer B $110 posted to Customer Account C

Customer C $115 posted to Customer Account C, because there was no 40 in the original import file.



SAP Business ByDesign


SAP Business ByDesign all versions


Customer Accounts, Migration, External IDs, Accounts Payable, Accounts Receivable, Data Import, Master Data Records, Migration Tool, Account ID. , KBA , SRD-FIN-GL , General Ledger , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.