AbleCommerce Shopping Cart Software

Hi There,

Can anyone kindly help me figure out some SQL code to locate negative remaining balances in orders? We normally have negative balances when customers are due refunds because they either remove items from their order or downgraded their shipping. I need some SQL Code to help me locate the negative remaining balances so we can give them refunds.

I played around with it for few hours but ran out of ideas.

Thanks

50 bucks via Paypal for someone that can help me figure this out.

Must be SQL Code.

Fields needed:

Order Number, Order Date, and Negative Balance AMT

Calvis, here is a basic query, but you probably want something more complicated?
select ordernumber from ac_orders where TotalCharges-TotalPayments <0

Prefect, that got me going in the right direction. I was able to find the orders that I need to give a refund to.

Send me your Paypal address and I will shoot you a gratitude of my appreciation.

calvis,
I can't take a payment for that, but I do appreciate the offer. I was thinking it was going to be complicated also until I remembered that the order table had a total payments field.

You are right, I never knew there was a TotalCharges and TotalPayments field.

I thought I was going to have to calculate those fields during the query so I could make it work. Thanks to you a few customers got their refunds that were due.