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 :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Why are new table fiel...
Microsoft Dynamics NAV (Archived)

Why are new table fields not recognised?

(0) ShareShare
ReportReport
Posted on by Community Member

I have created two new tables in our Dynamics NAV 2013 installation: 50086 Order By Period and 50089 Item Sales By Period. Each contains Date, Decimal, Integer and Text fields, as well as the Code fields used in the key. I left all field properties as their defaults. When referring to the tables in my codeunit some, but not all, of the fields cause compile errors because they are not recognised. In the code unit I have the tables referenced as local variables of type Record.

Recompiling the objects (tables and codeunit) has not fixed the problem.  In order to force the compiler to use the latest version of the tables, with all the fields, I have removed all references to the tables from the codeunit, recompiled the tables, then added the references back and recompiled the codeunit. This hasn't corrected it, the same fields are still causing compile errors.

All the table fields are present in the SQL Server tables.

What should I do to make all the new table fields visible to the compiler?

*This post is locked for comments

I have the same question (0)
  • jcastro Profile Picture
    jcastro 2,245 on at

    Hello VaIM,

    What specific error are you getting? Could you maybe attach a screenshot of it?

    Do you use the C/AL Menu to add the fields or do you type them manually?

    What NAV version are we talking about?

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    You need to run Sync Command or open the RTC client. Please check below blog

    www.archerpoint.com/.../microsoft-dynamics-nav-2013-r2-error-unable-verify-table-changes

  • Community Member Profile Picture
    Community Member on at

    Jose,

    The error I'm getting is "You have specified an unknown variable." This is in Dynamics NAV 2013. I can't see how to attach a screenshot but the error was as you'd expect for an undeclared variable.

    I had typed the field names manually, but because a typo would have been an obvious cause of the error I also tried copying and pasting the names from the table definition when the typed field names weren't recognised. I have also retried typing the fields manually in case the copying and pasting introduced an error. In revisiting the code in order to get a screenshot I used the C/AL Menu to add the fields and now the code does compile. To the naked eye the field entered in any of the three ways (manually, copying and pasting, from C/AL) appear identical but there must be something introduced in the first two methods that is corrupting the names.

    Thanks for your help.

  • Community Member Profile Picture
    Community Member on at

    Suresh,

    I had read other blogs about the issue but don't think this is the problem. We are on Dynamics NAV 2013, not Dynamics NAV 2013 R2, and the fields are in the tables in the SQL Server database.

    Thanks for your help.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    Have you tried restarting the services ?

  • Community Member Profile Picture
    Community Member on at

    Suresh,

    Yes, I had tried that, as part of something else I was doing, but it didn't make a difference, those field names were still not recognised.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    Can you see the field names when you lookup from record variable ? i.e. when you are in code window press F5 select the record variable ? can you see fields over there ?

    One other thing to insert screenshot choose rich formatting and it has option to insert picture/media.

  • jcastro Profile Picture
    jcastro 2,245 on at

    Hello,

    Could you please tell us what specific localization and build you are using?

    Also, could you please tell us the names of some of the fields that you can't work with?

  • Community Member Profile Picture
    Community Member on at

    Suresh,

    Yes, using the C/AL symbol lookup did work. Even though the field names were exactly the same as those I'd typed/copied-and-pasted they weren't recognised by the compiler until inserted via the lookup. I still don't know why this is but my code is at least compiling now.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    It happened few times to me when i try to copy the code from other database or notepad. I think sometimes it will paste some hidden characters and even after typing it doesn't go away until i delete everything and come back to the object and type it again or use Lookup.

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!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans