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]
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: