Skip to Content

Adjust Migrated Opening Balance After Entry of Transactions

Dear SAP Business ByDesign Experts,

If I already migrated opening balance and started entering transactions at the first fiscal period (e.g. I entered transactions in the first two weeks). Can I adjust opening balance before I close first fiscal period, despite that I entered usual transactions in that first period?

Thanks & regards,

Amr Abdelhaleem

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Dec 19, 2018 at 04:06 PM

    Hello Amr,

    Yes you can, as long as the period, year is open. So if you do the adjustment on the migration posting date, it will adjust the values accordingly.

    TIP : You can create a new Journal Entry Voucher, Enter the Journal Entry type as 00079 (You need to enter this manually) and then change the posting date to Migration posting date.

    now you can post the manual Journal entry voucher like it has generated from the migration related posting.

    Thanks,

    Harshal

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      For the inventory Migration (i.e Opening stock) is bit challenging for the materials that has "Moving average" Cost method as migrating the inventory would impact on the cost of the materials due to nature of moving average cost method as inventory valuation is based on the average cost. (in simple words : Incoming material would update the cost and the outgoing material would use the cost that is calculated by the system). Now since there are transactions posted in the system, system would have calculated the inventory cost and migrating inventory now would mean that the cost is recalculated which could impact on the inventory valuation.

      To overcome this, you may need to update the inventory cost. if we update the inventory cost with the past date, system would also post the adjustment postings and that would impact the GL balance for the current period / month.

      For the material with standard cost, this should not be an issue as you can migrate the inventory as long as GL balance and the value of the inventory matches.

      Overall I suggest you to test with one sample material in the test system and then see the impact of the migration.

      You can read about how to verify in help document : Verify Migration of Inventory

      Or reports like --> Inventory Valuation Next navigation step Reports Next navigation step Lists Next navigation step Material Inventories - Reconciliation

      To compare the values in GL and in ledger.

      I hope this will help.

      Regards,

      Harshal