cancel
Showing results for 
Search instead for 
Did you mean: 

Legacy Balance upload

deepa_khatri
Active Contributor
0 Kudos

Hi all,

Before go live we have to upload all the open balances of legacy system.

I want to upload all the AR,AP ,GL,Asset and inventory balances in the system.

Please let me know in details.

Awaiting

DS

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member184878
Active Contributor
0 Kudos

Hello,

My opinion. Just uploading balances is not perfect.

If you are interested take a look, I already have written some lines about

data migration.

Well, data migration is a project at itself, not possible to write it down in a few lines.

I am looking forward for discussing this matter. Will you or SAP partner handle the upload? Have you already decided for the tool you will use?

all the best Erwin

Former Member
0 Kudos

Hi Deepa,

Before you started creating Legacy data upload kindly create on initial upload GL

for GL, Vendor and Customer  then Create a LSMW or BADI for upload the data in the System

for the Tcode F-02 you can also create on different document type i.e. "OB"  for initial upload

thanks

Trinath

i

deepa_khatri
Active Contributor
0 Kudos

Hi Trinath,

thanks for reply .I need descriptive documents with accounting enteries.solution that you have provided is helpfull but only oulined.

thanks

Deepa

Removed email address

Former Member
0 Kudos

Hi Deepa,

Before you started creating Legacy data upload kindly create on initial upload GL

for GL, Vendor and Customer  then Create a LSMW or BADI for upload the data in the System.

Suppose, if your TB Balance,

ParticularsDrCr
Liab
Share Capital 100
reserve & surplus 50
Sr. Creditors 35
Acc. Depreciation 25
Assets
Bank10
Sr. Debitors25
Fixed Assets100
Stock75
Total210210

Now First  you can create control GL a/c's for uploading balances like,1.GL Control A/c 2. AP Control A/c, 3. AR Control a/c, 4. MM Control A/c, 5. AA Control A/c,

Now you can upload master data and transaction data through LSMW

Step:1

1). GL Control A/c Dr    210

        To Share Capital Cr   100

        To reserve & surplus  50

        To Sr. Creditors            35

        To Acc. Depreciation   25

2).    All Dr A/c's Dr  210

               To GL Control A/c 210

Step:2

1. Vendor Balance through F-43,

2. Customer data - F-22

3. Asset Transaction data - OASV

4. Stock Material- MB1C

Best regards,

Modupalli.

Former Member
0 Kudos

Hi Deepa,

I am totally agree with Erwin Data migration is a project by itself we cannot express in few lines

there are different cut over strategy new to be taken care with the management team and consultant

1) Prepare proper chart of account as per country

2) Prepare account group for chart of account

3) Mapping the GL with old one is any existing

4) create initial upload GL

5) upload all the master data for GL, Vendor , Customer, Asset , profit center and cost center

6) Prepare LSMW for all the master data.

7) Prepare LSMW / BDC for Transaction data

😎 prepare B/S & trial Balance before & after the data upload in SAP

there are lot more to done please take any of you senior consultant help he may help you

Thanks

Trinath