Customer Address Issue in AX 2012 R2 CU7

Finance and Operations/AX Developer Forum
1

Hi,

I am stuck up with the following issue.

The addresses for the customer does exist in the back end on the table level [LogisticsPostalAddress] but when we are opening the customer form, we cannot see the Addresses on the form under fast tab “Addresses”.

The details are as below for the issue:

  1. We are integrating AX with CRM via the middle tool called scribe.

  2. When the customer is created for the first time from CRM to AX, the address gets created and is properly attached to the customer on the table level as per the below relation and we could even see the address on the UI on the customer form

{ CustTable [Party] <----> [Party] DirPartyLocation [Location] <-----> [Location] LogisticsPostalAddress }

  1. Now when we are updating the customers address in CRM, the address gets updated in AX. BUT the field “Location” on “LogisticsPostalAddress” table set to zero[0] as a result of which the customer’s address is NOT visible on UI.

Question:

We have to set the value of the field “Location” from “DirPartyLocation” table to the field “Location” on “LogisticsPostalAddress” table. Since “DirPartyLocation” and “LogisticsPostalAddress” are related via field “Location” but the field value is set to zero[0] on “LogisticsPostalAddress” due to some issue.

Is there a way to set the value of “Location” field from “DirPartyLocation” table to the field “Location” on “LogisticsPostalAddress” table. BUT SINCE THE VALUE IS BLANK ON “LogisticsPostalAddress” table, HOW CAN WE SELECT THE PROPER RECORD THAT CORRESPONDS THE RECORD ON “DirPartyLocation” table.

Since the customer has many transactions, we cannot delete the customer. So we have to just set the broken link by setting up the value as detailed above.

I hope the issue is clear. Can anyone please help us resolve this issue as we currently stuck on how we can resolve this issue.

Would appreciate for quick response.

Regards,

Muneeb

2

Just to Add: The customer address update issue we have resolved. We want to correct the data that got corrupted as a result of the issue detailed above.

Is there a way to correct the corrupted data by writing some logic and running that logic via job or any other way out.

Would appreciate for quick response.

Regards,

Muneeb