AX 2012 R3 Error Message: Cannot create a record in Balance (CustVendTempOpenTrans). Amount 0,00. The Record already exists.

Problem:
Please see the message as given below:

This issue comes when you try to settle a customer/vendor.Reason:

One record (may be payment/Invoice) already marked for settlement.
how to find it.

Solution: 


Try to override this error and find the record which is marked for settlement.

Step. 1:

AOT > Classes > CustVendOpenTransBalancesManager

Method Name: add

Make all comment and add new lines. see as following:

then find the marked transaction. It is happening because of error in updation of transaction.

Step.2:

Now go to

AOT > Tables > SpecTrans

Find the the record there.

Delete it and you can continue.

This issue will not come later.



Wish you all the best.

Have a nice day!!!