<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

Have you been trying to get a massive data file into D365 and found out that 150,000 records were imported successfully but about 600 errored out?

Then you start thinking, “ugh, I'll have to go over each one of those records and figure out why D365 rejected them. Why isn’t there a way to generate a file with all the errors and the records we tried to import?!” 

Well, guess what? There is a way to do it. Get your Chrome browser ready, a “vlookup” and… voila!

Let’s do it!

First, download this cool Chrome extension called Table Browser Caller for D365FO (I know, I'm using Chrome, but unfortunately this is not available for Edge or Internet Explorer).

Once installed, configure the Table Browser Caller to point to as many environments as you wish. Once you’ve selected your environment and the right company, click on Table list. (If you know the name of the table you are looking for, just past it in the search bar and hit enter.)

y1 y2
The table that holds the staging errors for all the Data Management jobs is called "DMFStagingValidationLog".

This table might not be exposed on the table list, so just go ahead and type the name on the Table Browser Caller search bar and hit enter.

y3

We'll focus on the four table fields below:

  • ErrorMessage: Contains the import error for each record.
  • Execution ID: A Data Management Import job generates a Job ID each time it is used. This ID can be found under the Job History form (navigate to the Data Management workspace, open the Data Project and click Job History).
  • Staging Table Name: This is the second table we'll need to extract in order to match the error message with the staged record. The "StagingTableName" will change based on the entity used for the import.
  • Staging RecID: Identifies the staged record. Will be used to “vlookup" primary key to match an error message with its staged record.

Use the column "ExecutionID" to filter the Job ID you're looking for.

y4

y5

y6

y7

In our example, the "StagingTableName" is "VendInvoiceJournalLineStaging," as we are trying to import AP Invoices via an AP Invoice journal.

Using the Table Browser Caller, open the staging table and use the "ExecutionID" table field to filter on a specific executed job. Then use the "RecID" table field to match the record with its error message.

y8

y9

y10

So there you have it, with the help of the D365 Table Browser, you can export all the staging data error messages and their associated records. Happy exporting!

Next read: Is it that easy to enter an order in Business Central from Outlook?  Yep.

Topics

Discuss this post

Recommended posts

A recent industry report describes artificial intelligence (AI) as ‘a self-running engine for growth in healthcare with immense power to unleash improvements in cost, quality and access. Growth in the AI health market is expected to reach $6.6 billion by 2021— a compound annual growth rate of 40%. In just the next five years, the AI health market will grow more than 10X2.’
Did you know that the Microsoft Power BI solution was originally designed for non-technical users? The intent was to give business professionals across the board access to critical data; a privilege once reserved for only IT and data personnel.
While most organizations understand the importance of data, far fewer have figured out how to successfully become a data-driven company. It’s enticing to focus on the “bells and whistles” of machine learning and artificial intelligence algorithms that can take raw data and create actionable insights. However, before you can take advantage of advanced analytics tools, there are other stops along the way, from operational reporting to intelligent learning. Digital transformation is dependent on adoption. But adoption and proficiency of new technologies can be disruptive to an organization. Mapping a data journey provides awareness and understanding of where your organization is to ultimately get where you want to go, with enablement and adoption of the technology throughout. Without the clarity provided by a data journey, your organization won’t be positioned to successfully deploy the latest technology.
Pricewaterhouse Coopers forecasts that Artificial Intelligence (AI) could contribute up to $15.7 trillion to the global economy by 2030, of which $6.6 trillion is likely to come from increased productivity and $9.1 trillion from consumption-side effects.
Since its 2014 launch, Microsoft Power BI has – arguably – been the preferred cloud-based SaaS data analytics and business intelligence (BI) solution for businesses worldwide because of its ability to:
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down