AX 2012: LogisticsPostalAddress unknown value

Posted on

Problem:

I learned something new about DateEffective tables today. I had a customer requirement to store addresses in a Standard AX table, PdsApprovedVendorList. So I created a relationship between my table and LogisticsPostalAddress table, adding foreign key to LogisticsPostalAddress to my table. Then I added this field to a form and set ReplacementFieldGroup property of the control to LocationReference.

Everything worked as expected but the problem surfaced when user modified one of the addresses in the Global Address Book which were referenced in my table. The custom field began to show Unknown for the address that was updated by user.

Resolution:

1. Add new Reference Data Source of LogisticsPostalAddress to the data source of your table on the form.

Untitled

2. Add the following lines of code to the form’s init method:

legManufacturerAddress_ds.addFieldToSelectionList(fieldNum(LogisticsPostalAddress, ValidFrom));
legManufacturerAddress_ds.addFieldToSelectionList(fieldNum(LogisticsPostalAddress, ValidTo));
legManufacturerAddress_ds.addFieldToSelectionList(fieldNum(LogisticsPostalAddress, CountryRegionId));

3. Add the following lines of code to the executeQuery() method of parent data source to which reference data source is added before super() call. In this case, it is PdsApprovedVendorList.

legManufacturerAddress_ds.validTimeStateUpdate(ValidTimeStateUpdate::Correction);
legManufacturerAddress_ds.query().validTimeStateDateTimeRange(DateTimeUtil::minValue(), DateTimeUtil::maxValue());

Reason:

LogisticsPostalAddress is a DateEffective table. When user modifies an existing address, system creates a new record instead of updating the existing record. That’s why references do not get resolved after address modification.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s