SAP Knowledge Base Article - Public

2812731 - Posted Amount Differs From Cross-Check Balances Amount in Inventory Migration

Symptom

When you are checking inventory migration Cross-Check Balances, you see that the Inventory G/L account balance is aaa.bb ZZZ(aaa.bb represents the cross-check balance amount, ZZZ represents the currency). After successful import, you check the balance in the general ledger and find that the inventory G/L account balance is aaa.cc ZZZ(aaa.cc represents the posted amount, ZZZ represents the currency).

For example, you're migrating inventory of material ABC(ABC represents the material ID). Material ABC is Moving Average. Material unit cost is 141856.19 CNY/ 10000 EA.

In the migration file, you entered two lines for the material ABC. One line is 45 EA and one line is 165 EA.

The Cross-Check Balances is 2,978.98 CNY, however, the posted amount is 2,978.97 CNY.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Configuration work center.
  2. Go to Overview view.
  3. Search and open activity Migration of Accounting Transaction Data.
  4. Click on Migrate accounting transaction data using the migration tool.
  5. Select inventory migration relevant title and click on Cross-Check Balances Preview.
  6. You see the balance of Inventroy G/L account is 2,978.98 CNY.
  7. Go to General Ledger work center.
  8. Go to General Ledger Accounts view.
  9. Input required parameters to search out the Inventroy G/L account balance, you see the Account Balance is 2,978.97 CNY.

Cause

When the migrated material uses the Moving Average perpetual cost method and the material in the migration file has multiple rows of data, amounts will be different due to rounding.

If you check the inventory cost history for material ABC you will see that the migration to inventory happens in two steps. First 45 EA is capitalized at a cost rate of 14.185619 (141856.19 CNY/ 10000 EA) which leads to a capitalization of 638.35 CNY after rounding. Now as the costing method is moving average, the new cost rate becomes 638.35 / 45 = 14.185556. Hence the next 165 ea is capitalized at this new cost rate leading to a capitalization of 165 * 14.185556 = 2340.62 after rounding. Therefore, the resulting posted amount is 638.35+2340.62=2978.97 CNY.

In the migration simulation, the system only calculated the total amount according to the inventory cost 14.185619 before posting 45 EA. Therefore, Cross-Check Balances amount is (45+165)*14.185619=2978.98 CNY.

This is leading to the rounding difference.

Resolution

System behaves as designed. You can try to combine the data of the same material on one line to avoid rounding difference.

Keywords

Inventory migration , KBA , SRD-FIN-INV , Inventory , How To

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP BUSINESS BYDESIGN 1911 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802 ; SAP Business ByDesign 1805 ; SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902 ; SAP Business ByDesign 1905 ; SAP Business ByDesign 1908 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0