Adjust Migrated Opening Balance After Entry of Transactions

[former_member546282]

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

[HarshalVakil]

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

[former_member546282]

Dear Harshal,

Thank you very much, for your contribution. I just would like to ask you regarding if there are daily transactions of inventory and there is no opening balance yet migrated to sysetm? Do you see that will work?

Thanks & regards,

Amr

[HarshalVakil]

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 Reports Lists Material Inventories - Reconciliation

To compare the values in GL and in ledger.

I hope this will help.

Regards,

Harshal