How to change Datatype length for master tables

rsridhar75

Hi,

Can I change the field length for master tables. For example, I need to change the Description field length from 30 to 100 in Item table. Can I do this?

Thanks in advance.

nrapendra

yes ,why not.

but you have to increase the description field in all tables
where item description is used.

as

sales line
purchase line
etc.

DaveT

Hi Sridhar,

As Nrapendra says, it is technically possible but will have a hugh job on you hands. It's not only table that need to change but also reports, forms, codeunits etc in case there is a variable assigned and you will get a text overflow.

What I would recommend is to add a new field and put that on the forms reports that you need. You can then copystr back to the origional field for standard reports, etc

couberpu

Hi, All,

I have the same issue and need help.

Is there a utility to find all the tables, forms, reports that use field Item.Description?

Thanks

DenSter

The Developer Toolkit is used for that purpose, but I don't know if your license would let you use it.

couberpu

Thanks, Daniel

garak

or read this, if you doesn't have the DevTool. It's the same principle

http://www.mibuso.com/forum/viewtopic.php?t=26956

Regards

Karenh

There is code that copies the description to the search description field. If you do not also change the length of the search description field, you will get an error when entering long item descriptions (over 30 characters).