Microsoft Dynamics AX 2012 Data Import Export Framework Integrations Using DMFLedgerBalanceEntity

by | Updated August 15, 2016 | Dynamics AX, Financials

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 = [dbo].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

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Managing Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Management: Introduction of NEW Functionality for Manufacturers Using Dynamics 365

november

11nov10:00 am10:30 amThe Modern Manufacturer - Tears and Trauma of MRP

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X