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!
Best answer by NuwanTharanga62
Del wrote:
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.
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.
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 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.
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
