LINEITEMBALANCE and TRANSACTIONBALANCE in BDW.FACT_FINANCIALTRANSACTIONLINEITEM have NULL values

After Service Pack 3 for version 4.0 was installed, 2 fields, LINEITEMBALANCE and
TRANSACTIONBALANCE, in BDW.FACT_FINANCIALTRANSACTIONLINEITEM now have NULL values.
We're currently evaluating this issue for a fix in a future patch or service pack.

Steps to Duplicate

  1. Run the following script and note 0 results were returned: 
  • select * from BBDW.FACT_FINANCIALTRANSACTIONLINEITEM where TRANSACTIONBALANCE is not NULL
  1. Prior to installing SP3, redeploying, refreshing, there were records with values other than NULL in this table.

Environment

 Blackbaud CRM
 4.0

Was this article helpful?