Reply
Ubiquiti Employee
Posts: 3,906
Registered: ‎12-10-2015
Kudos: 1376
Solutions: 299

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

@pcwestern you can move a client from organization A to organization B (having another currency) only on condition that the given client has no invoice, payments or refunds in the currency of the organization A.
New Member
Posts: 30
Registered: ‎01-24-2016

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

Hi

I'm having an urgent issue with draft generation: no matter how many days in advance is set, no generation occours. I tried manual generation of draft and nothing happens. Log shows:

 

10:28:43 INFO      [app] Searching for clients for invoice generation (invoicing day "2018-12-29").

10:28:44 INFO      [app] Enqueued 36 clients for invoice generation.

 

Clients are actually about 1000 and all services period end at the end of month.

 

thanks in advance

New Member
Posts: 30
Registered: ‎01-24-2016

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

Please find attached log files with errors on database connection such as:

In PDOConnection.php line 43:

[PDOException (7)]
SQLSTATE[08006] [7] FATAL: the database system is shutting down

New Member
Posts: 30
Registered: ‎01-24-2016

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

Further investigation revealed 2 possible bug:

 

1.  pgbouncer not running

 

2018-12-29 10:35:39,550 INFO success: pgbouncer entered RUNNING state, process has stayed up for > than 0 seconds (startsecs)

2018-12-29 10:35:39.550 861 FATAL @SRC/main.c:628 in function check_pidfile(): pidfile exists, another instance running?

 

This problem showed up appearently after reboot

 

 

2.  when all draft were generated on 30/11/18, last invoiced date was set to 31/12/18 as well as Next invoicing day; this explains why is not generating any draft now.  We reverted back a few clients to 30/11/18 and drafts were generated but last invoiced date was then set to 31/1/19, same as the Next invoicing day.

 

Both problems are quite blocking... is it a problem with our installation/update or is it a bug?

Screen Shot 2018-12-29 at 15.51.14.png
Screen Shot 2018-12-29 at 15.50.54.png
Ubiquiti Employee
Posts: 3,906
Registered: ‎12-10-2015
Kudos: 1376
Solutions: 299

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

@stefanormc which UCRM version are you currently running?

 

> when all draft were generated on 30/11/18, last invoiced date was set to 31/12/18 as well as Next invoicing day; this explains why is not generating any draft now.

 

I believe this is correct. Your invoicing period is set from 1st to last day of a month. And you are generating the invoice 1 day in advance, which is for example:

1st Dec - 1 = 30th Nov

1st Jan - 1 = 31th Dec (that's why no invoice is generated on 30th Dec or before)

 

Are you sure there are some clients' services eligible for invoicing which are not invoiced yet? If so, please send us a screenshot of the service's billing configuration + the export of the client's log which could be helpful for investigation.

New Member
Posts: 47
Registered: ‎04-03-2018
Kudos: 87

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

Nice the proforma

Can we have a function to separete the view of regular invoice and proforma 

The possibility to view only proforma or only the invoice 

New Member
Posts: 30
Registered: ‎01-24-2016

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

Hello Petr
 
Thanks for the reply; you are right. I got a little confused by the error on postgres (that was solved by restoring the DB) and by the field ‘Last invoiced date’ which I wrongly interpreted as last invoice date as opposed to last service day that was invoiced. Add a little year-end panic and voliat… 
 
Thanks
 
Ciao
 
Stefano
Emerging Member
Posts: 58
Registered: ‎07-24-2013
Kudos: 19
Solutions: 3

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

UCRM no longer sends new invoice notification to clients. Two separate UCRM installs, same behavior. Notification to events are sent to company email.

Ubiquiti Employee
Posts: 3,906
Registered: ‎12-10-2015
Kudos: 1376
Solutions: 299

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

[ Edited ]

@subseven-group please make sure the "demo mode" is disabled. Demo mode is used exactly for this reason: to send all the emails to you instead of the clients. Read more about sandbox: https://help.ubnt.com/hc/en-us/articles/225882688-UCRM-Sandbox-Mode

 

also check whether your clients have correct emails configured.

 

Selection_999(291).png

Emerging Member
Posts: 58
Registered: ‎07-24-2013
Kudos: 19
Solutions: 3

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

That's not the case. Demo is definetily disabled. It was working before the update. All email contacts are correct. Updating to beta3 now to see if it fixes the issue.

Veteran Member
Posts: 4,559
Registered: ‎05-19-2009
Kudos: 824
Solutions: 23

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

Emerging Member
Posts: 58
Registered: ‎07-24-2013
Kudos: 19
Solutions: 3

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

[ Edited ]

There are 2 sections the one you pointed out is for global notification, which works and Client Notifications which is not working, but is on.clientnotification.png

Veteran Member
Posts: 4,559
Registered: ‎05-19-2009
Kudos: 824
Solutions: 23

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

Emerging Member
Posts: 58
Registered: ‎07-24-2013
Kudos: 19
Solutions: 3

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

I can confirm that after upgrading to Beta 3 it's still not working. So if we create an invoice manually and click save and send, the invoice gets send out without issue, if the invoice is automatically generated from services it's not being to send queue and client email does not receive it.

Veteran Member
Posts: 4,559
Registered: ‎05-19-2009
Kudos: 824
Solutions: 23

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

[ Edited ]

sounds like the billing tag was removed from the clients contact email 

 

 

also, note that plugins such as the tower coverage plugin strip the billing tag when they create the lead

 

so be sure to add the billing and general tags back before converting a lead to client

Emerging Member
Posts: 58
Registered: ‎07-24-2013
Kudos: 19
Solutions: 3

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

Checked all flags. They are on: Billing and General. No plugins are being used. This is same behavior across 2 different iterations of UCRM. After the invoice is generated via services and you go to Invoices you can see an email icon next to newly generated invoice. If clicked than the email is sent. Looks like automatic invoice sending is disabled even though it's enabled in the System->Customization->Notification Settings.

Emerging Member
Posts: 58
Registered: ‎07-24-2013
Kudos: 19
Solutions: 3

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

System notification to internal email with subject: "Recurring invoices have been created" is being sent without an issue.

Ubiquiti Employee
Posts: 3,906
Registered: ‎12-10-2015
Kudos: 1376
Solutions: 299

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

@subseven-group please check the client log, and let us know if you some error message there or whether you don't see any notice about sent email at all. (You can also check the globel mailing log at: System > Logs > Email log)

 

Selection_999(292).png

Veteran Member
Posts: 4,559
Registered: ‎05-19-2009
Kudos: 824
Solutions: 23

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

what about under /system/billing/invoicing

 

do you have Approve and send invoices automatically ON ??

Emerging Member
Posts: 58
Registered: ‎07-24-2013
Kudos: 19
Solutions: 3

Re: New UCRM hotfix versions 2.14.3 and 2.15.0-beta2 released!

logs.png

Reply