View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Notification over invoice - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Notification over invoice

More
21 Fév 2021 16:22 #1 by mcanuto
Hello,

I'd like to generate a notification when the invoice planned Due Date is near, but I keep getting an error when I try to save it :2021-02-21 16:10:13.803 ***** ERROR ***** [V9.0.4] Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'term.initialDueDate' in 'field list'
2021-02-21 16:10:13.804 ***** ERROR ***** [V9.0.4] For query : SELECT term.id AS Term_id,term.initialDueDate AS Term_initialDueDate,term.name AS Term_name,project.name AS Project_name,term.paymentDate AS Term_paymentDate,project.idUser AS Project_idUser FROM term LEFT JOIN project ON project.id=term.idProject WHERE isnull (term.paymentDate)
2021-02-21 16:10:13.804 ***** ERROR ***** [V9.0.4] Strack trace :
2021-02-21 16:10:13.804 ***** ERROR ***** [V9.0.4] #0 Sql->query called at [/var/www/html/projeqtor/model/NotificationDefinition.php:997]
2021-02-21 16:10:13.804 ***** ERROR ***** [V9.0.4] #1 NotificationDefinition->getLines called at [/var/www/html/projeqtor/model/NotificationDefinition.php:1304]
2021-02-21 16:10:13.804 ***** ERROR ***** [V9.0.4] #2 NotificationDefinition->generateNotifications called at [/var/www/html/projeqtor/model/NotificationDefinition.php:441]
2021-02-21 16:10:13.804 ***** ERROR ***** [V9.0.4] #3 NotificationDefinition->save called at [/var/www/html/projeqtor/tool/saveObject.php:110]

And after this, I can't change the screen because it keeps telling me to save or ignore changes which I can't do either save (in error) nor ignore (the button is unavailable).

Can you help me doing this, please?

Thanks a lot.
Regards,
MCanuto

Please Connexion or Create an account to join the conversation.

More
23 Fév 2021 09:28 #2 by babynus
Replied by babynus on topic Notification over invoice
Can you show screenshot before you save ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
28 Fév 2021 16:49 - 28 Fév 2021 16:53 #3 by mcanuto
Replied by mcanuto on topic Notification over invoice
Hello,

here is what I'm trying to do: 
 


When I try to save I get this
 

but I don't know how to create a rule over this element because in the choices I don't have the Client invoice: 


so I'm not able to choose Client invoice's fields to create my message or my rule.

I hope this is more clear now.

Regards,
Mcanuto
Attachments:
Last edit: 28 Fév 2021 16:53 by mcanuto.

Please Connexion or Create an account to join the conversation.

More
01 Mar 2021 14:28 #4 by babynus
Replied by babynus on topic Notification over invoice
Sure, there is an issue.
When you select "notifiable item" to "Client Invoice", the field "select item" shoiw not propose "Action"...
There is a refresh issue.
Ticket #5334 recorded

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.079 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.