I’m sitting with a few Customers where there is Open Receivables Invoices that have a Negative Balance. I need to know if someone dealt with this before and how you resolved it please:
Kind Regards
Marilize van Zyl
Page 1 / 1
Hello @marilizevanzyl ,
Please try running the Receivables Process Recalculate Customer Balances. Check ON the option for Document Balances. Please let us know the result. Thank you.
Laura
Hello @marilizevanzyl
I hope “recalculate customer balances” will fix the issue.
If this not resolves the issue
Please show me the application tab of the invoice. Is there any applied document?
If yes, open that document and provide a screenshot of the applied document's application history tab as well.
Hi @Laura02
Thanks for the quick response, I have tried that now, still showing a negative Balance. The weird thing is the Customer Details for the specific customer the “Balance Discrepancy” is 0.00. So it’s not even picking up that their is something wrong on the Customer.
And because the Balance is negative on the Invoice it’s not allowing me to reverse the Application to correct the Balance.
Marilize
@marilizevanzyl Check if the application history of the payment which has been applied to the invoice has a line item with a negative balance of -1506.61.
I would recommend trying these steps in the test environment before making changes in the production environment.
Select the line item with the negative balance of -1506.61 and click reverse application on the application history of the payment.
Hi @MuthumaliDhanushika27
Yes, there is a few Applications, here is the screenshot:
Marilize
Hi @MuthumaliDhanushika27
My apologies, that was the other one on the same Customer:
Marilize
Hi @KushaniPerera88
There is only the Voided Payment on there, no other negative Payment.
Marilize
Hi @marilizevanzyl were you able to find a solution? Thank you!
Hi @Chris Hackett
No I wasn’t, I opened a Acumatica Support Ticket which is still pending.