Announcements
No record found.
Hi I would like to ask if SysMultiTableLookUp class exists in D365? Because I need to add more tables in the lookup and it seems SysTableLookUp only available? Can someone guide me through this? Thank You very much.
Can you tell us what you would like to achieve functionally?
I need to add from the ItemId Lookup some fields in EcoResProduct which has relation to purchLine and CustVendExternalItem Table
SII1MNL,
Do you want to make extra field sortable and searchable? If not, you can create display methods and use them instead of fields.
Hi SII1MNL,
SysMultiTableLookUp class does not exist in D365FO, it does not seem to be a standard class.
http://kashperuk.blogspot.com/2008/09/sysmultitableloookup-dynamic-lookups.html
-
But for your requirement, using multiple tables, You can try to create a view, then use the query in the view using the SysTableLookup class.
could also check vendor lookup in planned orders
I am able to solve my issue regarding multitable lookup, I created a View Table instead and combine all the necessary tables needed for the View Table.
in my itemID lookup I want to add external itemID (ItemID - "External Item ID" - Name Alias) I use the method Inventtable.defaultExternalItemId() but it is not showing the External Item ID based on vendAccount in the purchline.
But how could that method know what Vendor you are having on the purch line? You need to find a method that allows you to send a vendor account number, so that the system can find the correct external item id.
The correct method is InventTable.externalItemId, which allows you to specify ModuleInventCustVend (in your case you need to use "Vend"), and a customer/vendor account number.
Also, seems that you posted the same question in two places. That's not necessary and not useful. Let's continue the discussion here: community.dynamics.com/.../defaultexternalitemid-not-working
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 495 Most Valuable Professional
André Arnaud de Cal... 432 Super User 2026 Season 2
CU10121822-0 366
