Dynamics Community Forum Thread Details

Adding new International Country field to CustTable

Last month per user request I added a new field to the Customer Details table CustTable to record the final country of destination, for shipments delivered to a port forwarder.

The address on the Customer Master stores the address of the Freight Forwarder, say in FL, in the US.

The new field is of extended data type AddressCountryRegionId, which gives it the nice lookup to select a valid country.

However, once the international country was selected, unbeknownst to us, it eliminated the State and County codes of the Customer itself.

We didn't discover this issue until hundreds of addresses had been affected, and now have to have their State and County codes replaced.

It appears this occurred based on the AddressMap, but I am unsure. It definitely is caused (on demonstration) by this new field.

Question:

Is there a way to selectively turn off that functionality for a given field? It seems like a final country of destination would be a common business need.

If not, is there a way to force a string field to have the lookup of the CountryRegion? (I've tried by inserting a lookup method to do just that, but no combo box/dropdown).

Quick Links

Leaderboard