PastDueAmount field in BBDW.FACT_FINANCIALTRANSACTION is not populating

Users may find that after running an ETL refresh, the PastDueAmount field in the BBDW.FACT_FINANCIALTRANSACTION is not populated.
 We are currently evaluating this issue for a fix in a future service pack.
 

Steps to Duplicate

  1.  Navigate to Administration > Data Warehouse > Blackbaud Data Warehouse > Refresh ETL
  2. Once the ETL refresh is complete, run the following against the BBDW Database : 
  3. select top 100 PASTDUEAMOUNT, * 
    from BBDW.FACT_FINANCIALTRANSACTION 
    where PASTDUEAMOUNT > 0
  4. Note that there are 0 results.

Environment

 Blackbaud CRM
 4.0
 4.0.173.0

Was this article helpful?