Skip to main content
Solved

Group Consolidation error - Period of Transaction

  • Sep 6, 2022 4:54 PM UTC
  • 8 replies
  • 378 views

Forum|alt.badge.img+7

Hello All,

 

I am testing the group consolidation functionality and I believe I have set up all of the basic data required.  When I try to Consolidate Balances from the Consolidation Status screen I am getting this error message 

 there is no place to enter the period of transaction.  I assumed that it would default from the period entered for the consolidation status.

 

Has anyone seen this before?

Best answer by CBKLeasure

The issue was the Ultimate Ownership field.  This should be set to No

 

 

View original

8 replies

Ieva Rituma
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Sep 7, 2022 8:13 AM UTC

I noticed you’ve consolidated period 7. Have you performed consolidation first for periods 1, 2, 3, 4, 5 and 6? Because IFS does cumulative consolidations and then period consolidated values are calculated, this might be the cause of the issue


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • Sep 7, 2022 12:06 PM UTC

The first period that contains transactions is period 7.


Ieva Rituma
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Sep 7, 2022 12:36 PM UTC

Could you please try consolidating period 1 to see if you see the same error then?


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • Sep 7, 2022 12:45 PM UTC

Period 1 is showing a successful consolidation.

There are no balances in consolidation since there were no reported balances in January.  Do you recommend completing each month up to July?


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • Sep 7, 2022 12:51 PM UTC

I consolidated periods 1 through 6 with no issues.  Still getting the error for period 7.


Ieva Rituma
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Sep 7, 2022 1:06 PM UTC

Thanks for giving that a try. Without looking into the transactions or the setup it will be hard to establish the cause of the issue. I would suggest raising a support case.


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Partner)
  • Answer
  • Sep 17, 2022 6:31 PM UTC

The issue was the Ultimate Ownership field.  This should be set to No

 

 


Forum|alt.badge.img+3
  • Do Gooder
  • Aug 29, 2023 1:11 PM UTC

Hi, 

I have also come accross this error and IFS support identified that the issue were the group consolidation posting controls; since some should be using a P&L account and other should have a balance sheet account. 

Thanks