Major Billing / Suspension Issue With Blesta

[kikloo]

Hi,

 

There is something wrong with Blesta, it is suspending services which are due next year i.e 2016 and when I check the services in question, everything in record is fine with them i.e :

 

Date Created: Jul 24, 2014

Date Renews: Jul 24, 2016

Date Suspended: Aug 02, 2015

 

Why blesta is creating invoices for services that is going to renew in 2016 and why then it is suspending them ? I am already tired of voiding the invoices again and again and my clients have also started writing me frustating emails about getting invoices which I keep on cancelling and blesta keeps on re-generating them for no reason.

 

I also checked service records in phpMyAdmin and all seems fine but due to some unknown reason blesta keeps on generating invoices and keeps on suspending services...below is the record for a service that has been suspended by blesta:

 

status: suspended

date_added: 2014-07-24 00:00:00

date_renews: 2016-07-24 00:00:00

date_last_renewed: 2015-07-24 00:00:00

date_suspended: 2015-08-02 17:00:20

date_canceled: NULL

 

When it clearly shows that it was created on 24-07-2014 and last renewed on 24-07-15 and next renewal is on 24-07-16 then why it is generating false invoices and suspending the services ?? I really fail to understand and I don't know what to do anymore with this >

 

Help me please to sort this out.

 

Thanks.

 

[Michael]

Never had that issue myself but the only thing I can think of is there's either:

 

1. An invoice already generated and not closed.

2. A double cron running and it's causing false alarms. 

[kikloo]

Hi,

 

1. There is only 1 cron job running every 5 mins.

2. There was no other invoice open at all. Only 1 falsely generated invoice for the service that got suspended.

 

Its weird but true. You guys must investigate this.

 

Thanks.

[serge]

if I was you I will check:

 

1/

at blesta admin panel at Settings/Company/System  what you year Blesta is displaying close to date format

 

I belive from command line in a terminal/console using/typing :

 

date

 

you can get also get it

 

 

2/

at blesta admin panel at Settings/Company/Billing

 

Check your parameters

 

 

3/

if your invoiced service was created from a custom plugin/module you did?

 

check the appropriate date was well registered in blesta services table

[kikloo]

if I was you I will check:

 

1/

at blesta admin panel at Settings/Company/System  what you year Blesta is displaying close to date format

 

I belive from command line in a terminal/console using/typing :

 

date

 

you can get also get it

 

 

2/

at blesta admin panel at Settings/Company/Billing

 

Check your parameters

 

 

3/

if your invoiced service was created from a custom plugin/module you did?

 

check the appropriate date was well registered in blesta services table

 

hi,

 

please check the attached pics. date is fine i think.

 

Thanks.

[Tyson]

Is your client group overriding the company Invoice and Charge Options shown in your screenshot? If so, you may have different settings configured for the client group that determine invoicing/suspension days.

 

 

Date Created: Jul 24, 2014

Date Renews: Jul 24, 2016

Date Suspended: Aug 02, 2015

 

status: suspended

date_added: 2014-07-24 00:00:00

date_renews: 2016-07-24 00:00:00

date_last_renewed: 2015-07-24 00:00:00

date_suspended: 2015-08-02 17:00:20

date_canceled: NULL

 

 

The renew date and last renew date get bumped when an invoice is generated for the renewing service.

 

Assuming you are using the company Invoice and Charge Options from your screenshot, an invoice should have been created for this renewing service on July 14, 2015 that is due July 24, 2015.

 

Five days later on July 29, 2015, if the invoice has not been paid, the service would have been suspended.

 

So I would like to know whether you have the client group overridding the company settings, and if so, what settings are set? It would be useful to know what invoices were created for this service in the past, on what dates, and whether they have been paid.

 

If you think identical duplicate invoices are being created, it would also be useful to know when they are being created and how often. Usually something like this occurs if the cron logs are missing or have been deleted for recent cron runs of the Create Invoices task. How often is your cron running?