Skip to Content
author's profile photo Former Member
Former Member

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

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!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 02:10 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 02:19 PM

    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.

    sap-general

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 02:30 PM

    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!

    Add a comment
    10|10000 characters needed characters exceeded

    • 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....

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.