Validate/Export Vendor Address(es) in AX2012

Hi,

There are couple of ways we can validate (or) export vendor address data(to excel) with help of existing views/queries and without much customization. Query that holds this information is VendorPostalAddress and view is DMFVendorPostalAddressView.

Through query VendorPostalAddress:

1. Create a view VendorPostalAddressView(namely) and include query VendorPostalAddress with the required fields as shown below.(Right click >)Open the view, to view the the data in table format and can be exported to excel(through shortcut key Ctrl+ T)

2. Through table browser option on view DMFVendorPostalAddressView, vendor address details can be validated and exported to excel.

Regards,

Chaitanya Golla