Data import export - Open balance - target missing lines

(0) Share

Report

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

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 302,604 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Pierre-Olivier Lacasse 112 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sangram Shinde 2,114 on at

Like (0)

Report
Copy link

Link copied!

Hi Pierre,

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

Was this reply helpful? Yes No