i’m new in AX Development , i want the easiest way to show in the New Sales Order i want to add beside the Name , SearchName Field , i have the query that can give me the data ,also i have attached the screen
here it is :
Select ACCOUNTNUM , NAME , NAMEALIAS as [SearchName]
from CUSTTABLE left join DIRPARTYTABLE on CUSTTABLE.PARTY = DIRPARTYTABLE.RECID
if anyone can give me a help on this ,i’ll be very thanksfull
The lookup is not overridden in any place and therefore it’s generated from fields defined in AutoLookup field group on CustTable table. You can add your field there. Note that it would have impact to many places in AX - if you want to change SalesCreateOrder form only, you’ll have to override lookup() method (probably for the form data source field).