Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Data import export - O...
Microsoft Dynamics AX (Archived)

Data import export - Open balance - target missing lines

(0) ShareShare
ReportReport
Posted on by Pierre-Olivier Lacasse 112

Hi everyone, 

when importing a general journal with historical gl balances by periods, with the open balance data entity, we are getting, for example, 12000  lines in staging but at target, we are only receiving 1000 lines and there is no error log or any exceptions provided. 

I originally thought the accounting structure could be at fault so we created an "all allowed" structure for the import but the result is unchanged. 

Has anyone ever seen such problem?

thank you.

*This post is locked for comments

  • Reliable Profile Picture
    Reliable 2,015 on at
    RE: Data import export - Open balance - target missing lines

    Hi Pierre,

    You can do a quick check for the main accounts you are providing that are created/present in AX or not.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Data import export - Open balance - target missing lines

    which file type are you using ? CSV ?

    Can you share the values for one line which ax failed to import.

    if you are using  CSV make sure the amount in the debit and credit don't have include comma

  • Pierre-Olivier Lacasse Profile Picture
    Pierre-Olivier Lacasse 112 on at
    RE: Data import export - Open balance - target missing lines

    Yes, the journal number was provided on each line, as well as a unique line number.

    When i view staging data i can see some lines failed on target while other did not. But i don't any difference on these lines that would justify errors.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,622 Super User 2024 Season 2 on at
    RE: Data import export - Open balance - target missing lines

    Hi Pierre,

    Did you provide a correct journal number and unique line numbers for all lines in the source file? Can you also see which lines are correctly imported and which aren't? Or are all lines marked as imported successfully?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans