Finance | Project Operations, Human Resources, ...

Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

(0) Share

Report

Posted on by Anette Jansson

105

Hi,

I am trying to settle two customer invoices. One is a debet of lets say 200 EUR. The other one is a credit note of 100 EUR. I use the customer payment journal, go to settle customer transactions and mark both of them. Dynamics calculates that I am to receive a total of 100 EUR, which happens to match my bank statement. When I try to post this voucher I get the error message "Update for voucher LV-00000352 has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount." This is done in an Estonian installation.

If I add the invoices to separate lines in the journal I can post without problem.

A friend of mine tried the same thing in a Swedish installation (other company) and it worked for her. We tried to look at Accounts receivables Settlement parameters, but they were all the same.

What other parameters can have an effect on this?

Anette Jansson

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Anette Jansson 105 on at

Like (0)

Report
RE: Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

I got the following answer from Microsoft

Below is a summary of the support request for your records:

Symptom - You are trying to settle two customer invoices. One is a debet of 200 EUR. The other one is a credit note of 100 EUR in customer payment journal, then you try to post this voucher the error message appears "Update for voucher LV-00000006 has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount." This is done in an Estonian installation.

Cause – intended design
• Resolution - This is intended design for Eastern European localizations since earlier versions.

Its been done to avoid situations with wrong open balance while settling multiple payments with one invoice. In this scenario we recommend to post payment journal first and then to settle posted transactions.

Was this reply helpful? Yes No
Anette Jansson 105 on at

Like (0)

Report

RE: Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

Hi,

In Estonia, Sweden and most other European countries, we use "," instead of "." This goes for everything, not only ERP, but in all applications so that should not have to do with it.

Unfortunately I cannot add pictures in the replies, But I have one debit invoice 200 EUR and one credit invoice 100 EUR. I just mark the mark boxes. Then when posting I get the error message. But if I add another debit invoice, I don´t get the error message.

BR

Anette

Was this reply helpful? Yes No
Anette Jansson 105 on at

Like (0)

Report

RE: Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

Hi,

but then the amounts will be wrong. I want to settle both amounts fully: What is noticeable is that if I mark one invoice with a debit amount and one invoice with a credit amount (the debit amount is larger than the credit amount) I get this error message, but if I mark two debit invoices and one credit invoice then I can post. Right now I have advised my user to make one voucher for the credit end one voucher for the debit.

Anette

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

RE: Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

Hi Anette,

While settling the transaction did you try editing "Settlement amount column" on settlement screen by "100" instead 200 in your example?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

Hi Anette,

If things work fine in your Swedish environment but not in the one for Estonia, then I would suspect the Estonian country specific features being responsible for what you experience.

Have you setup those Estonian localizations yourself or did you make use of a local functional expert from Estonia?

In the latter case ask him/her.

Otherwise, check out the docs sites for the Estonian localization.

docs.microsoft.com/.../estonia

Best regards,

Ludwig

Was this reply helpful? Yes No
MATTGUO 22,344 Moderator on at

Like (0)

Report

RE: Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

Hi Anette,

Why is the value of maximum overpayment 0,10, not 0.10?

Could you please share the screenshots of settlement and payment?

Was this reply helpful? Yes No
Anette Jansson 105 on at

Like (0)

Report

RE: Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

Hi,

I have already read all of those threads, and could not see that it was the same case, only the same error message. I also tested to create two invoices without sales tax and with even amounts and I still got the error message so I don´t think it has to do with the sales tax setup. Regarding the hotfix, shouldn't it be part of the standard by now?

BR

Anette

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Update for voucher xxx has been canceled to avoid oversettlement. The settled customer or vendor balance for the transaction must not exceed the transaction amount

Hello Anette Jansson,

Kindly check below links if it helps to sort out this case. Though the discussions seems related to AX 2012 but still have a look.

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/234987/error-update-for-voucher-xxxxxx-has-been-canceled-to-avoid-oversettlement-the-settled-customer-or-vendor-balance-for-the-transaction-must-not-exceed-the-transaction-amount/647838

https://community.dynamics.com/365/financeandoperations/b/axsupport/posts/oversettlement-error-when-posting-a-retail-statement-in-ax-2012-r2

There is a hotfix information shared by Microsoft but that is for AX2009.

https://support.microsoft.com/en-in/help/2790841/fix-oversettlement-error-message-when-you-try-to-settle-posted-transac

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No