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

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