web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :

Company Lookup for an Unbounded Control in D365FO

dasdasd Profile Picture dasdasd 841

 In D365FO, you can create a Company (DataArea) lookup for an unbounded control using SysTableLookup without requiring any datasource binding.

[FormControlEventHandler(formControlStr(PurchCreateFromSalesOrder, DSS_IntercompanyId), 
FormControlEventType::Lookup)] public static void DSS_IntercompanyId_OnLookup(FormControl sender, FormControlEventArgs e) { SysTableLookup sysTableLookup; Query query; QueryBuildDataSource qbds; sysTableLookup = SysTableLookup::newParameters(tableNum(CompanyInfo), sender); sysTableLookup.addLookupfield(fieldNum(CompanyInfo, DataArea)); sysTableLookup.addLookupfield(fieldNum(CompanyInfo, Name)); query = new Query(); qbds = query.addDataSource(tableNum(CompanyInfo)); // Optional filter // qbds.addRange(fieldNum(CompanyInfo, DataArea)) // .value(SysQuery::valueNotEquals(curExt())); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); }

Key Point

Use CompanyInfo to display available companies/legal entities and pass sender to SysTableLookup::newParameters() for the unbounded control.


This was originally posted here.

Comments

*This post is locked for comments