Alert on Pending Project Transactions (ProjUnpostedTransView) not working

(2) Share

Report

Posted on by tmj1

Does anyone know why custom alerts are not working on ProjUnpostedTransView?

I read that a workaround could be to create the alert from the SysTableBrowser, but I am just not able to get FO to send me a notification (neither in the application og externally via mail og Power Platform).

Alerts work perfectly for vendtrans, custtrans and every other table i have tried...

Thanks

Categories:

Dynamics 365 Finance

All responses (3)

Answers (1)

Verified answer

André Arnaud de Cal... 291,703 Super User 2024 Season 2 on at

Like (1)

Report

Alert on Pending Project Transactions (ProjUnpostedTransView) not working

Hi Tom,

When reading your requirement, you don't need an alert on pending project transactions, but you can consider an alert on the timesheet lines table. (TSTimesheetLine)
tmj1 23 on at

Like (0)

Report

Alert on Pending Project Transactions (ProjUnpostedTransView) not working

Hi André

Thank you for the answer - I was suspecting that, but was hoping for a different answer.

Problem that I am trying to solve:

- We have certain projects that we would like to monitor if employees use them in their timesheets, and get a notification if they do. Preferably be notified as soon as the post is saved.

thanks

Tom
Suggested answer

André Arnaud de Cal... 291,703 Super User 2024 Season 2 on at

Like (0)

Report

Alert on Pending Project Transactions (ProjUnpostedTransView) not working

Hi TMJ1,

The reason is that alerts are not working on views. The ProjUnpostedTransView unions various tables. You will need to set alerts on physical tables.

Anyway, can you provide the business problem you try to solve by setting an alert? There are many different transaction tables in this view and each table can have a huge number of records and inserts. It can give you performance issues and you might get too many notifications.