Tweet
I just had my first refund of a paid subscription. I wrote a custom progress bar that shows progress towards a paid subscription goal per month, and it works great...but what I noticed is when someone is issued a refund, the payments system shows a reversal, but the amount is 0 dollars, not negative the value. So doing a little research, I noticed the amount field in the database for payment info transactions is unsigned. I'm wondering if for statistic purposes, should I check for reversal and cross reference the original payment id and subtract that (a lot of work) or should the amount field be signed so it can handle negative values?
