Transfer of Balance of Vendor Customer and Ledger

How can I transfer balance of customer, vendor and ledger from previous accounting system to sap r/3 envioroment?

1. Prepare the Balance Sheet at one cut off date.

2. Classify the Accounts into Group.

3. Create Group wise clearing GL (You should create clearing account through OBD4)
      for eg.  Capital General Clearing A/c
                 Capital Initial Clearing A/c

                 Expenditure General Clearing A/c
                 Expenditure initial clearing A/c

                 Customer General Clearing A/c
                 Customer initial Clearing A/c

                 Create the GL each Account Group.

4. Create one Doc.Type "LD"  for upload Legacy Data.

5. Post the Balance Sheet Figures through T.Code F-02 use Doc.Type "LD"
      for eg.  Sundry Debtors Balance Rs,5 lac in Balance Sheet. This fig was arrived from 5 
                  customers   Mr.A - Rs.75,000 Mr.B Rs.25,000 Mr.C Rs. 400000

                  Post

                  Customer General Clg A/c   Cr.5,00,000
                  Customer Initial Clg A/c        Dr.5,00,000

                 Like that post all the Balance Figures in SAP group wise. Maintain one XL Sheet. Carefully maintain this sheet.

                 All the General Clg GL figures are opposit to BS, only for controlling

                 Then post

                  Customer Inital Clg A/c Cr.                                   5,00,000

                   Mr.A                    A/c     Dr.      75,000 
                   Mr.B                    A/c     Dr.       25,000
                   Mr.C                    A/c     Dr.    4,00,000

After completed the posting all the inital accounts are "0" Value and all the General Clg A/c are "0".

If you want to post the Customer open item line by line, prepare the XL sheet upload through LSMW.

If you want to check the TB in SAP to Tally, select all the document and filter the Doc.Type "LD" the debit balance and credit balance are "Zero".

Get help for your SAP FI/CO problems
SAP FICO Forum - Do you have a SAP FI/CO Question?

SAP Books
SAP FICO Books  - Certification, Interview Questions and Configuration

SAP FICO Tips
SAP FI/CO Tips and Financial Accounting/Controlling Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.erpgreat.com or the content authors.