Question

CTA calculation details per reporting entity in Group Consolidation

  • 4 January 2023
  • 1 reply
  • 30 views

Badge

Is there a report in IFS that provides CTA calculation details per reporting entity in Group Consolidation?

When I generate the consolidated details analysis report, CTA only shows the total amount and does not provide the breakdown per entity.  We need to be able to reconcile this number by entity by obtaining the details. Thanks.


1 reply

Badge +4

Hi, 

Could you try enabling the ‘keep balances separated by reporting entity’ check box in account window and enabling the ‘currency’ code part from the ‘additional code parts’ in the master company for group consolidation. 

  • ‘Currency’: additional code part will help you to identify the transaction currency as a total although it doesn’t give the transaction wise breakup at the consolidation, which is also can be used to check in ‘consolidation balance details’ window.  
  • ‘keep balances separated by reporting entity’ check box in account window, helps to separate the balances based on entity. 

Attached screenshots for your easy reference. 

Hope this may help you to analysis required output. 

Best Regards,

Thushan Wijayawickrama

Reply