web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Error invalid column name when add new field in the table LedgerJournalTable

(0) ShareShare
ReportReport
Posted on by 3,805

Hi Guys,

I get some errors when trying to show form General Ledger.
The errors appear like this (Look Picture 1)

23_2D00_07_2D00_2016-22_2D00_57_2D00_55.png

Picture 1

Based from Picture 1 the field PIL_Pemohon is the new field the I add to the table LedgerJournalTable. I need it to be appear like in this form (Look Picture 2)

23_2D00_07_2D00_2016-23_2D00_10_2D00_33.png

Picture 2

In the Picture 2 is a screen cap from the demo environment, but when I apply it to the new environment there are some errors like in the Picture 1.

Im trying to reapply it in the new environment and start make the new field from the beginning, but the new info log come out showing errors like in the Picture 3. 

23_2D00_07_2D00_2016-22_2D00_53_2D00_04.png

Picture 3

I add new field in other table and there are no errors come out, even the form not showing error when I open it. I dont know why this error come out. Im google it but still not found a way how to handle it.
Maybe some of you know something ?
It will mean a lot to me

Thanks.


Sincerely,

~Enggar~

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Fredrik Sætre Profile Picture
    12,644 on at

    Try doing the synchronization dance... Try it again between each step.

    1) Synchronize

    2) Restart AOS

    3) Incremental CIL + sync

    4) Full CIL (make sure no errors) + sync

  • Verified answer
    fajar Profile Picture
    3,805 on at

    Hi Fredrik

    I've just solving the problem. I re synchronize indeed, and do the full CIL.

    I also alter the JournalNum back to normal string size (10)

    And finally there are no error showing up

    Thanks to remind me about the Full CIL

    Sincerely,

    ~Enggar~

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans