Microsoft Dynamics AX 2012 Data Import Export Framework Integrations Using DMFLedgerBalanceEntity

By Ryan Kleven | October 15, 2013

The Data Import Export Framework offers a DMF class called DMFLedgerBalanceEntity as a basis for integrating, from an Excel source file, unposted journals into Dynamics AX 2012 R2. We’ve used this DMF class significantly over the past several weeks on integrations from a variety of different fronts. As part of testing and using this DMF class for integrations into unposted journals, we’ve regularly used the Data Import Export Framework Execution History as a basis point for reviewing any potential errors or problems found during the integration. The Data Import Export Framework Execution History typically does an effective job of pointing out where the problem resides and can be quite helpful with reviewing the results of integrations. Based on experiences encountered with using the DMFLedgerBalanceEntity class for running Data Import Export Framework integrations, I’ve accumulated a list of some errors that you can encounter in the Execution History and some detail around what the error messages mean. Understanding the reasons for what you’d see in the Execution History from running various Data Import Export Framework integrations should help you better understand the tool.

Common errors that could be found in the Data Import Export Framework Execution History when using the DMFLedgerBalanceEntity class for integrating into the context of unposted journals in Dynamics AX 2012 R2:

1.  You receive the following error message when you attempt to perform the Copy data to Target step of processing: “Main account should be in the first segment.”

a.  What it means:  This means that there is a Main account in a Main account segment in a LEDGERDIMENSION/OFFSETLEDGERDIMENSION field of the source file where one of the following is true:

–  The Main account flat-out does not exist in Dynamics AX 2012 R2; or

–  The Main account exists in Dynamics AX 2012 R2, but does not exist in the legal entity’s account structures for which you are running the integration into.

2.  You receive the following error message when you attempt to perform the Copy data to Target step of processing: “Financial dimension does not exist.”

a.  What it means:  This means that there is a Financial dimension value in a LEDGERDIMENSION/OFFSETLEDGERDIMENSION field of the source file where one of the following is true:

–  The Financial dimension value does not exist in Dynamics AX 2012 R2; or

–  The Financial dimension value does not exist in the legal entity’s account structure for which you are running the integration into.

3.  You receive the following error message when you attempt to use the Get staging data button in processing: “Unable to open file.”

a.  What it means:  This means that the Excel source file is currently open at the time that you run the integration. You cannot have the Excel source file open at the time that you run an integration.

4.  You receive the following error message when you attempt to use the Get staging data button in processing: “Cannot execute the required database operation. The SQL database has issued an error. SQL error description: {Microsoft}{SQL Server Native Client 10.0}{SQL Server} Error converting data type varchar to bigint. SQL statement: UPDATE DMFLEDGERJOURNALTABLEENTITY set VOUCHER = .FN_FMT_NUMBERSEQUENCE. Issue exists in generate staging data.”

a.  What it means:  This means that Data Import Export Framework doesn’t like the Cell Formatting of the JournalNum column in Excel.

–  Go to the Excel source file, right-click on the JournalNum column, and click Format Cells. In the Cell Formatting, change the Type to ‘Text’, and then re-save the Excel .csv file.

Related Posts

Recommended Reading:

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X