Delete 2 custom fields from CustTable in safety

(0) Share

Report

Posted on by vv1984

1,087

Hi,

I have need to delete two custom (not standard) fields (e.g CustTable.A_Field1, CustTable.A_Field2) from my CustTable in production environment (cus level).

There's been some mess with fields id (these two fields have different id in test environment and prod environment, so i need to delete them from prod and bring the test env. version in prod again)

What's the best way to delete them without corrupting data inside CustTable?

Is there some kind of best practice, check-list to follow?

Thank you in advance

regards

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 306,308 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Win32,

I assume you are using AX 2009 as you used this tag. The answer for AX 2012 would be different.

If you delete the fields from production, AX needs to synchronize and you will lose the current data in these two custom fields. If there is no data in these two fields yet, you can delete them. Make sure you have a valid backup before starting this task.

If you do have data, it might be better to align the field ID's in the test environment

Was this reply helpful? Yes No
vv1984 1,087 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi André,

my Ax version is 2009.

Loss of data saved in those two fields is not a concern. I just have to be sure that other fields' data is completely safe, this is very important.

Do you reccomend a backup anyway?

Thank you for helping

regards

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

there is a dirty trick you can play around, but try this on test environment first

smcdax.blogspot.com/.../dynamics-ax-database-synchronization.html

Was this reply helpful? Yes No
Anton Venter 20,848 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, since there is no data yet for those two fields, deleting the two fields from the table in the AOT will be safe. There is no risk for other fields in the table, the fields will just be dropped from the table. Remember to synchronise the database after deleting those two fields. Why not correct the ID's in the other environments like suggested?

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I would like to add here a point that this is the reason they recommend to use ModelStore while transferring customization from TEST to Live

technet.microsoft.com/.../hh352326.aspx;MSPPError=-2147217396

Was this reply helpful? Yes No
Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

sorry guys the question is related to AX2009, and my last reply is totally invalid here as the reply is related to AX2012. Apologies for not noticing Tag of question.

Thank you!

Was this reply helpful? Yes No