BBDW: Pledge instalment balance query node returning negative result for multicurrency payments

With multicurrency switched on the BBDW pledge instalment balance query node returns negative results for payments instead of zero balance.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch

Steps to Duplicate


- Blackbaud Data Warehouse must be deployed
- Multicurrency module must be unlocked
- In this example the CRM organisation currency is set to UK pounds (GBP)

1. Add a foreign currecny pledge to a constituent record that's to paid over two installments
2. Make a full payment for the first installment therefore the installment balance is zero
3. Create a 'Revenue (from the Blackbaud Data Warehouse)' query with the following design:


Revenue lookup ID is equal to [pledge added above]

Output fields:

Pledge\Pledge Installments\Installment date
Pledge\Pledge Installments\Installment balance
Pledge\Pledge Installments\Installment amount

* Notice for the paid pledge installment the installment balance returned is -£10,000 when it should be zero, what seems to be happening is the transaction amount is being subtracted from the
organisation amount:

£40,000 (organisation currency) - $50,000 (transaction currency)  = -£10,000


 Blackbaud CRM
 4.0.180, Service Pack 15

Was this article helpful?