Order Payment Status not updating for some Canadian orders

[msalman]

We are recently having problems with the payment status of a few Canadian orders.
We have already captured payments for these orders but on the Orders listing page, their Payment status is showing as 'Captured' rather than 'Paid'.
In the database also, the PaymentStatusId field in the ac_Orders table for these orders is set to 1 instead of 2.
We need the status to change to paid so that these orders can be imported to QuickBooks

After failing to figure out the problem, we manually set the PaymentStatusId in the ac_Orders table to 2.
This worked but as soon as we opened the Orders Detail page(Admin/Orders/ViewOrders.aspx), the payment status changed back to unpaid.
We are not sure what is triggering the order payment status to change back to unpaid when the payment has already been captured. Its only happening with a few Canadian orders but we have already compared these orders with others and didn't find anything different.

[mazhar]

AbleCommerce calculates payment status based upon the transactions, AbleCommerce will recalculate it each time some one opens the orders depending upon transactions made for that payment. It seems to me that you are using some custom payment gateway so make sure that you have handled the transactions properly.