Regular Member
Posts: 377
Registered: ‎01-18-2017
Kudos: 123
Solutions: 13

Serious invoicing problem

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

Veteran Member
Posts: 4,579
Registered: ‎05-19-2009
Kudos: 833
Solutions: 23

Re: Serious invoicing problem

did going back to the last backup fix the issue?

what version of UCRM are you running?

is it hosted on a local Debian box or inside a VM?
Ubiquiti Employee
Posts: 3,927
Registered: ‎12-10-2015
Kudos: 1384
Solutions: 300

Re: Serious invoicing problem

@clarkraymond to help us investigate this issue, it would be very helpful if you could send us the CSV export of the client's log (or the whole db backup)
Regular Member
Posts: 377
Registered: ‎01-18-2017
Kudos: 123
Solutions: 13

Re: Serious invoicing problem

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

Regular Member
Posts: 377
Registered: ‎01-18-2017
Kudos: 123
Solutions: 13

Re: Serious invoicing problem

PM sent with dropbox link

Ubiquiti Employee
Posts: 3,927
Registered: ‎12-10-2015
Kudos: 1384
Solutions: 300

Re: Serious invoicing problem

@clarkraymond thanks, we will fix it ASAP.
Regular Member
Posts: 377
Registered: ‎01-18-2017
Kudos: 123
Solutions: 13

Re: Serious invoicing problem

[ Edited ]

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.

 

screenshot-ucrm.citylessinternet.com-2019.01.02-09-34-17.png
Ubiquiti Employee
Posts: 3,927
Registered: ‎12-10-2015
Kudos: 1384
Solutions: 300

Re: Serious invoicing problem

The fix for "thousands of invoices" will be released in 2.14.4 and 2.15.0-beta3 today/tomorrow.

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.
Regular Member
Posts: 377
Registered: ‎01-18-2017
Kudos: 123
Solutions: 13

Re: Serious invoicing problem

My plan was to end our premium service on 1/1 and start our economy service on the same date. I suppose I don’t know how to make that work.

Ubiquiti Employee
Posts: 3,927
Registered: ‎12-10-2015
Kudos: 1384
Solutions: 300

Re: Serious invoicing problem

You have two options:

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)

Regular Member
Posts: 377
Registered: ‎01-18-2017
Kudos: 123
Solutions: 13

Re: Serious invoicing problem

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.

Ubiquiti Employee
Posts: 3,927
Registered: ‎12-10-2015
Kudos: 1384
Solutions: 300

Re: Serious invoicing problem

@clarkraymond
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