Has anybody been able to automatically post G/L Journals in Business Central after they have been approved? Either through workflow or job queue (without custom coding)
Has anybody been able to automatically post G/L Journals in Business Central after they have been approved? Either through workflow or job queue (without custom coding)
Thank you for your detailed steps Rob!
You're using approvals in Power Automate, but we've setup all other approvals using the BC workflows, and users want one source for outstanding approvals.
However, you definitely gave me some ideas to start working on.
Thank you!
And thank you MahGah for submitting the idea to Microsoft, I voted !
Hi Theo, yes it's possible, we have this working currently using Power Automate. Our workflow is a bit complicated and Power Automate has been an excellent tool to handle it all, but there are some caveats to be aware of as well. I can't post a screenshot of the complete workflow as it's too big, but here are the main components:
Start with the standard out of the box trigger and action to get the workflow record. These are created automatically if you use the Power Automate template, or you can start from scratch with a blank template.
Go through the approval action. Since our workflow has a few branches depending on certain conditions, we use a variable to set the approval outcome.
Process the approval outcome. To post the journal add the Execute action step and use the Id field from the Get workflow record step above.
Now for the caveats:
Feel free to DM me if you have any other questions on this.
Rob
I submit the idea here just in case if someone wants to vote for it
Thanks for info. If you accomplish this task and if you do not mind post the full solution here just to help other members as well. Thanks
Thank you MahGah and Kim!
Those posting code units cannot be used in a BC job queue; it errors out on "Record 472 (Job Queue Entry) is not compatible with Record 81 (Gen Jnl Line)"
But I love your idea on the Power Automate. I got this flow to post the journal; now I just need to find a way to edit and control which journal batches to post.
Thank you!
This is just theory and I have no method to test it
I think if we run Codeuint 13 in Job Queue then maybe we can post the Journal. You can test this in Sandbox. The challenge is you need to run this Codeunit after approval. Now if you can find the method that work flow can trigger Power Automation after approval and Power Automation can run the Codeunit 13 then maybe you can do this.
Following chart from www.oreilly.com/.../0d7dc814-43ba-4a33-a7d6-8b3c2b2ac56e.xhtml
I tried to set this up and did a great deal of research. It is not possible in standard BC. Like MahGah stated, maybe with Power Automate.
Hi
I heard it is possible to do this through Power Automation but I could not find anyway using workflow or job queue yet
Maybe use the following flow then add extra action to them something like
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... 290,558 Super User 2024 Season 2
Martin Dráb 228,647 Most Valuable Professional
nmaenpaa 101,148