Delete duplicate records in Address Table in AX 2009

Hi all,

I got an issue in Dynamics AX 2009 i.e., Addresses are duplicated.

That means we can see more than one address for same AddrRecid and same type.

we need to delete the records based on AddrRecid and type

see this pic for clear idea

Thanks

Ram

Hi

Please refer the below links. Might be useful.

http://support.microsoft.com/kb/973555

http://daxture.blogspot.in/2011/12/delete-duplicate-records-from-table.html

Prabu

Hi prabhu,

Thanks for your reply, that code dose not suite for my requirement.

In my case duplicate address are created because of Virtual company concept

Thanks

Hi all,

Please tell me some piece of code in ax 2009 to solve this issue.

Thanks.