Skip to main content

D365 F&O TechExpert

Search This Blog

D365FO – “NOT EXISTS” join on an AOT Query

on July 19, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

If you need to create a relation between 2 tables using a NOT EXISTS JOIN on an AOT Query you can use the join mode property

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

Electronic Reporting Explained in D365 FO

In this post we’ll be looking at a classical data export scenario and showing how it can be implemented using the Electronic Reporting (ER) feature in Dynamics 365 for Finance and Supply Chain Management (D365F&SCM). Introduction Minimal Configuration of ER Parameters Defining the Data Model Mapping from Database to Data Model Mapping from Data Model to XML Format Starting the Export Conclusion Introduction As Microsoft mentioned , the ER framework replaces 20 or so existing frameworks, so it’s expected that the complexity of its configuration is high and the learning curve is steep. Others have covered the advanced setup in depth. What we’re trying to achieve here is to add some clarity and show how a simple export is done using ER by linking the concepts specific to ER with more familiar terms used in the power-user and development worlds like data selection, serialization or transformation. The scenario we’ll be looking at is very simple : exporting some ...

Enable/Disable form control (COC) in X++

Purpose: The purpose of this document is to demonstrate how we can enable/disable a workflow fields based on workflow toggle on header .form control in X++ based on a business logic. Product: Dynamics 365 for Finance and Operations, Platform Update 9. Development approach: Customization through extension. we need to show workflow related fields in VendInvoiceJournal list page when a transaction enabled with workflow toggle. Development: Create a COC of a standard form method enabling/disabling the form controls. In this case, we are creating a COC of a standard method VendInvoiceJournal form. Please find the COC method definition as follows. I had four custom controls already added in my form through extension and enabled Auto declaration = YES for all controls [ExtensionOf(formDataSourceStr(VendInvoiceJournal, VendInvoiceJour))] final class VendInvoiceJournal_Extension { public int active() { ...

CrossCompany and changeCompany using x++.

CrossCompany and changeCompany using x++. CrossCompany: Required company filter: MyTable myTable; container conCompanies = ['cmp1', 'cmp2', 'cmp3']; while select crossCompany : conCompanies * from myTable { // code } All company filter: MyTable myTable; while select crossCompany * from myTable { // code } Applying On Dynamic queries: Query query = new Query(); QueryRun queryRun; QueryBuildDataSource qBDS; qBDS = query.addDataSource(TableNum(CustTable)); // Way-1 (we can add required company) query.allowCrossCompany(true); query.addCompanyRange('cmp1'); query.addCompanyRange('cmp2'); ...

Powered by Blogger