How to increase item description MaxLength

Business Central/NAV Developers Forum
1

I wanted to update Item Description MaxLength from 50 to 250 characters.

I changed Description length in the following tables.

· Item (table 27)

· Sales Line (table 37)

· Item Journal Line (table 83)

· Item Category (table 5722)

· Item Charge Assignment (table 5805)

· Sales Invoice Line (table table 113)

· Sales Line (table table 37)

· Sales Shipment Line (table table 111)

· Purchase Line (table 39)

The change is available to the Description filed on Item Card and Invoice form. The change is available on Item Card and Invoice form.

However, system raises Overflow error while posting the invoice. Please advise if my approach is correct or I’m making a mistake.

Please post me a reply on 8><----

Thank you.

2

First welcome Shahrad, second, never ask for a direct reply in a forum like this. People who help you with the answers will generally help you, because it can help many other members also. And that would not work if they just emailed you the answer. If you like to have the answer on your email, then you can subscribe to the answers to this tread instead. Then it helps you and everyone else.

But to your problem. What you have been doing here is something I have always told everyone NOT TO DO, as it is basically a VERY VERY BIG TASK! The number of tables the item description is linked to is very big and there are a lot more tables where you must do your change before it will work without your overflow error.

I would recommend you either to reconsider your change (maybe just use extended texts for items) or install the Development Toolkit for NAV and use the cross reference functionality here. Also consider that such a big change makes all your future upgrades much harder.

3

In that kind of problem I apologist of using field “description 2”