Affiliate reset

-- HikaShop version -- : current
-- Joomla version -- : current
-- Error-message(debug-mod must be tuned on) -- : none

I had some affilaites set up just to track inbound traffic from google adwords etc. I had a click fee in there.
I am trying to reset it so that the balance is zero. I click on total unpaid amount and it says I'm about to pay 0 and I hit proceed.
It still shows a balance.
I even went into the database and under that hikashop user record I set the unpaid amount to zero, but it refreshes as the amount being unpaid. So it's calculating it from somewhere else and putting it in there.
How can I reset the amount paid?
If it were a real affiliate, and I paid them by check or whatever, I would need to reset this to keep track.

It would be awesome if there were a button somewhere to clear it out or better yet if we could see the current balance vs lifetime balance for an affiliate.

Meanwhile, would you be able to help me with a sql command to reset those columns to zero?

Thanks