Forum Discussion
Due date and Notification
how can I automatically generate a report from Business Central Purchase invoices that will be due in 7 days and automatically notify someone about the upcoming due date?
Bring the data to Power BI and then use Power Automate to query the dataset (to retrieve the invoices being due in 7 days) and the build the other steps like sending an email.
Hello, sorry I am new to powerBI, how can I get the combined actual due date, currently they are separated by date hierarchy.