Error while posting General journal

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi All,

I am getting this error when posting General journal lines i am having 1000+ lines in journal

I have validated the lines the Journal is OK .

i am getting this below error after 1 hour

Cannot select a record in Journal lines (LedgerJournalTrans).
Journal number:,.
The SQL database has issued an error.

Kindy suggest…

Regards,

Muralimohan

2

How this journal is created? Are there any customization’s in this area?
Do you always see this error while posting journal with 1000+ lines?

3

Always tag your AX version.

4

Hi Kranthi,

Thanks for your reply

we are using AX 2009 version. The journal is created through excel upload
if i try post 10 lines or 50 lines it will get post without any error.
i tried syncing the related tables but no luck

Regards,
Muralimohan

5

Hi All,

Can anyone help me with this!!!

Regards,
Muralimohan

6

Is that the excel upload a custom one?
You need to identify which line of journal is causing this error? Does the errors shows you any of the line details?
Have you tried using 'Post and transfer ’ option (try this in TEST)?

7

Hi Kranthi,

Thanks for your reply

Through template we are inserting lines and its a customized one.

error line details are not showing

Since we are posting salary JV we cannot use post and transfer option we need to post all lines at one shot.

Please find the attached .

2742.Capture.JPG
2742.Capture.JPG1117×507 92.2 KB

Regards,

Muralimohan

8

There were limitations in Excel and AX in this version but it is now 7 years ago so difficult to remember. I am sure there was a hotfix produced for this exact issue, journals with many lines simply failed to process, I would start there with the searches or ask MS.

9

Hi AdamRoue,

Thanks for the reply,

Kindly update me if you get any information regarding this.

Regards,
Muralimohan

10

If you constantly reproduce this issue with 1000+ lines (try with different journals) then it could be a bug, else there could be an issue with the journal data it self. You need to use the post and transfer option in a test environment and see if that helps you to find out the journal line that is causing the error.

11

If the records u importing are already exist in Form, it might show this error.
Its an suggestion as I tried to import I got this error when I tried to copy data from existing to new company, I have excel file and I tried to import it on AX through job and wat i did is I deleted all those records in the new table and run that job…
It got inserted into the table…

12

Hi All,

In test server it got posted without any warning or error.
when we checked the test server there is an hot fix installed in Test server and not moved to production environment.

Thank you all for your suggestions

Regards,
Muralimohan