Posts

How to Open a Filtered Form Using a Menu Item related to a row in D365FO

Image
 I Will show you here how to Open a Filtered Form Using a Menu Item related to a row. for example in Released Products i added a menu item to show Related PRQs to an item like this Let's begin the development here: first of all create a View with targeted Datasoruce and drag the field you need: Next create Simple list form then add Datasource Next override the form method "init" and write the following code:     public void init()     {         InventTable selectedRecord;         QueryBuildDataSource qbds;         QueryBuildRange qbr;           super();           // Check if arguments are passed and if it's the correct type         if (this.args() && this.args().record() && this.args().record() is InventTable)         {             // Get the selected record  ...
Post a Comment
Read more

Develop embedded Powerbi Report from scratch in Dynamics365 F&O

Image
In This article, I will show you how to create comprehensive Powerbi Report for PRQ. So the result will be like: The Advantages of using embedded powerbi with DirectQuery: You do not need powerbi license. faster data refresh. Let's start: Create Query: Create Datasource  Of PurchReqTable then create a datasource of it "PurchReqBusinessJustificationCodes" make sure relation is outerjoin as the picture: then create another datasource "PurchReqLine" then create another datasource "PurchReqBusinessJustificationCodes" again the relation should be "outerjoin" then create another datasource "HcmWorker" this how your query will look like eventually: Create A view based on the query:   The first 5 fields should come from PurchReqTable but the followings should be like: Itemid -> PurchReqLine PurchQty -> PurchReqLine PurchaseOfficer ->  PurchReqBusinessJustificationCodes BusinessJustification ->  PurchReqBusinessJustificationCodes...
Post a Comment
Read more