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, * 
    where PASTDUEAMOUNT > 0
  4. Note that there are 0 results.


 Blackbaud CRM

Was this article helpful?