Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Automate the Approval request for Imported purchase invoice

(0) ShareShare
ReportReport
Posted on by 295

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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Automate the Approval request for Imported purchase invoice

    I agree with Greg. But please note that customization is unavoidable.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Automate the Approval request for Imported purchase invoice

    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.

  • Greg Enns Profile Picture
    Greg Enns 1,102 on at
    RE: Automate the Approval request for Imported purchase invoice

    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. :)

  • Suggested answer
    Greg Enns Profile Picture
    Greg Enns 1,102 on at
    RE: Automate the Approval request for Imported purchase invoice

    I like Zhu's solution. You'll just want to modify it slightly to fit your needs.

    1. Create the field as Zhu suggested.
    2. Modify the Import process to mark the field as true during creation/modification of the PurchInvoice.
    3. Create a copy of the current approval workflow.
      1. Triggered by the modification (or "insert"?) of a Purchase Invoice
      2. Filtered to only run when Zhu's suggested custom field is marked as true.
    4. Add a step in the workflow to Uncheck the custom field (So that if a user has to make edits later--the workflow will not get triggered automatically.)
  • Tymay Profile Picture
    Tymay 295 on at
    RE: Automate the Approval request for Imported purchase invoice

    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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Automate the Approval request for Imported purchase invoice

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans