Skip to main content

Hi Acumatica Community

 

Hope everyone is well.

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

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.


Reply