Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Add columns to item ID lookup

Posted on by 5

Hi,

When creating a new Purchase order, we must select the item number from a lookup. I want to modify the columns of this lookup.

 I want to modify the columns shown in the lookup of Item number field.

I have added a new field "Item model group" to Purchline Table. I want to add this Field to Auto Lookup

Could anyone advise how to modify the columns in item number lookup of  fields

Thanks in advance

4812.po.png

  • Ismail Mohamed Profile Picture
    Ismail Mohamed 570 on at
    RE: Add columns to item ID lookup

    Martin Dráb

    thanks , i didn't see your replay

    Done

  • Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: Add columns to item ID lookup

    Ismail, please read my reply. It explains that I looked at the lookup() method and found the answer there.

    In general, either the lookup is generated by AX, it's generated by custom code in lookup() (or lookupReference()) method or there is a modeled form associated with the EDT (FormHelp property) or used from code (that's the case discussed in this thread).

  • Ismail Mohamed Profile Picture
    Ismail Mohamed 570 on at
    RE: Add columns to item ID lookup

    Martin Dráb - Chaitanya Golla 

    please how you know that ?

    is there anyway to know the used form for lookup !

    is there any property tell me the used form in the lookup ?

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: Add columns to item ID lookup

    Hi,

    Please modify the form InventItemIdLookupPurchase(as suggested by Martin) shown below to get item model group:

    4762.ModelGroup.jpg
    Thanks,
    Chaitanya Golla

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 225,490 Super User on at
    RE: Auto Lookup

    If you look at ItemId field of PurchLine datasource, you'll see that it has lookup() method overridden. Inside the method, you can find that it uses InventItemIdLookupPurchase form. That's where you can add extra columns.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    RE: Auto Lookup

    Hi Sravan,

    For what reason did you include the Item model group on the purchase lines? If it a new field on the PurchLine table? In fact it has nothing to do with the lookup.

    You have to verify if a lookup form has been created and used for the InventTable. If not, it will use the fields listed in the AutoLookup field group of the InventTable.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans