Posts

How to apply AOT query ranges in D365FO?

Image
In this article, I'm going to show you how to apply different types of ranges to AOT queries. We'll go through simple and complex ranges. Let's first create a simple query that has "CustTable" inner joined with "CustGroup" If we want the query to return values where the enum "Blocked" field value is Never, then it's either we type the value Never directly or type CustVendorBlocked::Never ** It's not recommended to filter on the enum integer value If we want the query to return values where AccountNum value is "US-001",  we can add the string value US-001 directly Now what if you want to filter on AccountNum "US-001"  OR  "US-002", you can do it in two ways: 
Post a Comment
Read more

How to do CRUD operations in D365FO using Power Automate?

Image
In this article, I will be showing you how to use Power Automate in order to do CRUD (Create, Read, Update, Delete) operations inside D365FO. Login to https://make.powerautomate.com Click on "Create", then click on "Instant cloud flow" Name the flow, choose how to trigger the flow, then click Create Click on the "+" sign, then click "Add an action" Look for "fin & ops" connector and click "See more" to see all actions for it Create Record Choose "Create record" Choose "Authentication" method and fill other field values, then click "Create new" Here, I chose Authentication method as "Service principle" Choose your connection name You need to fill the Client Id,  Client Secret and Tenant Id from the app registration If you don't have an azure app registration created, then you will need to create a new one. You can check my detailed article on how to create one  How to create App R...
Post a Comment
Read more

How to setup Business Events with Azure Service Bus Queue endpoint in D365FO?

Image
Business events allow you to notify external systems when certain operations in D365FO happens. For example, you can notify an external system when a sales order is invoiced or when a customer electronic address is inserted. In D365FO, you can manage the destination where you want your business event to be sent to by configuring endpoints. Business events support multiple types of endpoints and in this article we are going to cover the "Azure Service Bus Queue" endpoint where I'm going to show you how to create an azure service bus from scratch and setup it up in D365FO. In general, "Azure Service Bus" enables applications and systems to communicate with each other and exchange information. And Azure service bus queue is a type that provides a  1-1 communication between the sender and the receiver. First, let's configure D365FO Business event with Azure service bus queue endpoint: Go to System Administration - Setup - Business events - Business events Catalo...
Post a Comment
Read more