Skip to main content
Solved

Setting up consolidation in IFS 10

  • January 21, 2020
  • 5 replies
  • 2285 views

MattiasLindahl
Sidekick (Customer)
Forum|alt.badge.img+9

We need some help with the consolidation process in IFS 10. We have succeeded with some of the steps but there are some issues left, e.g. currency translation and elimination of inter-company transactions. Below I list the steps that we have done.

 

  1. Map subsidiary accounts (Accounting rules -> Code string -> Accounts field Account group)
  2. Specify which months to consolidate in the parent company (Financials - Consolidation -> Group Consolidation -> Balance Transfer and adjustment -> Reporting status)
  3. Give permission to employees to perform the consolidation. (Financials - Consolidation -> Group Consolidation -> Consolidation Basic Data -> Consolidation Security)
  4. Transfer data (Financials - Consolidation -> Group Consolidation -> Balance Transfer and adjustment -> Balance Transfer Assistant)
  5. Approve reporting journal (Financials - Consolidation -> Group Consolidation -> Balance Transfer and adjustment -> Reporting status)
  6. Create consolidation structure (Financials - Consolidation -> Group Consolidation -> Consolidation -> Consolidation Structure)

 

After the above-mentioned steps, we can see the consolidated data in Consolidation Period Balance Analysis. However, as mentioned, the data is not correct since the currency is not translated and no elimination of inter-company transactions has been done.

 

What do we need to do to succeed?

Best answer by Chirantha

Hi,

The currency translations and inter company eliminations are handled when balances are consolidated, provided you have set the basic data correctly.

You can execute consolidation in “Consolidation Status” window for the consolidation structure you created in step -5.

You may analyze the consolidated balances in “ Consolidation Balance Analysis” and “Consolidation Details Analysis”. If basic data was set up correctly, you would be able to find the transaction types Translated Balance and Intercompany Elimination that reflects the currency translations and inter company eliminations respectively.

Hope this might help you..!

Best Regards,

Chirantha.

View original

5 replies

Chirantha
Hero (Employee)
Forum|alt.badge.img+8
  • Hero (Employee)
  • 67 replies
  • Answer
  • January 23, 2020

Hi,

The currency translations and inter company eliminations are handled when balances are consolidated, provided you have set the basic data correctly.

You can execute consolidation in “Consolidation Status” window for the consolidation structure you created in step -5.

You may analyze the consolidated balances in “ Consolidation Balance Analysis” and “Consolidation Details Analysis”. If basic data was set up correctly, you would be able to find the transaction types Translated Balance and Intercompany Elimination that reflects the currency translations and inter company eliminations respectively.

Hope this might help you..!

Best Regards,

Chirantha.


MattiasLindahl
Sidekick (Customer)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 41 replies
  • January 30, 2020

Thanks!

We try to see how we have setup the basic data. Maybe there is something missing. Is there some BDR requirements documentation other than online documentation?

 

/Mattias

 


MattiasLindahl
Sidekick (Customer)
Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • 41 replies
  • February 7, 2020

We found that we are missing some basic data so after fixing this we will be able to consolidate.

 

Thanks!


Forum|alt.badge.img+1

Hi MattiasLindahl, We are currently having the very same problem. I know that this topic is a bit old, but I would really appreciate if you could walk me though the basic data configuration for Intercompany Elimination transactions  to Reflect in the Consolidation Details Analysis window.

Thanks!

Pablo


Forum|alt.badge.img+3

let me know if you need any more assistance with Group Consolidation :)

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings