Solved

Error trying to close an Invoice

  • 8 November 2023
  • 13 replies
  • 85 views
D
Rank
Userlevel 4
Badge
  • Del
  • 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

manikantad18
Rank
Userlevel 7
Badge +12

Hi @Del 

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

Acumatica Functional Consultant
D
Rank
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.

Laura02
Rank
Badge +18

Hello @Del ,

Manikanta refers to Recalculate Customer Balances screen:

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
D
Rank
Userlevel 4
Badge

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

Laura02
Rank
Badge +18

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

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
D
Rank
Userlevel 4
Badge

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

 

Laura02
Rank
Badge +18

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

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
D
Rank
Userlevel 4
Badge

 

D
Rank
Userlevel 4
Badge

 

Laura02
Rank
Badge +18

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

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
D
Rank
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.

Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
NuwanTharanga62
Rank
Userlevel 4
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


Terms & ConditionsCookie settings
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