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.

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.

Answer:

This has been resolved in Service Pack 18 (4.0.180.1804). Please download and install the latest Service Pack or Hot Fix which contains all fixes from previous patches.
 

Environment

Affected Product:

BLKB CRM

Affected Product Version:

4.0

Resolved Version:

4.0

Resolved Patch/Service Pack:

4.0.180.1804

Was this article helpful?

Article Number

118780

Products

  • Blackbaud CRM
Page loading complete.