Purpose: The purpose of this blog post is to share handy queries for addresses and contact information with the community Get site from contact information recordGet site from address recordGet warehouse from contact information recordGet warehouse from address recordGet customer from contact information recordGet customer from address recordGet vendor from contact information recordGet vendor from... Continue Reading →
Validate email addresses using regular expression
Purpose: The purpose of this post is to demonstrate how can we validate the data entry of email addresses. Product: Dynamics 365 for Finance and Operations Description: The code below uses regular expressions to validate the data entry of email addresses by hooking up a ValidatedField event handler to LogisticsElectronicAddress table. Code: /// <summary> ///... Continue Reading →
Extensions examples
Purpose: The purpose of this post is to share examples of extensions. Product: Dynamics 365 for Finance and Operations Code: Form data source event handler. Event type: ValidatedWrite /// <summary> /// OnValidatedWrite handler /// </summary> /// <param name="sender"></param> /// <param name="e"></param> [FormDataSourceEventHandler(formDataSourceStr(DirPartyQuickCreateForm, DirPartyTable), FormDataSourceEventType::ValidatedWrite)] public static void DirPartyTable_OnValidatedWrite(FormDataSource sender, FormDataSourceEventArgs e) { #define.CallerFormName("CustTable") FormRun formRun... Continue Reading →
Chain of command example
Purpose: The purpose of this post is to demonstrate how we can we extend a standard code by using the chain-of-command framework. Product: Dynamics 365 for Finance and Operations Description: The code below extends the saveAttributeValueSet method of DimensionEntryControl class using the chain-of-command framework. Code: [ExtensionOf(classStr(DimensionEntryControl))] final class DimensionEntryControlSXS_Extension { public DimensionDefault saveAttributeValueSet() { #define.CallerFormName("CustTable")... Continue Reading →
Validate individual financial dimensions
Purpose: The purpose of this post is to demonstrate how we can validate individual financial dimension values before writing a customer record. Product: Dynamics 365 for Finance and Operations Description: The code below validates some customer fields like Site, Warehouse, Price group and then checks the values for individual financial dimensions in this case which... Continue Reading →
Filter voucher transactions by cost center
Purpose: The purpose of this blog post is to demonstrate how can we filter voucher transactions by cost center financial dimension for each user and the technical challenges behind it. Product: Dynamics 365 Finance and Operations Problem: Business requirement is that users should only view voucher transactions for their cost centers. Although we can define... Continue Reading →
Generate financial report in X++
Purpose The purpose of this blog post is to demonstrate how can we generate a financial report in X++ and download it as a file. Product Dynamics 365 Finance. Description Please find the code snippet below which can be used to generate a financial report in X++. The code generates the report in XML format.... Continue Reading →
How to connect to SQL database in UAT
Product Dynamics 365 Finance Description Once you get the SQL server name from UAT environment details page on LCS, it would look like this: <SQL server name>\<Database name> Copy SQL server name and append .database.windows.net at the end so that it becomes: <SQL server name>.database.windows.net Use this string to connect to the database in SQL... Continue Reading →
How to restart IIS express on Dev
You can quickly restart IIS express on a development environment of D365 Finance from within Visual Studio. This comes handy when you're doing development instead of restarting the service from LCS. You may already know but just to document, this is how you can restart a service from LCS.
Extensible data security policy for financial reports
Purpose: The purpose of this blog post is to demonstrate how we can achieve data filtration through Extensible Data Security (XDS) policies which cannot be achieved using Role-Based Security (RBS). Product: Dynamics 365 for Finance and Operations Disclaimer: This blog post uses Microsoft’s demo company data to demonstrate the concepts and processes and hence therefore... Continue Reading →
D365 for Finance and Operations 