Hi Community,
We integrate purchase invoices from EXCEL either via Edit in Excel or Configuration Package. We would like to automate the Request for Approval for all the imported Purchase Invoices so that users are not required to edit every one of the Purchase Invoice to click on the Request for Approval.
What is the best method we can achieve this requirement?
Appreciate all recomendations.
Thanks,
May
I agree with Greg. But please note that customization is unavoidable.
I would consider creating a customized import and have that import function trigger an Power Automate approval flow.
At least if this is something you will do on a regular basis.
Whats coming in this release wave is the possibility to trigger a business event that can launch a power automate flow.
Quick note...If you are able to run the custom workflow OnInsert of the imported PurchInvoice, then you would not need to do step 4 since Insert only happens once. :)
I like Zhu's solution. You'll just want to modify it slightly to fit your needs.
Hi Zhu, thanks for your reply. We actually do not need them to be auto approved. What we need is upon import, the system auto request for approval and send a notification to the approval; set the status to Pending Approval. Currently users have to go into each of the document to click Request for Approval upon import which is quite inefficient.
Thanks
May
Hi, first of all, standard functions cannot be done.
And starting from BC20.3, we can release and reopen multiple purchase documents. (Maybe you have Workflow and the system doesn't allow you to do this.)
Generally available: Release and reopen multiple purchase documents in Business Central
https://yzhums.com/27393/
If you consider customization, you can add a field, such as Integrate purchase invoices (Boolean), add this field in Edit In Excel and Configuration Package, and it cannot be edited on the page. Then add an action to approve all Integrate purchase invoices. Just an idea, maybe there are better proposals.
Hope this helps.
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156