01-01-2019 07:01 AM
Had a client scheduled to end one service and begin another on 1 Jan. Checked the system this morning and something terrible went wrong:
This client had over $10,000 credit
Thousands of invoices had been created for $3.33 each for this client
No other invoices were generated nor sent
I killed UCRM and restarted. Saved a backup with the error, loaded the last backup before this mornings invoice run, manually changed the subject clients service and manually kicked off invoice generation.
I saved both databases but they are both around 13 MB each
01-01-2019 07:14 AM
what version of UCRM are you running?
is it hosted on a local Debian box or inside a VM?
01-01-2019 10:18 AM
did going back to the last backup fix the issue? YES
what version of UCRM are you running? 2.15.0-beta2
is it hosted on a local Debian box or inside a VM? Running Debian in a VM
01-02-2019 07:13 AM - edited 01-02-2019 08:41 AM
Petr, every PayPal subscription was cancelled with no human intervention.
I spoke with PayPal and they have record of UCRM cancelling all of them. Here is a snippett from the system log.
I checked settings->client zone->Payment Subscriptions and Custom is on as always and linked is off as always.
I have lots of upset customers and I don't know what to tell them! Please help, this is urgent.
01-03-2019 05:46 AM
The problem happens only when there is some prorated period and only 1 day is invoiced - make sure this is what you wanted. Maybe a wrong date of a planned deferred change of a service? Anyway, in the new versions, there won't be any problems with single day periods.
01-03-2019 08:16 AM
1) If you want the change to be applied to the very next period (the next not yet invoiced period): just go to the service, click "the pencil" at the Billing Settings Box and change the service plan. All the following invoicing will use this new service plan.
2) If you want the change to be applied some day in the future, set up the "deferred change" and specify which date you want to apply the change. Typically, it would be 1st of a month.
For example: WISP wants Jan, Feb to be invoiced according to the current service plan. From Mar, WISP wants the service to be upgraded. So, the WISP needs to set up a deferred change for 1st Mar, (This setup can be done now, i.e. Jan 3rd)
01-03-2019 05:50 PM
UCRM should NEVER cancel recurring subscriptions without administrator approval! The fact fact that they were cancelled is causing much pain and seriously angry customers. Please change UCRM to require superadmin approval before cancelling recurring payments.
01-04-2019 07:59 AM
2.15.0-beta3 has been just released. There are several fixes and UX improvements which will prevent the issues you had. https://community.ubnt.com/t5/UCRM/New-UCRM-hotfix-version-2-15-0-beta3-released/m-p/2618984#M13142