Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.4K 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
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 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
Increasing Description field in Chart of accounts
iqbalmad
Member Posts: 179
As per the requirement of our client we have increased the number of characters for the Description field in the Chart Of Account table. The number of characters was 30 we have increased to 50.
We have exported the budget on excel as the different departments will work the budget on excel and import it back on the system.
Problem
A problem is occurring when I import back the budget. am getting an error:
A value in the filter "RESERVE....." in the code caption field in the Dimention table is too long for the field type
Type:Text30
Can anyone help on this issue? If I bring this description of the G/L code to 30, the problem will occur where there is a description greater than 30.
We have exported the budget on excel as the different departments will work the budget on excel and import it back on the system.
Problem
A problem is occurring when I import back the budget. am getting an error:
A value in the filter "RESERVE....." in the code caption field in the Dimention table is too long for the field type
Type:Text30
Can anyone help on this issue? If I bring this description of the G/L code to 30, the problem will occur where there is a description greater than 30.
0
Comments
You should never change the lengths or types of standard fields [-X You will have to change the import routine to only copy the first 30 characters using the COPYSTR function or change all ocurrances of the description field. Hope this helps
Albert
You can create a new field where you can import the entire contents. There are many posts about this on this forum ...
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog