CODEWITHSUNDEEP
axapta
Brent Lamborn
Brent Lamborn

Reputation: 1390

Increase capacity of a column in AX 2009

I'm extremely new to AX and am starting with something very simple. I need to increase the size of a column named Invoice. In the AOT, the StringSize property on the column is greyed out so I cannot change it there.

In SQL Server (2005) the column is a nvarchar(20) so I'm thinking AX might just be using whatever DataType is defined in the db.

If I attempt to increase the size of the column in SQL Server it tells me that the table would need to be dropped and re-created.

What is the best way to increase a column size in AX?

Upvotes: 4

Views: 1657

Answers (1)

dlannoye
dlannoye

Reputation: 1756

To increase the capacity of the column you would normally change the StringSize property on the InvoiceId extended data type.

However, in this case the InvoiceId extended data type extends from the Num extended data type and you will need to make the change there. This size increase will also affect all other extended datatypes that extend Num.

This extended datatype can be found in the AOT at \Data Dictionary\Extended Data Types\Num.

Upvotes: 4

Related Questions