Auto Cancel Invoice After X Days If Un-Paid

[kikloo]

Hi,

 

Is auto cancel invoice after X days if un-paid feature going to get implemented in blesta ??? Or is there any plugin that can be used now ???

 

Thanks.

[kikloo]

I just reliased that only this little query is all that takes to cancel the invoice that are 30 days old, not paid and has status as 'active'. The query will just change status from 'active' to 'void'.

 

UPDATE invoices SET status = 'void' WHERE 
status = 'active' AND
paid = '0.0000' AND
date_closed IS NULL AND
date_due + INTERVAL 30 DAY <= NOW();

You can change 30 to any number of days you like in the query.

 

Thanks.

[Blesta Addons]

and what if you have invoice including multiple services, and only 1 service is cancelled by client ? your query will void all the invoice and you will lose payment for some active services !!!!!

[kikloo]

I don't use mukti service invoice. So it works for me.

[evolvewh]

I know they also have this task assigned. I couldn't tell you when they plan on doing it:

 

http://www.blesta.com/forums/index.php?/topic/2981-cancel-orders-that-are-days-old-automatically/

[Blesta Addons]

I know they also have this task assigned. I couldn't tell you when they plan on doing it:

 

http://www.blesta.com/forums/index.php?/topic/2981-cancel-orders-that-are-days-old-automatically/

 

the two task is different , the first one for unpaid renewal service , the second for unpaid new orders .

 

the task for OP request is here https://dev.blesta.com/browse/CORE-1686 .

 

the second task can be done via a custom plugin also .

[Michael]

I know they also have this task assigned. I couldn't tell you when they plan on doing it:

 

http://www.blesta.com/forums/index.php?/topic/2981-cancel-orders-that-are-days-old-automatically/

 

 

CORE-1686 is set for 4.0 so should be in that version .

[Paul]

CORE-1686 will be in 4.0, which causes unpaid (and not past due) invoices to be voided when a service is cancelled. For auto cancellation, there is a plugin that already ships with 3.6 called Auto Cancel that can automatically schedule services for cancellation after a certain period of time. These will work together, meaning, services scheduled for cancellation with this plugin will have unpaid invoices voided (that are not past due) when cancelled.