With multicurrency switched on the BBDW pledge instalment balance query node returns negative results for payments instead of zero balance.
We are currently evaluating this issue for a fix in a future service pack.
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: