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?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.