How to Edit Extend Table properties in the D365FO?

(0) Share

Report

Posted on by Riyas ahamed F

1,215

Hi Guys,

i have a Extend table in the HCMPosition fields <PositionId> is there by default mandatory "Yes" i need it set to "No" for that in the TableExtension We can edit the XML file

What is the tag to change the mandatory property to No?

Regards,

Riyas Ahamed F

I have the same question (0)

All responses (7)

Answers (5)

Verified answer

Blue Wang on at

Like (1)

Report

Hi Riyas,

Some properties cannot be modified by extending the table, but you can change it by code.

Please refer this thread:

https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/260201/modify-mandatory-property-on-existing-table-field-in-extension?pifragment-96834=1#responses

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Thanks for your replay Blue wang, it is possible edit by XML? if yes let me know.

regards,

Riyas ahamed F

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (1)

Report

Hi Riyas,

Modifying XML can meet the needs, but that's not a reliable way

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

You can not change this to No using extensions. Certain properties are not extensible. Modifying xml is not the correct way , Its might work in your dev machine but its not going to work in environments where you deploy binaries like prod or UAT.

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Thanks for your valuable Answer Sukrut,

Currently, i am using Demo VM, so please let me know What is the tag to change the mandatory property to No?

it is my test purpose only.

regards,

Riyas ahamed F

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

Well , even if it is for test purpose i wont recommend you to change XML file. You can change it , if you just want to experiment see what it does or what impact it makes and revert back .

Another thing is positionId is primary key in HCMPosition table and it is required to be filled in, so it does not make sense to make it non mandatory.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

You can't change mandatory fields to not mandatory via extension. And as pointed out, in this case it's a field in the primary key so you could not enter more than one record in the table with empty position id.

Another important point is that the standard functionalities trust that this field always has value. You would not want to break the system, right?

Just use the Visual Studio to do the dev work. And don't try to "hack" your way around the system rules. I'm sure your customer wants a stabile system, not a system with hacks and broken functionality.

Was this reply helpful? Yes No