Settlement issue in AX2012R3

After I done the data migration from AX2012FP to AX2012R3 customer realize that there are some issues in the settlements some of them are not appearing in the Settle Open Transactions and others are not not appearing either in the Settle Open Transactions or Closed Transaction Editing then i found the solve the issue after using the below SQL script and I found the transactions appearing in Settle Open Transactions then you can settle your transactions

UPDATE    VENDTRANS

SET              APPROVED = 1, SETTLEMENT = 0

WHERE     (ACCOUNTNUM = Vendor ID)