Increasing the length of the Description field in

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

Answer 1

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.

Answer 2

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.

Answer 3

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

Answer 4

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.