Solved

Error trying to close an Invoice

  • 8 November 2023
  • 13 replies
  • 78 views

Userlevel 4
Badge
  • Freshman I
  • 39 replies

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!

icon

Best answer by NuwanTharanga62 20 December 2023, 12:12

View original

13 replies

Userlevel 7
Badge +12

Hi @Del 

Please perform the recalculate customer balance once  for particular customer and check?

Userlevel 4
Badge

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.

Badge +16

Hello @Del ,

Manikanta refers to Recalculate Customer Balances screen:

 

Userlevel 4
Badge

We tried this in our test system and we still get the same error. 

Badge +16

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

Userlevel 4
Badge

Here is a screen shot of the invoice showing the Applications tab.

 

Badge +16

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

Userlevel 4
Badge

 

Userlevel 4
Badge

 

Badge +16

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?

Thank you.

 

Laura

Userlevel 4
Badge

Laura02

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.

Userlevel 7
Badge

Hi @Del were you able to find a solution? Thank you!

Userlevel 3
Badge +1

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.

Thanks!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved