This is the 3rd article to share experience on LTMC tool function. Today, I am going to share approach to migrate account balance, open AR/AP items, and hoping it could be helpful for data cutover in your project.
Assets migration approach can be referred links below:
Regarding the LTMC project creation and cutover parameter maintenance, you can refer to linkages above, let’s start directly on steps demo for account balance and line item migration.
Suppose we have below accounts balance to be migrated:
Normally, if the accounts are open item management, then we should migrate such accounts in line items detail, including the same document parameters, such as document date, document currency and migrate as much legacy information as possible. The aim is to keep consistence with legacy after live in new ERP system. For those normal or PnL accounts, we normally migrate balance to new system only.
1.Prepare uploading template
We should post sales related cost elements balance(11&12) to objects that can have revenue or COGS posted, such as WBS, PSG or internal orders. In this demo, we post it to PSG.
In this standard uploading template, each line would be posted as one document in SAP, the migration accounts can be updated in column "Offsetting account".
2.Define migration key date
It can be setup via tcode: FINS_MIG_CTRL_1, this is a mandatory step to use LTMC tool to migrate FIN objects balance.
3. Flow the steps to upload the file.
Upload->Active->Start transfer->Validate data->Convert Value->Simulate import->Execute import, and the detail steps can be find in asset related post.