Question Status

Verified
Ali Awan asked a question on 16 Mar 2013 2:52 AM

Hi,

Please advise 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

We will appreciate your immediate response.

Muhammad Ali Awan

Reply
Omer Awan responded on 16 Mar 2013 6:49 AM

Dear Ali Awan,

For each field in Dynamics AX we have a extended data type also. You can open the dynamics Development workspace using Ctrl+Shift+W keys and open the AOT. In AOT go to data dictionary and select Extended Data type and search JournalDescription or Description and change the string size to 200. If the description is changed all the description field throughout the AX will be changed to 200. For journal only change JournalDescription. Hope it will solve your issue.

Omer Awan

Learn from birth till death

Reply
Ali Awan responded on 17 Mar 2013 3:41 AM

Dear Omer,

Thnak you for your prompt response. we have already check that while the string size field in uneditable. please advise.

Reply
Omer Awan responded on 17 Mar 2013 4:45 AM

Dear Ali,

Actually i told you 2 EDTs the JournalDescription is uneditable as it is further extended from Description, you can edit the description EDT or create a new EDT named InventoryMovementJournalDescription and link to your filed of interest.

Regards,

Omer Awan

Learn from birth till death

Reply
Ali Awan responded on 17 Mar 2013 5:23 AM

if i  increase the length of description then what will happen any issue?

Reply
Omer Awan responded on 17 Mar 2013 6:06 AM

No issue will occur. As this is used to change the field length if required. May be it increase the size of the DB.

Learn from birth till death

Reply
Ali Awan responded on 17 Mar 2013 7:08 AM

Dear Omer,

Jazakallah for you kind help.

can we revert back if we require.

Reply
Omer Awan responded on 17 Mar 2013 7:10 AM

Dear Ali,

Yes you can revert back but keeping in mind the data will be truncated if it is lower than actual value

Omer awan

Learn from birth till death

Reply
Verified Answer
Ali Awan responded on 17 Mar 2013 7:28 AM

I have change the EDT description and its now 100 character and journal description is also 100 char but on the form it shows only 60 char and does not take further input.

Please advise

Reply
Omer Awan responded on 17 Mar 2013 7:36 AM

Dear Ali,

Have you synchronized the database after you changed it. Automatically a dialog for synchronize will appears. It will update all the references.

Omer Awan

Learn from birth till death

Reply
Ali Awan responded on 17 Mar 2013 7:42 AM

yes it automatically synced. i restarted the AX client and it worked.

Thanks a lot for your help. please keep in touch my email is aliawan@alidc.com.pk

Reply
Suggested Answer
Omer Awan responded on 17 Mar 2013 7:44 AM

So the EDT change worked  for you need to be synchronized to make effects.

Learn from birth till death

Reply
Verified Answer
Ali Awan responded on 17 Mar 2013 7:28 AM

I have change the EDT description and its now 100 character and journal description is also 100 char but on the form it shows only 60 char and does not take further input.

Please advise

Reply
Suggested Answer
Omer Awan responded on 17 Mar 2013 7:44 AM

So the EDT change worked  for you need to be synchronized to make effects.

Learn from birth till death

Reply