User Experience Insights
Migration Cockpit (LTMC) 3 – Migrate Account balance/items
Dears,
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:
Migration Cockpit (LTMC) 1 – Migrate Asset balance for fixed assets
Migration Cockpit (LTMC) 2 – Migrate Asset balance for AUC
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.
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.
4. Check postings in SAP
You can also find other LTMC related articles –
https://community.sap.com/topics/s4hana-migration-cockpit
SAP LTMC help linked here-
https://help.sap.com/viewer/29193bf0ebdd4583930b2176cb993268/1909.000/en-US/8f97f0b407024465a283809f0bbe000c.html
Kindly give me your valuable feedback / suggestions to make this article as more useful.
Hello Penghong Jiang,
First of all thanks for this blog, it helps a lot for me and beginners. I have a query related to customer open item balances. Actually, the client wants to upload the customer open item balances with tax code and tax line items and this is a Mexico-based client. now I am facing a challenge while uploading the customer open item balances with tax code and tax line item.
we are getting two error messages as below.
1 Error
The +/- sign in the currency field is wrong (see long text)
Message no. RW610
Diagnosis
A value was transferred in the currency table in line 0000000000 with currency type 00 which has a different +/- sign compared to the other currencies. Since the debit/credit indicator is determined from the +/- sign, the +/- sign must be unique for each line item.
System Response
The document cannot be posted.
Procedure
Transfer the different currencies with the same +/- sign.
2nd Error.
Required field AMT_BASE was not transferred in parameter CURRENCYAMOUNT
Message no. RW602
Diagnosis
Field AMT_BASE is required in parameter CURRENCYAMOUNT for processing the document. The document is incomplete without this field.
System Response
The document cannot be processed.
Procedure
Enter a valid value in field AMT_BASE in parameter CURRENCYAMOUNT.
could you please help me on this issue? I have attached an LTMC Templates picture.
LTMC - TAX ITEMS TAB FOR CUSTOMER OPEN ITEMS
Please revert as soon as possible.
Best Regards:
Ahtesham Zayed.