Forum

Notification over i...
 
Notifications
Retirer tout

Notification over invoice

4 Posts
2 Utilisateurs
0 Reactions
1,356 Vu
(@mcanuto)
Posts: 183
Reputable Member
Début du sujet
 
[#7327]

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


 
Posté : 21/02/2021 6:22 pm
(@babynus)
Posts: 14952
Membre Admin
 

Can you show screenshot before you save ?


 
Posté : 23/02/2021 11:28 am
(@mcanuto)
Posts: 183
Reputable Member
Début du sujet
 

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


 
Posté : 28/02/2021 6:49 pm
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 01/03/2021 4:28 pm
Share:
Retour en haut