Skip to Content
0

Retrospective effect for Group Chart of Accounts

Apr 13 at 02:00 PM

71

avatar image

Hello

We have a customer who have about 4-5 company codes, all of which have different charts-of-accounts assigned. Therefore they cannot report across company (as they are in different CO Areas – because the chart isn’t the same in all company codes). They are looking to put a group chart in to standardise some reporting.

These systems are already live – so I need to understand if they can be retrospectively applied. In addition, I need to understand if a program needs to be run to update any existing transaction records ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sanil Bhandari Apr 16 at 05:14 AM
0

Hi

A best practice would be to merge the operational chart of accounts and controlling area for all the company codes. This has lot of benefits like

1. Homogeneous Reporting

2. Better Control on Intercompany Transactions

3. Simplification on S/4HANA journey.

System landscape transformation (LT) is a SAP tool to do that. The information for the same is available on the below link:

https://help.sap.com/viewer/d60cfd6859ba457fb5c8b4436c942388/2.0.13/en-US/0ade120299f04500838cf58e8162b911.html

The high level steps are as under:

1. Create a copy of Production system (s). Now complete period end close and download financials for all legal entities

2. Install LT Add on and run test migration. Resolve issues

3. validate the financials against the old balances

Repeat the steps 1,2 and 3 in mock, dev, quality system before executing in Production.

regards

Sanil Bhandari

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Sanil

Thanks for your response. Much appreciated.

However can i check even after COAs are aligned using LT, how can we ensure the existing data already present in system are picked up in Group reporting once we assign Group COA ?

I assume using LT, we can change the future landscape but the client also wants to see the historic data in Group reporting.

Can you suggest how I can address this issue ?

Suhail

0

Hi

LT will change your historical data as well into one COA. So you should be able to use historical data as well. Please go through the link i mentioned on more details on LT

Regards

Sanil Bhandari

0
Gaurav Agarwal Apr 19 at 10:23 AM
0

If changing the existing way data is very challenging, then you can look for implementing the group chart of account in downstream layer like BPC Consolidation etc. for harmonized reporting. The mapping can be done from your operational CoA to group CoA for past data also and can be reported.

Thanks,

Gaurav

Share
10 |10000 characters needed characters left characters exceeded