2082409 - Exception After Migrating Inventory - Cross Check Balances Preview for Migration

SAP Knowledge Base Article - Public

2082409 - Exception After Migrating Inventory - Cross Check Balances Preview for Migration

Symptom

You have migrated Inventory. The migration finished successfully but you notice via the Material Inventories - Balance History that the inventories are not updated.
You then check the Cross-Check Balances Preview of the migration unit and notice an exception message for each migrated material: Exception occurred.

Reproducing the Issue

  1. In Business Configuration navigate to the Activity List of your current project and there go to the Integrate and Extend phase.
  2. Open the Migration of Accounting Transaction Data activity and click on the link Migrate accounting transaction data using the migration tool.
  3. In the new screen in the top table select the respective migration unit. Its status is Finished. Also the status of the Inventory migration file in the table below is in status Finished.
  4. In the Inventory Valuation workcenter navigate to the Reports- List view and open the Material Inventories - Balance History report.
  5. Enter all the mandatory fields and press Go.
  6. You notice that the inventories are not updated according to the apparently finished migration.
  7. Go back to the migration and select your migration unit.
  8. Press on the Cross-Check Balances Preview button.
  9. There are entries visible for which no G/L account or local currency (LC) amount is displayed. Open these entries by clicking on the small downwards pointing arrow.
  10. Now you can see several lines reporting an exception in the Messages column.
  11. In the Source column click on the Inventory link to check the posting details.
  12. In the new screen you can again see entries without G/L account and a 0,00 LC amount. Click on the downwards pointing arrow to check for which materials the inventory cost is missing. You find the material IDs in the Product ID column.
  13. Then open all the other G/L accounts.
  14. In the Messages tab there is an exception reported for each material: Exception occurred.

 

Cause

As the posting preview suggests you have tried to migrate inventory values of 0,00 LC. But the value updating of inventory is based on material valuation data, meaning, the account determination as well as the inventory cost data valid on the migration posting date.
As for some materials there was no inventory cost maintained an exception was raised for all materials. The migration could be finished and a Goods and Service Confirmation was created. The document, however, could not be posted to accounting and appears as unposted source document in the Closing Cockpit of the General Ledger workcenter.

Resolution

  1. In the Inventory Valuation workcenter navigate to Master Data - Materials.
  2. Find the materials for which a 0,00 LC amount is displayed in the posting preview of the Inventory migration.
  3. Select the material and press Maintain Valuation Data.
  4. Maintain an inventory cost for the materials and make sure that this entry is valid on the date of the inventory migration.

After all the affected material valuation data are updated navigate to General Ledger and there to Closing Cockpit - Source Documents

  1. Find the unposted Goods and Activity Confirmation with status In Process.
  2. In the Messages section the missing value is reported: No value of subtransaction company , setofbooks ABC, BO out FIA_MATERIAL_LEDGER_ACCT, BO in FIA_GL_ACCOUNT.
  3. Press Actions- Post Business Transaction.

Once the posting is completed validate the now fully completed migration in the Material Inventories - Balance History report:

  1. In the Inventory Valuation workcenter navigate to the Reports- List view and open the Material Inventories - Balance History report.
  2. Enter all the mandatory fields and press Go.
  3. The inventory values are updated.

 

Keywords

KBA , AP-PRP , Purchase Request Processing , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502