Promo ended however amount has not increased

[aquiss]

I've come across a handful of client accounts, purely by luck, that were on a promo with reduced monthly rates at the start of their membership, that has since ended. However, it would appear in some cases where the promo had ended, the recurring fee has NOT increased and remains still at the promo reduced rate, even though no active promo is now live on the customer. For the most part, it has worked and changed the recurring price, but in a few odd cases, it has not.

As I can't see a report from within WHMCS to allow me to find client in this state, does anyone have a MySQL statement that could create a list to of services that the "firstpaymentamount" and "amount" equal the same value? In theory that will then allow me to check customers.

[brian!]

20 minutes ago, aquiss said:

As I can't see a report from within WHMCS to allow me to find client in this state, does anyone have a MySQL statement that could create a list to of services that the "firstpaymentamount" and "amount" equal the same value? In theory that will then allow me to check customers.

SELECT * FROM tblhosting WHERE tblhosting.firstpaymentamount = tblhosting.amount