How to change Datatype length for master tables

rsridhar75
Member Posts: 12
Hi,
Can I change the field length for master tables. For example, I need to change the Description field length from 30 to 100 in Item table. Can I do this?
Thanks in advance.
Can I change the field length for master tables. For example, I need to change the Description field length from 30 to 100 in Item table. Can I do this?
Thanks in advance.
Regards,
Sridhar R
Sridhar R
0
Comments
-
yes ,why not.
but you have to increase the description field in all tables
where item description is used.
as
sales line
purchase line
etc.Nrapendra Singh
(Sr. Tech. Consultant)
Dataman Computer Systems (P) Ltd.
web :www.datamannet.com
mail :nrapendra@datamannet.com0 -
Hi Sridhar,
As Nrapendra says, it is technically possible but will have a hugh job on you hands. It's not only table that need to change but also reports, forms, codeunits etc in case there is a variable assigned and you will get a text overflow.
What I would recommend is to add a new field and put that on the forms reports that you need. You can then copystr back to the origional field for standard reports, etc0 -
Hi, All,
I have the same issue and need help.
Is there a utility to find all the tables, forms, reports that use field Item.Description?
Thanks0 -
The Developer Toolkit is used for that purpose, but I don't know if your license would let you use it.0
-
Thanks, Daniel0
-
or read this, if you doesn't have the DevTool. It's the same principle
http://www.mibuso.com/forum/viewtopic.php?t=26956
RegardsDo you make it right, it works too!0 -
There is code that copies the description to the search description field. If you do not also change the length of the search description field, you will get an error when entering long item descriptions (over 30 characters).0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions