Legacy Trial Balance - best way to get totals into SAP

[Former Member]

Hi Folks,

I have a query relating to the data migration of Finance items.

What is the best process for updating the new SAP system with the legacy trial balance?

Do you journal in the Opening Trial Balance posting sub ledger items to a Data Load account?

Load the AR / AP sub ledger items via the standard load routine RFBIBL00 which will in the case of customers Debit the customer account and Credit the Data Load Account / Vendors Credit the Vendor and Debit the Data Load Account.

Could anyone please give me a step by step guide as to how to go about this?

Thanks

[Former Member]

HI

You can create BDC to upload your opening Trial balance. Your trial balance cannot be stright way uploaded as it is in SAP.

2) Decide whether do you want maintain line item wise details for your P & L Accounts or with one single for each GL account till last date of Golive

3) Incase you uploading your GL balance with single entry ensure that you are segarating each GL balance as per cost center or business area wise.

4) Vendor and customer balance open items also needs to be uploaded.

5) Asset masters need to be uploaded using AS 91with APC and Acc. Depn Value.

6) Value of Assets, asset class wise (also business area wise, in case if you are following business area concept) through OASV to update the values in FI

7) You need to create one more GL account for uploading all balances. The account balance should be zero once all your upload is over.

Hope it would clarify your requirements. in case you need further more clarifications please revert back

regards

chandrasekaran

[Former Member]

Hi

Thanks for your response, sorry to raise a further query.

I am intending that the Opening TB is journalled into the system by debiting/crediting each of the Balance sheet accounts with the other entry going to the legacy data transfer account. However with regards to customer/vendor/stock balances (fixed assets is not being implemented) I am intending that a posting is made to a legacy data transfer account for each of these items.

The customer and vendor open item load will be made via LSMW using RFBIBL00, and stocks will be via a 501 movement type which will Debit Stocks and Credit Initial STock Load.

Am I approaching it the right way. What should I do about VAT? Will SAP allow me to post directly to retained earnings or should I create a Legacy system Retained Earnings account.

Thanks for responding to me, your input is very much appreciated.

Regards

C

[Former Member]

Hi,

The upload of GL Balances have to split into several steps:

1. Normal GL Accounts: In this case line items are not required and totals are to be updated in SAP. This can be done using GL fast entry if the number is not too high.

2. Open Item Managed GL Accounts: All the open line items are required to be uploaded in SAP from Legacy in order to clear them. Hence, a LSMW / BDC program has to be developed to upload the line items.

3. Customer & Vendor Open Items: All open line items in Customer and Vendor Accounts have to be brought in into SAP. For this also a LSMW / BDC program needs to be developed and upload the line items.

4. Asset Accounting: In case asset accounting is implemented the individual balances of each asset (Gross Value and Accumulated Depreciation) have to be uploaded using transaction AS91. For this also you need to develop a LSMW / BDC program. Further, you also need to update the GL Accounts related to Asset Accounts with totals for each asset class T.Code OASV.

5. Further, material values are also to be updated - Material wise and this should tie with the GL Balance.

In addition, one more point to be noted is the use of Dummy / Conversion accounts for bringing in data from legacy to SAP. It is better to create five or six conversion accounts like for Assets, Liabilities, Revenue, Expenses, Materials etc. The sum of all these conversion accounts should be ZERO after completing the conversion. This way the reconciliation will become easy.

Thanks

Murali.

[Former Member]

Hi

Thanks for your response, sorry to raise a further query.

I am intending that the Opening TB is journalled into the system by debiting/crediting each of the Balance sheet accounts with the other entry going to the legacy data transfer account. However with regards to customer/vendor/stock balances (fixed assets is not being implemented) I am intending that a posting is made to a legacy data transfer account for each of these items.

The customer and vendor open item load will be made via LSMW using RFBIBL00, and stocks will be via a 501 movement type which will Debit Stocks and Credit Initial STock Load.

Am I approaching it the right way. What should I do about VAT? Will SAP allow me to post directly to retained earnings or should I create a Legacy system Retained Earnings account.

Thanks for responding to me, your input is very much appreciated.

Regards

C