Purpose: The purpose of this post is to share how can we resolve Azure build pipeline errors. Application: Dynamics 365 Finance and Operations Problem: Recently I faced an issue while running build pipeline in Azure DevOps. The pipeline failed with errors like: The ExtendsOfAttribute specification is invalid. Please specify an existing element to extend. The... Continue Reading →
Add table to a default description
Extending default descriptions
Handy queries for addresses and contact information
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 →