change product/service to One Time via database

[PixelPaul]

hello all,

Does anyone know of all the columns that need to be change to update a product/service to be "One Time" and to no longer create invoices? but via the database.

I have tried the table tblhosting and changing the columns as such:

billingcycle = One Time
nextduedate = 0000-00-00
nextinvoicedate 0000-00-00

but even with those updated to the above values, when the automated tasks cron runs, it will generate a new invoice for that service. And it even generated an invoice for services that would of been due for renewal in 3 years. So the invoices are created early now.

[twhiting9275]

Simple answer: 
Don't do it. The backend provides all the capability you need to do this

[PixelPaul]

Just now, twhiting9275 said:

Simple answer: 
Don't do it. The backend provides all the capability you need to do this

no it doesn't,  and i am doing it via a module i am creating.

[PixelPaul]

i have done a database data comparison of before and after i change the billing cycle via WHMCS backend and there is no other columns or tables that get changed ( excluding the logs )

so this make no sense to me how the invoice can still get created.