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

april

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

07apr2:00 pm2:30 pmEnsuring Quality for Batch Manufacturers

08apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Jumping into the Deep End of the Data Lake

14apr10:00 am10:30 amBoost Seller Productivity and Close More Business with Dynamics 365 Sales

21apr10:00 am10:30 amSetting Your Sales Team Up for Success: A Modern Look at Revenue Operations

21apr12:00 pm1:00 pmGetting Started with Barcode Scanners and WMS Apps for Business Central

21apr2:00 pm3:00 pmMoving to the Cloud: Today's Solution for Leading Field Service Companies

22apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Moving from Manual to Automated with Strategic Automation Strategies

28apr10:00 am10:30 amThe Modern Manufacturer: Best Practices for Inventory Turnover

28apr12:00 pm1:00 pmPower Up Microsoft Dynamics by Automating Budgeting, Dashboarding and Reporting

may

05may10:00 am10:30 amAchieve More with Zetadocs for Business Central

05may2:00 pm2:30 pmSimplifying Item Pricing, Availability, and Tracing for Batch Manufacturers

06may11:00 am12:00 pmD365 Field Service – New Features to Empower Your Remote Workforce

12may10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

12may12:00 pm12:30 pmFinancial Implications of Moving from Dynamics GP to Dynamics 365: Licensing and Infrastructure

17may(may 17)8:00 am28(may 28)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

26may10:00 am10:30 amThe Modern Manufacturer - Enterprise Asset Management

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