GL BALANCE CONVERSION

[Former Member]

I need help with G/L conversion of balances. We have opening balances in legacy for the gl accounts that are already set up in SAP. How do we do an LSMW to transfer those balances because they are opening balances, if we do FB50 how do we offset that account because FB50 wont let us psot without an offsetting account. WHat is the procedure for loading legacy balances to SAP using crosswalk tables to SAP via standard document entry process (FB50 or FB01)

Please provide step by step instruction.

I will also need a fucntional spec for this. If someone can provide that, will appreciate.

[Former Member]

Use SHDB to record your requirement. This will give you functional specs. Ensure that a separate document type for this OB posting and mark this document type as BATCH INPUT ONLY under special usage so that this cannot be used for regular posting.

[Former Member]

Hi Sivakumar,

Can you please explain in detail as to how it can be done. I go on SHDB, then click on new recording. After that what am I supposed to do. Where will it give me the functional specs. So i willnot be doing LSMW. What is OB posting.

Will I be checking Batch input only in document type SA in transaction OBA7. But when will I do this. If you can please put all of this in steps it will really help me understand better.

Please explain me in leyman language, it will help me understand better. Thanks a lot in advance for your help and time.

Lakshmi

[Former Member]

> Hi Sivakumar,

>

> Can you please explain in detail as to how it can be

> done. I go on SHDB, then click on new recording.

> After that what am I supposed to do. Where will it

> give me the functional specs. So i willnot be doing

> LSMW. What is OB posting.

>

> Will I be checking Batch input only in document type

> SA in transaction OBA7. But when will I do this. If

> you can please put all of this in steps it will

> really help me understand better.

>

> Please explain me in leyman language, it will help me

> understand better. Thanks a lot in advance for your

> help and time.

>

> Lakshmi

<b>You can also load the balance through LSMW. SHDB is also another functionality which was available prior to LSMW. If you are not using LSMW and developing ur own upload program u can make use of this tcode for finding out the table name and field name for ur functional specs. In SHDB go to new recording. Give a name of the recording and give a transaction code say FB01. Then press recording. You will get FB01 transaction and enter the data like date company code in the require field and once you complete and save it will list all the fields used in this transaction. By this way you can write functional specs.

For the upload program u need to have separate document, which will identify how the data has been populated. say ZA. This will be used only for upload program and after this this will never be used.</b>

[Former Member]

How do I load it through LSMWthat is my question. The abaper doesnot knowmuch on this. We have an opening balance in legacy for gl account s which are already set up in SAP. We want to transfer balances through LSMW. When we go to transaction fb01 or fb50 it will not save until we put an offsetting account in the next line item. But we have opening balance for one gl account. how do i load it. can you provide me the steps for loading it in sap through lsmw. by th way, this is transactional data not master data

thankks

[dominic_holdstock]

Hi,

Create an new G/L "Offset Data Migration" and use this as the offset account.

After complete migration the balance on this account should be nil.

Kind regards

[Former Member]

Hi Dominic

Do I create a new G/L account in SAP and then post an FB50 with the debit to the gl account (with open balance) and credit new G/L account for offsetting data migration. Will i be doing the same for allthe gl accounts with opening balances. SO will I e using LSMWfor this.

Please clarify if my understanding is right.

[Former Member]

Yes. As Domininc said you need to create a account for doing all the off setting positngs. So you wll use the same account for all offsetting postings and clear the balance on this account at the end.

assing points if helpful

[Former Member]

Hi Lakshmi

Your upload porgram will take care of this. Ideally when you are uploading the total OB there is no need to have a offset account which will ensure your total Dr and total Cr match.

But in SAP you will have sub leddgers and inventory data and upload of this will take place in stages Since the upload will take place in phases we post the difference to an offset account. There is no need to post this manually to a offset account. As I said whenever your loading the opening balance you post the difference to a offset account and when you finally load your AR, AP and Inventory data this offset account should be zero. Otherwise your OB upload has not gone well.

[Former Member]

Hi Sivakumar,

If I dont create an offset account in SAP, how will I load the balances in SAP. BEcause the abaper will run FB01 or FB50 and do a recording which will be used in uploading the balances. SO if we dont create an offset account, which account will the gl account with open balances in legacy will offset agianst. Siva, can you please tell me step wise how will we load teh balances from legacy to SAP via LSMW. I am really confused. Please help me.

Thanks

Nilofer

[Former Member]

Sorry . You need to create all the GL account in place before u start the upload program.

[Former Member]

All the gl accounts are already setup in SAP. We have to loads the legacy balances to these SAP accounts. I need to know how do we do it. Please provide step by step instructions.

My question was do we need to create an offset account in addition to all the SAP accounts to do LSMW. The abaper is saying that LsMW can be done for master data. To load transactional balances, it will be a problem. He was saying he will need to do BDC session as LSMW will not load balances because FB50 has scrolling window.

I hope you got my question.

Thanks

Lakshmi

[Former Member]

> All the gl accounts are already setup in SAP. We have

> to loads the legacy balances to these SAP accounts. I

> need to know how do we do it. Please provide step by

> step instructions.

> <b>Yes You need to create a offset GL account. Hope it is clear now.</b>> My question was do we need to create an offset

> account in addition to all the SAP accounts to do

> LSMW. The abaper is saying that LsMW can be done for

> master data. To load transactional balances, it will

> be a problem. He was saying he will need to do BDC

> session as LSMW will not load balances because FB50

> has scrolling window.

> <b>It looks u have good technical consultant with you. Try to use FB01 rather than FB50.</b>> I hope you got my question.

>

> Thanks

> Lakshmi

[Former Member]

Thanks Sivakumar. One last thing. So do we talk to the client to set it up for us because what number range of gl account should be chosen for the gl account is a question. Usually which number range can we choose to do it.

Lakhsmi

[Former Member]

Also can you tell me what will be the posting date for converting the balances to SAP.

THanks

Lakshmi

[former_member188826]

Preferably an account, of balance sheet type, of clearing in nature to be used for loading the opening balance.

Once all the opening balance sheet is loaded, this account shall have a zero balance.

[Former Member]

LEt me explain the scenario:

There are legacy accounts mapped to SAP accounts. Now I need to load the balances of legacy accounts in SAP. The transaction FB50 requires an account and and offsettting account. But suppose here I have GL balance of $2000 that needs to be loaded in sap account 1111. So how will I do it. Will I be using LSMW or BDC and how will it be done. WHen you are saying to choose a gl account of clearing nature, then wont trnasaction FB50 ask for an offset account, which account will that be.

Please clarify, as to how will it be done.

Thanks\

Lakshmi