SQL Customer Name Address Query in Dynamics 365 Finance and Operations

Показать описание

As X++ developer you are likely working in Hyper-V local virtual machine, where you have access to SQL and full control over the database. When creating SSRS report you likly create temporary table via X++ coding. But before doing so, at least this is how I do this - retrieve required field via SQL query. Another possible scenario is, instead of using BYOD (Bring Your Own Database) technology and building Business Intelligence reports in Power BI or old-good-days SSRS from BYOD database, you are copying the backup of your production D365 database and restore it in Azure DB or database which is hosted locally in your company IT infastructure. If exact DB copy is your way of building reports then you should know tables structure and use SQL query, View or even maybe stored procedure for additional flexibility. In this video we are working with customer name, address and taking into consideration address validity in the specific current or historical date