You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

FCCS_CTA with FCCS_Mvmts_FX_Opening Balances

We are seeing balances with FCCS_CTA and FCCS_Mvmts_FX_Opening . Is it expected ? I would like to know the calculation logic for this intersection.

My understanding is CTA will be the sum of FCCS_Mvmts_FX_Opening,FCCS_Mvmts_FX_Movement members for all historical accounts. This is calculating correctly but additionally seeing the balances for FCCS_CTA →FCCS_Mvmts_FX_Opening combination.

Please suggest calculation steps. Also ,advise if FCCS_CTA balances will be carry forward to next period.

FCCS_Total Data Source

[FCCS_Movements].[FCCS_ClosingBalance]

FCCS_TotalOpeningBalance

FCCS_Mvmts_Total

FCCS_Mvmts_Subtotal

FCCS_Mvmts_FX_Total

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!