Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Item "No."
cnavarre
Member Posts: 3
Hi!
Did anyone have to change the length of the main key of item table: "No."?
Is it posible? How many tables, codeunits, reports will not work?
Is there any script or codeunit to do this change more easilly?
Did anyone have to change the length of the main key of item table: "No."?
Is it posible? How many tables, codeunits, reports will not work?
Is there any script or codeunit to do this change more easilly?
0
Comments
Why do you want to change the lenght of Item."No." ?
There is probably a easier method to do what you need... ?
But oh my foes and oh my friends, it gives a lovely light
In case you need to do it, use the Developer's Toolkit and find where that field is used, and then you can see what fields might need to be modified too, and so on... (recursively !!!! :shock:)
But as philippegirod mentioned it is not recommended. All I have ever had increased is descriptions...
Arhontis
https://forum.mibuso.com/search
Don't do it. It affects 153 object in 3.60. Even if this number would be smaller it wouldn't be a smart idea.
Anyway - what are you trying to achieve? Item No. is Code 20. Use it as a key and add another field of needed length for your purposes.
Documentation for Microsoft Navision
E/R diagrams, Workflow diagrams, UML diagrams, process diagrams