Skip to main content

Notifications

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) / Extend job description...
Microsoft Dynamics NAV (Archived)

Extend job description field to 250 characters

(0) ShareShare
ReportReport
Posted on by LSO 360


Hello,

I'm try to expand the length of the Job description. I have see in the MSDN who is possible to do that:

msdn.microsoft.com/.../dd355113(v=nav.90).aspx
So I have extended the length of the field Description in the table Job (167) whithout any error

But now when I try to insert a description more tha 50 character the system permit me to write it but when I save I receive the error:

"The length of the string is 104, but must be less or equal to 50 characters. Value <Inserted string> (Select refresh to discard errors)"

If I make refresh the system clear the field

I use NAV 2017 Update 4

Thanks

Lorenzo Soncini

*This post is locked for comments

  • Verified answer
    Luc van Vugt Profile Picture
    Luc van Vugt on at
    RE: Extend job description field to 250 characters

    Hi Lorenzo, let's get straight to my general advice: don't!

    Changing the length of a field seems straightforward, but you might actually go into a swamp you do not want to be in ... if you did think this would be easy (and maybe have promised your customer it would be simple).

    Did you google on "NAV changing description field length" and see the responses?

    I think AJ and Alexander were somewhat too nice to you in giving some tips. The things is that the Job Description field is not only referenced directly in the code, but also indirectly, being f.e. a local variable that gets data copied form the Job Description field. Of course this field is referenced less than for example the Item Description field, but you need to check every reference. More or less as you are experiencing with the error message:

    The length of the string is 104, but must be less or equal to 50 characters. Value <Inserted string> (Select refresh to discard errors).

    If this is really what you want to achieve, you will need to do it, but please think twice (by reading the posts you will hit upon when oogle on "NAV changing description field length").

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Extend job description field to 250 characters

    As usual, ERP systems contain numerous tables that are linked with each other, and some tables have same fields that are copied from one table to another during the posting or document creation process. So, changing the length in one place most likely would result in the error that you had received, as there are other fields or variables of the old size, and you need to expand them as well throughout the whole database. Additional attention you need to pay to reports, as the layout might be designed for shorter length and longer length might result in impropriate appearance of the data in layout.

  • Verified answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Extend job description field to 250 characters

    Hi Lorenzo,

    When you tab out of the Description field, there is code in the OnValidate trigger that takes the value you've entered, and populates it in the 'Search Description' field of the Job table. And I don't think you've updated that field to hold 250 characters. Don't change its data type, just update the length to 250.

    This will address your immediate issue. That said, there may be other places where the Job Description may get transferred to as you post transactions, etc. Be prepared to see errors there. You may need to debug the session to figure out where the error is coming from and how to resolve it.

    I hope this helps. If my response has answered your question, please verify my answer by clicking Yes next to "Did this answer your question?"

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans