Scenarios:
- You are trying to transfer a payment from one revenue type to another and you get this error in the BPA logs
- You are trying to run an open items worksheet and it is failing with this error in the worksheet logs
- You are trying to apply a payment directly to a document (you should not be doing this anyway unless it is an absolute last resort) and you can see this error in the BPA logs
Cause:
- Often this is the product of the following scenario:
- Ratepayer has a direct debit payment plan for one or both of their rates and water
- One of their cyclical bills is paid with their direct debit arrangements and is in credit; the other does not, and is in arrears after the due date expires.
- Ratepayer wants the credits from their overpaid revenue type transferred to the other
- Because the credits have transaction dates that precede the destination bill's discount expiry date, OneCouncil tries to give them a discount. (Discounts are spawned by the payment being applied).
- But because the existing & already applied post-due-date payments have placed the bill with an outstanding amount less than the discount amount.
Example:
Steps:
(Note: the example shown below is different to the example shown above)
For the charge in which discount > outstanding:
- Unapply the oldest non-split-applied payment applied to the charge. Make sure it has only one application record. (No history of previous unapplications – or else we won’t be able to reapply it)
-
For the newly unapplied payment, calculate how much we can apply = (total outstanding – (discount amount + discount grace amount + 1 for good measure)), then round down to nearest dollar. So in the below screenshot, it was a $30 payment. Total outstanding after step 1 was completed is $68.71 and the discount amount is $30.60 and the discount grace amount is always $10.
Therefore our calculation is: 68.71 - (30.6 + 10 + 1) = 27.11, rounded down = $27
($30 payment; $10 grace amount; Can only apply $27 max otherwise we end up triggering the discount and only having 8.11 that we cannot pay.)
3. Apply the calculated amount to the charge, using the payment we just unapplied.
4. Once you’ve submitted the adjustment (payment application), have a mental pause just in case the adjustment rolls back. Confirm the payment is applied to the charge (give it a minute and refresh the page).
5. Once the original payment is applied, the amount outstanding should be $11 or so dollars from the charge’s net amount (gross – discount). Now we just need to apply the next oldest payment to the charge.
Do not use the original payment – it will not be enough to fully cover the amount outstanding; in our example, $11.11 outstanding is more than $3 left on the payment).
Make sure you’re selecting a payment with the correct revenue type – do not apply water to rates or vice versa.
Make sure you're selecting a payment prior to the destination bill's due date, or the discount won't spawn.
Do not trust OneCouncil to calculate the ~$11 or so outstanding for the second round of manual application – apply an amount equal to outstanding - discount
And we are done – yay.