The pledge filter in my smart field is pulling the full pledge amount and not the balance

In order to count the pledge balance without counting pledge payments, we checked the box Pledge > Donation in our smart field. When we previewed the results of the smart field in query, it showed the full pledge amount and not just the balance.
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

  1. Go to Administration > Smart Fields
  2. Click Add and select Constituent Revenue Application Amounts
  3. On the Parameters tab, check the Pledge > Donation box in the Transaction type/Application sectionUser-added image
  4. Check Donation in the Revenue types, fill out any other needed details and Save
  5. Click the drop-down next to the smart field and click Process Smart Field
  6. Go to Analysis > Information Library > Add an ad-hoc query, select Constituents and click OK
  7. In the left column expand Smart Fields and click the name of your smart field
  8. Drag Value from the middle column to Results Fields to Display
  9. Select the Preview Results tab and see that the value shows the full pledge amount instead of the pledge balance for each record

Was this article helpful?