Data Migration Plan # 2

We have used LSMW to upload GL Master, this goes little bit tough as we have to thoroughly check any data redundancy in the input file containing hundreds of acccounts in various company codes.

Here GL master contains no balances, so AP and AR master datacan be loaded. Once AP and AR Master are uploaded we need to deactivate the indicators like Recon Account,Post automatically only, Recon Account ready for input,Posting without tax allowed in GL account master data for the purpose of loading GL Balances as recon accounts do not permit direct postings. The GL balances are uploaded using a conversion and upload program. After upload check the GL account and its balances in FS03. After this to find out the recon a/cs with balance we will try to reset recon account indicator thru LSMW which displays an error log as " GL account has balances changes are not permitted". Using this report GL accounts(recon accounts) balances are credited to a Data Migration clearing account to nullify the GL account because the recon accountsmust be tied to their respective AP, AR accounts for which the GL accounts must be zero. Then the indicators are reset again I mean the Recon account, post automatically only etc are activated. Then we post the open items for invoice etc crediting the Customer account manually.

Example: GL account 310001 is recon a/c with credit balance of $1000. This GL account is reversed manually with the following entry

Dr 310001(Trade Payables Control) $1000

Cr 599999(Data Migration Clearing account) $1000

This will nullify the balances in GL account. Now, the invoice open items are posted to AP, AR accounts manually with the below entry

Dr 599999 $1000

Cr 310001 $1000

(Recommended) Sequence of Steps in DATA MIGRATION

1) Load GL Accounts

2) Load Material Master- General and Plant Data

3) Load Cost Elements + Secondary Cost elements

4) Load Bank Master

5) Load Statistical Key figures

6) Load Profit Center + Profit Center Hierarchy

7) Load Cost Center + Cost Center Hierarchy

8) Load Vendor Master - General, Company Code and Purchasing data

9) Load Customer Master - General and Company Code

10) Load Internal Order

11) Load Asset Master including Transactions

12) Profit Center Plan data

13) Cost Center Plan data

14) Internal Order Plan data

15) GL Balances

16) Open AP and AR Items

Like wise Asset upload is a straighforward method. Create assets and load balances in one single upload using two files one for Asset master creation the other for Asset Balance transfer again using LSMW. Here we have seperate objects in LSMW forAssets with Internal generated number,externally assigned number, Assets in Prior yearand Assets in Current year. While loading Assets ther are some important things to becareful enough the asset classes, capitalization dates,posting dates,amounts. To carryasset upload for current year assets we need to perform a Asset Fiscal year change topost values in current year.After upload check the asset and balances in AS93.

Courtesy: Harika Barath, FICO Consultant