Skip to main content

D365 F&O TechExpert

Search This Blog

D365FO – Auto refresh form grid data after pressing menu item

on July 19, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

Want to refresh a Form grid data after pressing a menu item?

Just set the Form Menu item Auto refresh data Property to “Yes” like shown below

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

How to create a filter on display method using view – D365 F&O

Form fields that are based on display methods are not filterable, but in some cases, the client wants those fields filterable. There are two ways to make display fields filterable we will explain on this blog only the best way to do it (use best practice). I n our case Invoice Date field field into project expense journal form, invoice date is comes from projinvoicejour which is not part of our form. for this created view with ProjCostTrans and created method like below to get invoice date. public class ProjCostTrans extends common { private static str expensetransInvoicedate() { str expressionExp = strFmt( @"SELECT TOP 1 PROJINVOICEJOURlocexp.INVOICEDATE FROM %1 AS ProjProposalCostLoc JOIN %2 AS PROJINVOICEJOURlocexp ON PROJINVOICEJOURlocexp.ProposalId = ProjProposalCostLoc.ProposalId WHERE ProjProposalCostLoc.TransId = %3", (new SysDictTable(tableN...

How to Connect Power BI to D365 Finance and Operations

Written by Tim Woods in Common Dynamics 365 Finance and Operations comes out of the box with over 600 standard reports and inquiries (you can find the full catalog of reports and inquiries in this post ). These reports and inquiries may meet the majority of reporting requirements but if you want to take your data and analytics to the next level you will need Power BI. Power BI can open up a whole new world of analytics and insights. If you have never used Power BI or have never connected Power BI to Dynamics 365 Finance and Operations, it can be a bit tricky to get connected and start building reports. In this post I will take you through step by step how to connect Power BI to Dynamics 365 Finance and Operations, build your first report, and publish it to your Power BI workspace. Download Power BI Desktop The first thing we will need is the Power BI Desktop application. You can download this for free at the Microsoft App Store. Click your windows button and search fo...

Electronic Reporting Explained in D365 FO

In this post we’ll be looking at a classical data export scenario and showing how it can be implemented using the Electronic Reporting (ER) feature in Dynamics 365 for Finance and Supply Chain Management (D365F&SCM). Introduction Minimal Configuration of ER Parameters Defining the Data Model Mapping from Database to Data Model Mapping from Data Model to XML Format Starting the Export Conclusion Introduction As Microsoft mentioned , the ER framework replaces 20 or so existing frameworks, so it’s expected that the complexity of its configuration is high and the learning curve is steep. Others have covered the advanced setup in depth. What we’re trying to achieve here is to add some clarity and show how a simple export is done using ER by linking the concepts specific to ER with more familiar terms used in the power-user and development worlds like data selection, serialization or transformation. The scenario we’ll be looking at is very simple : exporting some ...

Powered by Blogger