Increase field width for Item Description

ebrahma · 2004-05-07

Customer requirement is to increase field width for Item Description in the item card. Please let us know how this change would affect other Functional areas such as Bill of Materials, Sales Order, Purchase Order, Item Journal, etc., We would also like to know the no of places
that need to be changed in order to accomodate the Item Description after increasing the field width of the same.

FPulsfort · 2004-05-07

My Tip: Don't do this. Add a new field (e.g. "Description 3") to the Table Item. This will not make so much problem as a bigger width of the original fields. you have to insert this fields in all tables where the customer wnats to see this field. But it is an extra Programming and no error will ocurr, when you forget some table.
If you change the size you have to change the size in every table and in every lokal variable. you have to find all this places. Best way to do this is the "Developers Toolkit". But if you forget or oversee some place an error will occur.

Have you tried to search this forum your question? I think there will be more advices.

Hope this helps.

Regards,
Frank

Wiechardt · 2004-05-07

Changing the size of your Item Description field can cause many unforseen problems, but if you are an experienced Navision developer, I would rather choose this option than adding a new Description field to the table. Adding a new description field is not as ideal as having a Description field of sufficient size.

You can use the Navision Developers toolkit as a starting point, but do not think that once you have changed all the objects listed by the "Where Used" report your work is done - some objects are not listed by the Navision Developers toolkit due to the way that the field is used (Indirectly through a function)

Export all your Navision objects as text. Import them into the Navision Developers Toolkit. From the Object Administrator, browse to Table 27, go to the Description field and do a "Where Used With" search.

Modify all the objects where this field is being used.

The remaining objects that need to be modified you will find doing a dry run of the functionality your customers is going to be using.

Create an Item with a Descriptiojn of the max size your new description field allows. Run through all possible functional areas doing data entry and posting. You will soon pickup where changes need to be made.

ebrahma · 2004-05-07

Thank you for your valuable input.

Savatage · 2004-05-07

http://www.mbsonline.org/forum/topic.as ... escription

Increase field width for Item Description

Comments

Categories