A blog about Dynamics 365

  • Run interface implementations parameterized in a lookup

    Run interface implementations parameterized in a lookup

    In this blog post, I’m going to show you a pattern that allows users to parameterize an Interface and run it based on that parameterization. This isn’t a tutorial or guide per se, but rather an experimental solution I developed while trying to implement a similar pattern to the one already used by Microsoft in…

  • Import a CSV file with Electronic Reporting (III) [Legacy]

    Import a CSV file with Electronic Reporting (III) [Legacy]

    These steps are not necessary, as a better method for importing a CSV with escape characters is explained at the end of part 2. Nonetheless, I’m leaving it here because it might be helpful for importing other file types, such as EDI files. In the first two entries of this series, we saw the standard…

  • Import a CSV file with Electronic Reporting (II)

    Import a CSV file with Electronic Reporting (II)

    This article is the second in a series of three about importing CSV files into the system. We will explore the format, the format mapping, escaping characters and how to test the development. Once we have the model and the mapping with the status completed, we can continue by creating an import format under our…

  • Import a CSV file with Electronic Reporting (I)

    Import a CSV file with Electronic Reporting (I)

    In this series, I’m going to show an example of importing a CSV file using Electronic Reporting (ER). This guide assumes you have basic knowledge of ER. If you are just starting, I recommend reading the series on ER export first, as it is more step-by-step and explains the basic concepts of ER. In an…

  • Integrating Electronic Reporting import messages into the UI

    Integrating Electronic Reporting import messages into the UI

    Following my previous article, ‘Integrating ER Export Formats into the UI’, let’s now take a look at import messages. I’m starting with a very simple model, an import format and an import mapping (direction to destination). In the mapping, there are two user input parameters, ‘string1’ and ‘string2’. These parameters serve as the keys for…

  • Integrating Electronic Reporting export formats into the UI

    Integrating Electronic Reporting export formats into the UI

    We’re going to see how to integrate an ER export format into a form. This involves adding a button that, when clicked, will execute a parameterized ER format and pass arguments from the currently selected record. We have this table, where the first two strings act as a unique key: Additionally, we have a Model,…

  • Electronic Reporting Object Base Reference Error

    Electronic Reporting Object Base Reference Error

    When uploading versions to ER, you may sometimes encounter the error messages ‘Unresolved references left’ and ‘Reference of the object X to the object ‘Base’ Y cannot be established’. Let’s discuss why this happens, how to prevent it, and how to fix it. Cause Let’s suppose we have a Model, a Mapping, and a Format.…

  • Export Message Creation in D365F&O Electronic Reporting: Part IV – The Format

    Export Message Creation in D365F&O Electronic Reporting: Part IV – The Format

    In this final part of the series, we’ll explore how to create a text file using some of the data we’ve gathered in our mapping. The file will be organized into sections, with information sorted both by a suffix on each line and the data’s position within the line. This format is commonly used in…

  • Export Message Creation in D365F&O Electronic Reporting: Part III – The Mapping

    Export Message Creation in D365F&O Electronic Reporting: Part III – The Mapping

    In this final part of the mapping, we’re going to link our declared and transformed objects with the model and then check if the data we are getting is what we were expecting. There are two ways to link nodes: either directly with the ‘Bind’ button or using the formula UI ‘edit’. Let’s start with…

  • Export Message Creation in D365F&O Electronic Reporting: Part II – The Mapping

    Export Message Creation in D365F&O Electronic Reporting: Part II – The Mapping

    In this second part, we’re going to see how to create the mapping. This is the most technical part, and while we’re going to keep it simple, it sometimes requires knowledge of the system architecture and access to Visual Studio, or the help of someone with a technical profile.

  • Export Message Creation in D365F&O Electronic Reporting: Part I – The Model

    Export Message Creation in D365F&O Electronic Reporting: Part I – The Model

    In this series, we’re going to learn how to create a simple export message with Electronic Reporting (ER) from scratch, without extending any generic message from Microsoft. The goal is to generate a txt file containing filtered data from customer invoices. There are three kinds of nodes or steps involved in creating an export message:…

  • About safety of Electronic Reports (ER) from unknown origins in D365FO

    About safety of Electronic Reports (ER) from unknown origins in D365FO

    ER is a powerful tool with access to most AOT objects, making it theoretically unsafe if the origin of the ER is unknown. Data transformation, along with data insertion or retrieval from the database, occurs in the mapping, potentially making it the most dangerous node. Additionally, because a mapping can be directly created within the…

  • Set up lookup parameters in Electronic Reporting

    Set up lookup parameters in Electronic Reporting

    In this blog post, I’ll show you how to change lookup data in Dynamics 365 for Finance and Operations into internal enumerations set up by users, accessible through the standard UI for each legal entity. Specifically we’ll look at how to change tax codes from the TaxTable into external codes, like ‘VAT’, ‘Green taxes’, and…