Skip to Content
User Experience Insights
Author's profile photo Penghong Jiang

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.

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.

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.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ahtesham zayed
      Ahtesham zayed

      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.

      customer%20open%20item

      LTMC%20-%20TAX%20ITEMS%20TAB%20FOR%20CUSTOMER%20OPEN%20ITEMS

      LTMC - TAX ITEMS TAB FOR CUSTOMER OPEN ITEMS

       

       

      Please revert as soon as possible.

       

      Best Regards:

      Ahtesham Zayed.