We have an invoice that is showing a Status of Balanced, and when we try to release it we receive the following error.
Error: Inserting 'Applications' record raised at least one error. Please review the errors. The total application amount, including the cash discount and the write-off amounts, cannot be negative.
We have looked though the entire order and cannot figure out what the issue is. We have looked at other invoices that have been completed and we can not find any differences.
Anyone have an idea what this error message is refering to or where we need to look to fine the problem.
Thank you!
Page 1 / 1
Hi @Del
Please perform the recalculate customer balance once for particular customer and check?
manikantad18
Thank you for your quick reply!
Is “recalculate customer balance” the same as Recalculate Prices?
If so we have tried that and get the same error.
Hello @Del ,
Manikanta refers to Recalculate Customer Balances screen:
We tried this in our test system and we still get the same error.
Hi,
Please, show a picture of the invoice showing the original amount, balance, and the applications tab.
At the time of the error, if you click Tools → Trace, is there any additional error message or messages shown that may help us recognize the problem?
Thank you!
Laura
Here is a screen shot of the invoice showing the Applications tab.
Hello,
I didn’t realize from previous posts that there are no payments, no applications and the discount is 100%.
Can you show the discount tab please? And the Detail lines so we can see line discount fields.
And the Trace. Thank you!
Laura
Hello Del,
Is this order editable? If so, and in the interest of pushing it through, have you already tried removing discounts from the Discounts tab, saving, and then adding back the discounts?
Does it make any difference if you remove the discount from the Discounts tab and replace it with 100% discounts on each of the three detail lines?
One more idea: instead of using line discounts or discounts on the Discounts tab, could you fill in a Cash discount in the header of 115.60?
We have tried your suggestions and still receive the same error. At this point we have turned it over to our integrator / support partner.
Thank you to everyone who has trying to assist us with this issue. You all are a great asset.
Hi @Del were you able to find a solution? Thank you!
We have an invoice that is showing a Status of Balanced, and when we try to release it we receive the following error.
Error: Inserting 'Applications' record raised at least one error. Please review the errors. The total application amount, including the cash discount and the write-off amounts, cannot be negative.
We have looked though the entire order and cannot figure out what the issue is. We have looked at other invoices that have been completed and we can not find any differences.
Anyone have an idea what this error message is refering to or where we need to look to fine the problem.
Thank you!
Hi @Del,
Can you check if customer 010101 has the Auto-Apply Payments option selected?
If so, when invoices get released, the open payments and credit memos are applied to the invoices.
Also check if there are payments that have a balance below zero (negative).
Ex:
They should have applications to the whole amount of Credit Memo/invoice, so the total balance became below zero.
To fix an open balance of payments with negative amounts, could you please try the following:
1. On the Payments and Applications screen (AR302000), open a payment
2. Go to the Application History tab and decide which application was incorrectly applied
3. Select an incorrect application and click Reverse Application
As a result, the available balance of the payment should be changed to 0.
(Optional). If the status of the payment won't be changed to closed,. Go to the Validate Customer Balances screen (AR509900) and process the validation.
If above does not help, I would suggest creating a support case to Acumatica.