Export to Excel Error

There are multiple reasons for failures when exporting to Excel from AX 2012.  It's difficult to detect the reason why as it's part of the system, however there is a forum post that details a few reasons as to why the failure may occur.

Today I found yet another.  We had a strange 'empty' column in the PurchLine (Purchase order lines) form.  It was a field that ended with '_MX' and assumed it to be Mexican functionality.  We just changed the control's visibility in the form and the export to excel worked without problems.

Excel Export Error

Perhaps the omission was at the table field level, however, and we should have added MX to the CountryRegionCodes list.  The Base Enum 'VendorOperationType_MX' DOES have the Country Code applied, however.