Symptom
After the migration of inventories the opening balance of some inventories was found to be incorrect because of wrong file/incomplete file used for migration.
However, there is no option available to reverse the migration.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to General Ledger work center.
- Select Journal Entries view under Journal Entries.
- Filter with Journal Entry Type Data Migration, Related Source Document Type Goods and Activity Confirmation and locate the posting in question
Incorrect balances are observed for some materials; however, there is no available option to reverse the migration.
Or
- Go to Business Configration work center.
- Select Implementation Projects view.
- Search and Open the migration activity Migration of Accounting Transaction Data.
- Click Migration accounting transaction data using the migration tool.
The already migrated units do not have an option to perform a reverse migration.
Cause
This functionality of directly reversing migrated inventories is not available in the current release of SAP Business ByDesign.
Resolution
Direct reversal of the migration is not supported. To adjust the inventory balances affected by incorrect quantity selection, re-migration can be performed using adjustment stock.
Here, adjustment stock means that if 3 quantities were entered during the original migration, the same material should now be entered with a quantity of -3. This will eventually nullify the balance in the relevant inventory account, as the value is being entered as negative stock.
Keywords
KBA , SRD-FIN-GL , General Ledger , How To
SAP Knowledge Base Article - Public