on 06-19-2010 11:01 AM
Hi Friends
I would request you, if anybody let me knwo the process of legacy data migration into sap. What are steps I have to follow while doing legacy data migration. My questions are:
1) How to upload GL balances from legacy to SAP
2) How to upload Vendor and Customer open items into sap
3) Asset balances How to upload
4) what is the use of Migration clearing accounts.
Kindly provide if any documents for legacy data migration into sap.
Thanks in advance
Rao
Hi
Thanks for the valuable information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1) How to upload GL balances from legacy to SAP
Check this links
2) How to upload Vendor and Customer open items into sap
Check this links
3) Asset balances How to upload
Check this link
Kindly provide if any documents for legacy data migration into sap
Check this links
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1. you have to create a LSMW/BDC to upload the balances to SAP.
Record a LSMW for F-02. If you are not familiar to LSMW, ask your abaper to create BDC for transaction F-02
Maintain data in excel file according to the format of LSMW/BDC.
Upload it into system.
Also remember:-
You have to create 4 GL upload clearing accounts.
1. GL Upload clearing
2. Vendors pload clearing
3. Customers upload clearing
4. Assets upload clearing
After uploading the balances you can a pass an adjustment entry for these clearing accotns. Any way total balance for uploading clearing accounts should be zero.
also check the following link.
Rgds
Murali. N
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Murali
Thanks for the information. But can you please explain elaborately for What type of GLs (expenses, revenues balance sheets GLs) I have take for uploading based on the Trail balance.
My doubt is I have to take expenses balances, revenues etc. Kindly please give with examples.
Thanks in advance.
Hi,
1. You have to take balances of balance sheet accounts only.
2. For P&L accounts, you have to take the balance only either profit/loss and have to post to Retained earnings account which you will assign in OB53.
See, to upload the balances you are using clearing accounts.
e.g.
GL uploading clearing account Dr 100
to Capital 100
Customer Dr 100
to Customer uploading clearing a/c 100.
See, here gl uploading clearing a/c and customer uploading clearing a/c we are using only for balance upload. Individually these accounts show balance, but together balance is Zero.
After uploading finally you have to post the following entry.
Customer uploading clearing a/c Dr 100
GL uploading clearing a/c 100.
Rgds
Murali. N
Dear Rao,
Just check the bwlow link you can understand easly to upload the balances.
http://www.saptechies.com/sap-pdf-books-download/SAP_Go_live_strategy11248141773.pdf
Check the bwlow procedure for the same way do it.
First create 5 Dummy GL codes. These GL code should be zero at the end of uploading balances.
1 GL Offset Account Dr
Asset Offset Account Cr
AP Offset Account Cr
Sales Cr
Other GL's Cr
2 Cash Dr
Consumption Dr
Asset Offset Account Dr
AR Offset Account Dr
Material Offset Account Dr
Other GL's Dr
GL Offset Account x Cr
3 AP Offset Account Dr
Vendor 1 Cr
Vendor 2 Cr
Vendor 3 Cr
4 Customer 1 Dr
Customer 2 Dr
Customer 3 Dr
AR Offset Account Cr
5 Fixed Asset 1 Dr
Fixed Asset 2 Dr
Asset Offset Account Cr
Acc. Depreciation Account Cr
6 Stock Inventory Account Dr
Material Offset Account Cr
Regards,
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.