Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 304 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Expand Lot No. field
mbmartinwa
Member Posts: 18
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
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
Michael Martin
0
Comments
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
That sounds like a perfect solution. Thanks for the Tip!
Michael