Discrepancy in Net DR/CR for Non-Translated Transactions (X, XX) in DW_GL_BALANCE_ALL_CF (FDI)

User_95GVP

Hello Experts,

We would like to understand how data flows into the DW_GL_BALANCE_ALL_CF table in Fusion Data Intelligence (FDI / ADW).

In the source (Fusion GL), each transaction has a Translated Flag with values such as Y, R, X, and XX.

During our analysis:

For translated transactions (Translated Flag = Y and R), the balance amounts in DW_GL_BALANCE_ALL_CF match exactly with the Fusion source table data. However, for non-translated transactions (Translated Flag = X and XX), where the Ledger Currency Code = Transaction Currency Code, we are observing discrepancies.

Specifically:

Net Balance DR and Net Balance CR values in DW_GL_BALANCE_ALL_CF do not match the corresponding values in the Fusion source tables.

We have cross-verified amounts across:

1. Transaction Currency

2. Ledger Currency

3. Global Currency

but none of these align with the values in DW_GL_BALANCE_ALL_CF for these cases.

Our question:
Is there any transformation, aggregation logic, or adjustment applied to non-translated transactions (X, XX) when populating DW_GL_BALANCE_ALL_CF in FDI?

Any insights or documentation references would be greatly appreciated.

Thank you!