Changing the field length

(0) Share

Report

Posted on by lynix_x

259

Hello,

recently, one of our customers wsnts to insert more characters on Itemreference number field on item reference table. Well, i know changing field lenght is not recommended, and therefore, is it possible with a workaorund solution?. Like a extra field o something.

thanks.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Marcellus 2,735 on at

Like (1)

Report

Hi Lynix_x,

Is it the Cross-Reference No. field in the Item Cross Reference (Table 5717)?

Are you using Object Manager advanced? (idyn developers webinar Friday Dec. 11 2015 - Object Manager Advanced) With that you can check where your field is used in the application code and analyse how much of an impact would it be to change the field length but you have to be careful as your field value could be passed through functions with the limited length etc.

What is the customer requirement? How is this field used currently?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (1)

Report

Is it customized field or standrd field of NAV?

If you increase the length of field then you need to carry out change everywhere where this field is used

Was this reply helpful? Yes No
lynix_x 259 on at

Like (0)

Report

This is a standard field. Therefore, i don't want to change that.

Was this reply helpful? Yes No
lynix_x 259 on at

Like (0)

Report

you are Correct Marcell, that's the field. Are there, any other workaround?, I'm thinking about creating an extra field and use it instead.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

It's recommended to create a new field.

Was this reply helpful? Yes No
Suggested answer

Marcellus 2,735 on at

Like (0)

Report

Hello,

It is probably best to approach it that way but could you share more of your business process? Are you extending it because your vendor item numbers are too long, are you using bar codes? You should consider how much of the standard functionality you need to replicate with your custom field.

Was this reply helpful? Yes No