Skip to main content

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.

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