Balance Upload

[Former Member]

Dear All

I want to Upload the balances from the Trial Balance such as Vendor Balances, Customer Balances, P&L Balances,B&S Balances, SGL Balances in the SAP. I have developed the following strategy.

PK DR(Amount) CR(Amount)

1 Vendor Balances 31 100

Vendor Balance Upload A/C 40 100

2 Customer Balances 01 500

Customer Balance Upload A/C 50 500

3 P&L(Debit) Items 40 100

P&L(Debit) Upload A/C 50 100

4 P&L(Credit) Items 40 200

P&L(Credit) Upload A/C 50 200

5 B/S Debit Items 40 100

B/S(Debit) Upload A/C 50 100

6 B/S Credit Items 40 100

B/S(Credit) Upload A/C 50 100

7 SGL Items Vendor 29 100

SGL Vendor Uplaod A/C 50 100

8 SGL Items Customer 19 100

SGL Customer Uplaod A/C 40 100

Please guide me.

Thanks and Regards

Kanwaljit

Edited by: Kanwaljitsap on Jun 27, 2009 12:31 PM

[former_member182098 · Accepted solution]

Regards,

Ravi

[Former Member]

Hi

Your strategy is correct, but please note for balancesheet account like customer/vendor only transfer the open items i.e. which are still not knocked off, so you will control the number of lines to be migrated.

Balance can be uploaded on summerization basis or line item basis . Ideally for GL accounts you can post monthly summerized balances and for subledgers open line item wise,

However you can use LSMW with the help of ABAPER by extracting data direct from tables.

cheers

Mukta

[Former Member]

Hello

The SAP standard LSMW can be use to upload balance from legacy system. Fisrt get one record posted in normal JV posting, then record this transaction in LSMW. Create LSMW project and assign the recording thereto.

Otherwise you can get your ABAP person record the transaction in program, and upload accordingly

Regards

Dinabandhu