AX / D365FO – SQL queries to get customers and vendor addresses and contact details

Below are the sample queries to get the vendors and customers addresses and contact details. Change the code according to your requirement. All VendorsSELECT * FROM VENDTABLE WHERE VENDTABLE.DATAAREAID='CEU' All Addresses - Vendor SELECT * FROM  DirPartyPostalAddressView  JOIN VENDTABLE ON  DirPartyPostalAddressView.PARTY =VENDTABLE.PARTYWHERE VENDTABLE.DATAAREAID='XXX' All Addresses with PurposeSELECT LOGISTICSLOCATIONROLE.*,DirPartyPostalAddressView.*,VENDTABLE.* FROM  DirPartyPostalAddressView  JOIN VENDTABLE ON  DirPartyPostalAddressView.PARTY =VENDTABLE.PARTYJOIN DIRPARTYLOCATIONROLE … Continue reading AX / D365FO – SQL queries to get customers and vendor addresses and contact details

AX – D365FO – Create a new Address book and a new Prospect

 In this example we create a new address book. Also need to create a new party and associate the party with the new address book. Finally, we need to use this party to create a prospect. Go to Organization administration > Global address book > Address books. Select New.In the Name field, enter Denver.In the Description field, enter Denver Store.Select Save.In the Available Teams list, find and select the Safety team.Select … Continue reading AX – D365FO – Create a new Address book and a new Prospect

AX – D365FO – Check for duplicates in Global Address book

To check for duplicates in Global Address book : Go to Common -> Global Address book Select a record and click on "Checkfor duplicates" Select the values to include in the duplicate search (like name, state, zip code, phone, etc..) and press search The duplicated records will appear in the below grid If you want … Continue reading AX – D365FO – Check for duplicates in Global Address book