The balance for the TRANSACTIONBALANCE field of the BBDW.FACT_FINANCIALTRANSACTION table shows as the full pledge amount even though the balance was reduced to zero via a write-off

The pledge transaction balance (FACT_FINANCIALTRANSACTION.TRANSACTIONBALANCE) and line item balance (FACT_FINANCIALTRANSACTIONLINEITEM.LINEITEMBALANCE) fields in bbdw do not accurately reflect data seen in the oltp.

Download and install the latest version and patch, if applicable. 

Environment

 3.0.516, patch 37
 4.0.131 ; 3.0.516, Service Pack 10

Was this article helpful?