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
Category: Vendor
AX – D365FO – GET NAME OF A SPECIFIC VENDOR from a given vendAccount #D365FO
public display Name VendorName() { Name ret; ret = VendTable::find("01052").name(); return ret; }
AX – D365FO – Get Name of a specific vendor #d365fo
To get the Vendor name just use vendTable.vendorName() method. This retrieves the Party name related to a specific vendor VendTable vendtable; str name; select vendtable where vendTable.AccountNum == '123456' ; name = vendTable.vendorName();
AX – D365FO – Create a Data Entity to export all Vendor Contact informations (Emails, Phones, etc..)
This example will show how to create a Data Entity to export all Vendor Contact informations like emails and phone numbers. First create a Data Entity (to do this read my article : https://d365ffo.com/2021/06/29/ax-d365fo-create-a-data-entity) Then you have to insert Table Data sources and link them together : Click FInish Synchronize database and Build the solution … Continue reading AX – D365FO – Create a Data Entity to export all Vendor Contact informations (Emails, Phones, etc..)
AX – D365FO – Vendors contacts informations (Emails, telephones, etc..)
D365FFO – AX – Updating Vendor Address using X++
Hi, Vendor address state value can be retrieved from tables VendTable, DirPartyTable, DirPartyLocation, LogisticsLocation and LogisticsPostalAddress (or) through the view DirPartyPostalAddressView(mentioned in the blogs suggested by Vilmos) You can use the following job(query) to get the data and to update the state:static void VendorState(Args _args){VendTable vendTable;DirPartyTable dirPartyTable;DirPartyLocation dirPartyLocation;LogisticsLocation logisticsLocation;LogisticsPostalAddress logisticsPostalAddress;LogisticsAddressState LogisticsAddressState; while select vendTablewhere vendTable.AccountNum … Continue reading D365FFO – AX – Updating Vendor Address using X++
Updating Vendor Address using X++ – D365FFO -AX
Hi, Vendor address state value can be retrieved from tables VendTable, DirPartyTable, DirPartyLocation, LogisticsLocation and LogisticsPostalAddress (or) through the view DirPartyPostalAddressView(mentioned in the blogs suggested by Vilmos) You can use the following job(query) to get the data and to update the state:static void VendorState(Args _args){VendTable vendTable;DirPartyTable dirPartyTable;DirPartyLocation dirPartyLocation;LogisticsLocation logisticsLocation;LogisticsPostalAddress logisticsPostalAddress;LogisticsAddressState LogisticsAddressState; while select vendTablewhere vendTable.AccountNum … Continue reading Updating Vendor Address using X++ – D365FFO -AX
AX / Dynamics 365 For Finance and Operations blog 