Finance | Project Operations, Human Resources, ...

How to create a custom lookup to show delivery addreses

(0) Share

Report

Posted on by steen.rabol

134

On a new forms grid, I need a lookup that can display delivery addresses related to a customer.

The tricky part is to show the address, but store the ref recid

the 'standard' way is to have a reference group on the form, but that doe not allow me to filter the records that is shown by customer or address type.

I have tried a SysTableLookup, but then only the recid is displayed on the form

Any hints ?

Thanks

Kind regards

Steen

I have the same question (0)

All responses (4)

Answers (0)

Martin Dráb 237,697 Most Valuable Professional on at

Like (0)

Report

I would use a reference group, override lookupReference() and implement the lookup with a custom filter there.

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
Found related articles for you on how to create a lookup in D365FO, you can simply check it out, hope it helps.
How to create lookup in D365FO using X++ (d365snippets.com)
Custom lookup in D365 X++ – Sampath's D365 F&O Technical Blog (wordpress.com)
Best Regards,
Hana

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Hi Steen,

As Martin mentioned if you are using reference group control then you need to override the lookupReference method. Also, you need to use the SysReferenceTableLookup class for reference group control.

Refer to the below blog for getting the customer delivery address from the list of tables.

https://rahulmsdax.blogspot.com/2019/09/get-customer-address-by-type-in.html

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

The simplest way would be to copy the standard code which is present in the SalesTable Form. If you navigate to SalesTable Form, in the datasource of SalesTable, under field DeliveryPostalAddress, you can see a method called lookupReference. That will help you.

Was this reply helpful? Yes No