Van Vugt: NAV2013 Glance 13: More Fields That Have Been Stretched

[Blog bot]

The other day my fellow MVP Vjekoslav Babic informed us that the length of G/L Account Name in NAV 2013 has been changed from from 30 characters to 50 characters to which he added:

In NAV 2013, this change is not only about G/L Account – the length of all Name and Description fields in all master tables has been consistently set to 50.

... and let me add that this also applies to all fields that, directly or indirectly, refer to/make use of these fields.

Detailed analysis of all Text and Code fields showed me that, regarding the stretching of fields, this is only one part of the story as there are many more fields that did undergo this exercise. Have a look at these statistics:

Type of Field

Lenght Change

# of Changes

Description

30 -> 50

135

User ID

20 -> 50

123

External Document

20 -> 35

42

Report Name

80 -> 250

23

Name

30 -> 50

22

Customer Disc. Group

10 -> 20

20

Vendor … No.

20 -> 50

16

Table Name

80 -> 250

15

Form/Page Name

80 -> 250

13

Your Reference

30 -> 35

13

Applies-to ID

20 -> 50

10

Text Code

10 -> 20

4

Dimension Totaling

80 -> 250

4

Price Inv. Increase Code

10 -> 20

3

Tariff No.

10 -> 20

2

Code Caption

30 -> 50

2

Cust./Item Disc. Gr.

10 -> 20

1

Substitute

20 -> 50

1

One way or another these fields have been stretched. Being fields that contain a user id, an external document number, a report name, etc. The Type of Field column contains either the exact field name (e.g. Customer Disc. Group)or a kind of consolidated name (e.g. User ID as there are various fields with different names that refer to a user id). For the complete overview and details download this Excel file.


Notes

• The comparison was done between NAV 2009 R2 and NAV 2013 beta
• You have to realize that this is based on NAV 2013 beta and as such still subject to changes
• In some cases the stretching seems to be not complete yet; for these I have logged a couple of entries on msconnect

Читать дальше