How to upload GL, AP, AR balances from Legacy into ECC 6.0?

[Former Member]

Hi there,

Any help or thoughts on the following question would be most appreciated.

I wanted to find out how one can <b>upload GL, AP, AR balances</b> from a Legacy system into SAP? I am new to SAP and would really appreciate if anyone out there had a <u>step by step</u> document or could direct me to a website where this info was available.

Thanks in advance!

[Former Member]

Barry,

Thanks for your quick response. I really appreciate it. I'm sorry, maybe my question was not clear. I know that I have to use LSMW to upload the balances. But my question is what needs to be done from a GL, AP, AR standpoint?

I have read from some places (I could be wrong) that we need to setup initial clearing and general clearing accts in order to upload the GL balances. How do we go about this? What are the prerequisites <u>before</u> the LSMW? Do GL balances have to be upload before AP and AR balances? What should my flatfile contain and what fields need to be in it before uploading it? I am not sure what info needs to be in my excel file before I upload it.

Thanks!

[Former Member]

We create "dump (or clearing) accounts" to handle one half of the double entry.

One for AP, one for AR etc, and then the other posting goes to the reconcilliation account for that area (Customer reconcilliation account). These figures are always reconciled before and after.

Always double check the mandatory fields are populated before uploading, but this can be done when you create you LSMW recording in your development system.

Also, you might want to switch between internal and external number ranges. Also, create a specific document types for each different area to assist with reporting.

[Former Member]

the first step is to upload the master data.

then we need to create the GLs and upload the figures there... it is normally 99 series so that it is used just for conversion purposes...

we also need to create a recon GL... diff doc type ....

the GL balances have to be uploaded before the AP/AR for matching purpose....

the flat file data depends on how u want to upload the data.... u want to uplaod the customer balances or u want to carry it document vise....

for LSMW we use FB01 to upload the data... so all the required fields used for the posting key and GL need to be there in the flatfile... also other fields which are used by business should be there... the layout will be determined the the LSMW....

[Former Member]

Hi,

You usually upload the initial data (cut-over data) using Standard Programs/LSMW/Custom Programs Tool from the legacy systems.

The standard programs:

1. GLGCU1 Transfer opening balance flex. G/L

This program transfers the documents previously accumulated in Financial Accounting as the opening balance for General Ledger Accounting.

The system runs a check on each document to establish whether it has already been transferred to New General Ledger Accounting.

2. 8KET4 Opening Balance for PCA Costing

You would use standard programs if they are available. Else, you would use LSMW tool for uploading master data, custom programs (BDC/BAPI) for uploading transaction data.

Where you would also find more information about BDC and LSMW.

For information regarding LSMW steps visit the following link:

/people/hema.rao/blog/2006/09/14/lsmw--step-by-step

http://help.sap.com/bp_blv1500/BL_US/html/dataconv_lsmw.htm

Hope this will help.

Regards,

Naveen.

[Former Member]

You can use a standard tool from SAP - LSMW.

https://wiki.sdn.sap.com/wiki/display/ABAP/LSMW

http://www.sd-solutions.com/documents/SDS_LSMW.html