Customers – AX / Dynamics 365 For Finance and Operations blog

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

Posted on 11 November 2022 by Marco Saad

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 – Add a contact to customer record

Posted on 30 August 2021 by Marco Saad

Select Accounts receivable > Customers > All customers. Select Cave Wholesales, US-004.Select Customer > Accounts > Contacts > Add contacts. For first name, enter Aaron, for last name, enter Painter.Select Save.Close all the pages.