GL balance conversions

[Former Member]

Hi All

We are merging two company codes (Ex Company code A and B ) into new company code(ex.C). How to transfer balances (GL and any others) from A and B into C? Can some one explain in detail please? What all the steps need to be taken care and when this activity should be happening?

Thanks

D

[Former Member · Accepted solution]

Hi

There is no automatic transfer possible.

Hence you may have to download the balances/open items and upload the same in the new co. code using LSMW or BDC.

The possible things to take care defers from organisation to another, but ni general take care of the following:

1. Before downloading, decide you want to upload open items or just balances for each G/L Account. Also decide to use single T.code, document type & posting date for all upload of items to avoid confusion.

2. Ensure that you have all the G/L Accounts/customers/vendors/cost centers/profit centers, etc. availabl in the new co. codes. If not, customer/vendor/g/L accounts needs to be extended and cost center/profit centers needs to be created.

3. After downloading of entries from old co. codes, block the period for posting to ensure that no further posting takes place.

4. Clear the maximum entries possible in old company codes, so that minimum entries goes to the new co. code.

5. After uploading, verify the trial balances (A + B = C) of all three co. codes to ensure that upload are proper.

Hope these points will be useful to you.

Regards

[Former Member · Accepted solution]

Thanks for explanation Kash

In Terms of GL accounts, We have both open item managed accounts and Non open item managed accounts. Here is how we were planning to do

If Open item managed accounts are present, We will bring the documents to new company code C

If Non Open item managed accounts are present, we will bring the balances from those accounts to new company codes.

1. For Open item managed accounts, we have contra account where we can bring documents and use offset account as contra account. This is from Table BSIS (FBL3n). I am planning to use LSMW to record FB01 and post all documents in new company code.I hope this is correct.

2.Can you please let me know how to bring balances from Non Open item managed GL accounts? Which tables(we are in ECC 5.0) we need to extract data and how to load them? Any procedural steps would be much helpful.

Thanks

[Former Member · Accepted solution]

Hi

It depends on the how the settlement is done between the company codes. In case amount is physically paid then you need to post payment in one company code and receipt in another. However generally the settlement is by way of book entries whereby the amount to be paid / received is adjusted in accounts (Inhouse Bank if IHC implemented or Loan and Asset). In the Balance Sheet this should form part of Receivables / Payables .

During consolidation this intercompany balances are eleiminated.

What happens to the open items created in the inter company clearing accounts created in OBYA

You can use intercompany reconcilation if you are using ECC 6.

You can post the cross company code postings even between two controlling areas. The system does not prevent to post documents between two company codes in two controlling area. Need not necessarily they should be under one operating concern. Provided you have to make sure that you have followed the following points:

In OBY6 - To company codes must be assigned to same Company, meaning that you mus thave created a Company and that company must have been assigned to these two company codes.

OBYA - You should maintain the clearing accounts in both the company codes. Meaning that you are posting one leg in one company code and the other leg in the other company. Therefore, it is required to have the missing legs in each company code.

Company Code1 - Posting Key 40 - Clearing Account

Company Code1 - Posting Key 50 - Clearing Account

Company Code2 - Positng Key 40 - Clearing Account

Company Code2 - Posting Key 50 - Clearing Account

OB08 - In case if the two company codes have different local (company code) currencies, you may maintain the exchange rates.

You can now go to F-02 and post a cross company code transaction giving the first leg in first company code and the second leg in second company code. Missing leg in the first company code will be posted to the GL Account mentioned in OBYA and the missing leg in the second company code will be posted to the GL Account mentioned in OBYA. That means you will have four line items overall.

The system will post three document.

Document 1 in First Company Code

Document 2 in Second Company Code

and

Document3 - Cross Company Code Document.

The cross company code document consists of the first company code document number plus company code plus last two digits of the fiscal year.

Hope this must have clarified your doubts.

Please let me know in case if you need further details.

Regards

[Former Member · Accepted solution]

Hi

Point no.1 is correct.

As regarding point no.2, it depends on the requirement -

Suppose if you want to transfer the balances in a single line item (that is .. without any account assignment), then you can extract the balance from any GL Trial balance report, re-arrange the data in LSMW format and upload it.

Or else if you want the break-up or details of entries (for example: with information of assignment field or Reference), then you can extract the data using FBL3N, re-arrange the data in LSMW format and upload it.

Or else if you upload Cost centerwise, then you may need to take cost center wise report, replace it with new cost centers of Co. code C and re-arrange the data in LSMW format and upload it.

Regards

[deepa_khatri]

Hi,

Explain your exact requirement.

Thanks

Deepa

[former_member764022]

How can we clear the above merging clearing GL amount?