Increasing the length of the Description field in movement journal in AX 2009

Question

How can we increase the field length of Description field up to 200 characters available in Movement Journal in Inventory module in AX 2009?

The field is InventJournalTable_DescriptionInventJournalTable(InventJournalTable).Description

score 6 · Answer 1 · answered Mar 18 '13 at 20:09

6

Create a new Extended Data Type of type String.
Set the StringSize property of your data type to 200.
Find the JournalDescription Extended Data Type in the AOT.
Change the Extends property of JournalDescription to the name of your new data type.
Synchronize the database.

answered Mar 18 '13 at 20:09

SShaheen

1,012
7
21

And in some cases you should restart the AX client after you made this changes. – alexlz Jan 04 '16 at 08:48

score 5 · Answer 2 · answered Mar 27 '13 at 22:08

5

You can edit standard EDT's by going to System Administration - Setup - System - Modify data types. There you can adjust the length of standard EDT's which cannot be adjusted otherwise.

answered Mar 27 '13 at 22:08

Kenny Saelen

894
1
5
16

score 0 · Answer 3 · answered Mar 18 '13 at 13:37

0

The InventJournalTable has it's Description field of extended data type JournalDescription (String Size: 60). Therefore open the AOT, Data dictionary and Extended data type branch, and find the JournalDescription entity, increasing it's string size to 200. Sincronize...

And document your changes.

answered Mar 18 '13 at 13:37

ian_scho

5,906
9
35
51

The StringSize property of JournalDescription cannot be edited, because it extends Description. I would not advise modifying Description, because many other data types extend it, and you may not want to change those fields unintentionally. – SShaheen Mar 18 '13 at 20:11
"...cannot be edited, because it extends Description." I also agree that it is rare to make changes such a generic EDT. I'll vote your answer up then :) – ian_scho Mar 19 '13 at 07:15

score 0 · Answer 4 · answered Sep 05 '17 at 06:20

You cannot edit the JournalDescription even in the AOT because other transactions will be affected. And you don't want to change the records of those transactions either. Think of the possibility that something will be affected once you change the length or any properties of a field. Best thing is, try to do it in the Test environment of your system.

Increasing the length of the Description field in movement journal in AX 2009

4 Answers4

Linked