trying to remove 2 entries from database

[djpete]

I have these 2 entries see arrows on screenshot that I need to remove as they seem to be stuck there. They have both been paid and are not due. I have some custom code to show this layout which has been used by a few people on the forum. It works well but I think I have done something wrong on a few orders that have messed these two up.

I tried looking through database but no joy.

I am using version 4.5.2.

 

Any help appreciated.

[m8internet]

Let's try WHMCS first, looks like the payment has simply not been completed

 

Go to invoices

Check it is marked as PAID

If so, check the payment tab and ensure a payment is recorded

If not, mark as UNPAID and then add a payment, with appropriate date

 

If a payment has been recorded

Go to the appropriate item

Check the next renewal date

On the first this will be :

05/12/2011

Update this manually

On the second this will be :

03/04/2012

Update this manually

 

As these are bank transfers you need to process the payments manually (ie confirming you have actually received the money)

I tend to add these to the To-Do-Items list manually if the customer has marked it as PAID but no payment has yet arrived, with a date 3 days in advance (that way once the 3 days has passed I then contact the customer to advise the payment has not arrived)

 

Once the payment has arrived, as above click on the Invoice, then the payment and add the date it arrived in the bank account along with the transaction reference

The customer then receives an email confirmation which acts as the receipt

This action also updates the renewal date

 

It's a bit clumsy, but this is currently the only way to process manual payments (the same as if a customer paid you cash or cheque)

[djpete]

appreciate your time on this. I had sort of done all that but it got me thinking and I saw the "Auto Recalculate on Save" checkbox next to the product recurring amounts and thought maybe that will get things back in sync. Did it for the first product with success and then the second as well.

They are now gone and all seems well again.

Yeeha.

[djpete]

Sorry double post, cant delete

[djpete]

actually I still have the issue with the $246 amount. It is still there even though I have marked it not paid and then paid again.

:-(

[djpete]

its ok I just had to update the renewal date for that one. Done

[m8internet]

I saw the "Auto Recalculate on Save" checkbox

You use this is the prices are volatile and change regularly, or you are changing a customers products / services

 

As an example I had to change a client from 2 year to 1 year

The price initially was £2

On changing it remains as £2

So if you use this option, when you change their product it also changes the price

[m8internet]

its ok I just had to update the renewal date for that one. Done

Yes, my reply in post #2 advised how to complete both together, rather than just one of them

[djpete]

Thanks again m8internet. All done and working.

Appreciate your help.