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."

(0) Share

Report

Posted on by axapta thailand

245

Error occur while posting AR Voucher , "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."

Please help,

Thank you

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Have a look at settlement parameters here -

https://technet.microsoft.com/en-us/library/hh545528.aspx

1 people found this reply helpful.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Chaianan Jantoo,

What voucher are you posting exactly?

Can you provide more details on the transaction that you entered and at what time/stage the error was triggered?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi all,

Did you find the solution for this issue?

I changed the tax setup as advise from support case but still got above error message:

I would advise setting the Sales Tax Group for your store (General Ledger>>Setup>>Sales Tax>>Sales Tax Groups) to rounding by "Sales Tax Code Combination". For the Sales Tax Codes (General Ledger>>Setup>>Sales Tax>>Sales Tax Codes) set the Marginal base field to "Net amount per line". This will help going forward

I also changed the Maximum penny difference to largest number already.

The link to support case:

community.dynamics.com/.../oversettlement-error-when-posting-a-retail-statement-in-ax-2012-r2

Was this reply helpful? Yes No
Bizon on at

Like (0)

Report
Copy link

Link copied!

Same issue for me. I applied the changes as per nglehang and still same error shows up.

If someone could help, it would be very appreciated it.

Was this reply helpful? Yes No
Ilango 45 on at

Like (0)

Report
Copy link

Link copied!

I faced the same problem and on verification it was found that the referred voucher has been settled in full but the closed date in the CustTrans form is not updated. Hence the system tries to settle the referred voucher and found it is over settlement and throw error. - ILANGO PANDIRAJAN

Was this reply helpful? Yes No
Ilango 45 on at

Like (1)

Report
Copy link

Link copied!

The voucher referred has been fully settled but in the "CustTransOpen" table, it shows "0". Also, in "CustTrans" table, the fields- "LastSettlementVoucher", "LastSettlementDate", "LastSettlementAccountNumber", "LastSettlementCompany" and "Closed" are not updated.

In this case, the system throws the said error.

To correct the same, from backend, the fields are to be updated in the "CustTrans" table and delete the line from the "CustTransOpen" table.

Then you can post the journal and it will be through.

Was this reply helpful? Yes No
Suggested answer

Kadir Karaman 125 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The CustTrans.AmountCur field value does not equal the CustTransOpen.AmountCur field value. Since these fields are not equal, there is an excess balance when closing with a new balance. It should be checked that the field values are equal.

Best regards,

Was this reply helpful? Yes No