Issue Description
We have an invoice with 10 installments. The invoice has status "Open".
One of the installment payments has been voided. So currently there's still 100 EUR due.
However, we cannot apply a transaction for that remaining 100 EUR. When we try making a payment, we cannot select the invoice.
I've already noted the following:
The voided payment is applied to a voiding journal for 100 EUR. However, it also still seems to be applied to the invoice (checkbox is checked in apply column). In view mode it even seems like the payment of 100 EUR is applied for 200 EUR. When editing the payment, the payment amount on the invoice line is shown as 0 though.
I thought the reason for being unable to apply a new payment to the invoice might be because of that voided payment still being applied to the invoice. That's why my first instinct was trying to unapply the payment from the invoice and see if that solved the issue.
Nonetheless, I couldn't find a way to unlink the invoice with the voided payment without getting errros. I've played around with the same transaction in Sandbox and tried to:
1. Delete the voiding journal
2. Delete the payment
3. Unapply the payment to the invoice
None of them worked.
Problem can be reproduced by creating an invoice with installments, making separate payments for all installments and then voiding one of those installmetns.
NetSuite Support Answer
I already logged a support ticket and got following answer:
Upon checking in our internal QA environment, I was able to reproduce the behavior with clicking "Accept Payment" on Invoice VF-EV-22-04075 that shows open amount of 100 EUR. When I clicked the button, the Invoice did not appear on Payment page.
I was unable also to delete or unapply Payment PAYEV5719 due to the errors.
Upon my checking of EFT tab on Payment PAYEV5719, there are Entity Bank Details information specified. This indicates that the Payment was processed with Electronic Bank Payments functionality.
When I checked reversal Journal DIV-EV-23-02415 (System Information > System Notes), the Journal was created by script.
In Memo field of Payment PAYEV5719 it is specified that the Payment belongs to Payment File Administration 00001193. Upon checking Payment File Administration 00001193, the status is Cancelled and last process initiated is "Reverse Payments". According to the System Notes of the records, the Payment File Administration was created on 16 May 2023 and was reversed on 19 June 2023. These dates correspond to creation of Payment PAYEV5719 and reversal Journal DIV-EV-23-02415, according to System Notes of these transactions.
This means Invoice VF-EV-22-04075 was paid, then the installment Payment was reversed with Electronic Bank Payments functionality.
Upon my checking, this is known limitation of the system and is filed under enhancement:
635085 - Electronic Bank Payments > Direct Debit > Reverse Payment with Installments > Installment is still paid and cannot be processed again
There is no documented alternate solution or workaround for this enhancement.
Upon checking the enhancement, please note that it is recommended to avoid using reversal for installment invoices.
According to SuiteAnswers article 86789 Installment Payment Support:
Invoice Payment Processing does not support the Reversing Payment feature for Installment Payments.
To vote for product enhancement, please use SuiteIdeas page (SuiteAnswers ID: 30288).
Question
Is there anyone who has ran into the same problem and found a solution / workaround for this? Any suggestions on how to proceed?
Two things might help?:
- An alternative suggestion on how we might be able to force NetSuite to apply a payment to the open invoice.
- A suggestion on how we can unapply the old payment from the invoice without getting an error. (as I'm pretty sure this is what blocking us from applying a new payment)
The open invoice has an impact on the dunning that have been implemented in NetSuite.