Expand Lot No. field

mbmartinwa

Hi Everyone,

We have a client who is wanting to expand the Lot Number field from 20 to 40 characters in NAV. We have never done this before, and I am wondering how big of an undertaking it is. Expanding it in the tables will certainly not be a problem, but I'm more concerned about places in C/AL that it needs to be hit (Variables, etc). If anybody has experience with this, I'd love to hear.

Thanks!

Michael Martin
Gilbert & Associates

jglathe

Hi Michael,

we' ve done this... sort of. But we chose not to extend the lot no field ( too much changes on places we didn't want), instead we used the "serial/lot no. Information" table and added a long field there. In the item tracking code we made the information required, and added a mandatory no. series for the actual serial no (in our case). In the item tracking window we' ve added flow fields for the long serial no. for faster access. This works pretty well and without unwanted side effects.

with best regards

Jens

mbmartinwa

Jens,

That sounds like a perfect solution. Thanks for the Tip!

Michael