Vendor > Settle open transactions Error


trying settle two lines, Invoice and Payment, getting error like this “Cannot perform the settlement because there was a sales/purchase book control violation.”

Hello I got the same, possible solution:

  1. Run the debugger;

  2. See in which table is the conflict -“table with conflict”.

  3. In order to update the invoice & payment you should delete entries from this table.

  4. Our support found entries with voucher relation in CustTrans (could be VendTrans)

  5. From CustTrans with voucher filter you copy RecId and filter the “table with conflict” in the field TransRecId. for the invoice records & OffsetRecId for pyment entries.

Hope this will help :slight_smile: