lookup in item number

(0) Share

Report

Posted on by karthik143

327

hi all after creating sales order i am trying to add items.if i click item number it will open one lookup in that lookup ill get itemnum,name,drawing group,item group.i want to add one more field in that lookup is search name that field coming form eroresproduct table.whare can i add code for this...please see sample image

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

AOT > \Forms\SalesTable\Data sources\SalesLine\Fields\ItemId\Methods\lookup()

That method is overridden, and it drives that what form is being presented when you do a lookup depending on a bunch of settings and configurations.

Debug which one it is for you, then you could customize the lookup form used based on your requirements afterwards.

Most likely it is \Data dictionary\Tables\InventTable\Methods\lookupItem(), and all you need to do is enhance the query built there to join your additional datasource and add the lookup field.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

If you go to AOT > Forms > SalesTable > Data Sources > SalesLine > Fields > ItemId and open the lookup() method, you'll find that are several different ways that can be used (depending on context), but the most common one calls InventTable::lookupItem(). This method is used from several other places, therefore consider if you want to change them too.

Was this reply helpful? Yes No
Suggested answer

Hamza Bin Mushtaq 160 on at

Like (0)

Report

Hi Kathrik,

As Vilmos and Martin explained above.

You can add the lookup field here in this method.

Please note, what Martin said that this method is called from other places also so you need to take care of that too.

Regards,

Hamza

Was this reply helpful? Yes No
karthik143 327 on at

Like (0)

Report

hi vilmos thanks for your replay i have written some code its not working please look into this

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(InventTable),_ctrl);

Query query = new Query();

QueryBuildDataSource qbds2;

QueryBuildDataSource qbds3;

QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(InventTable));

qbds2 = queryBuildDataSource.addDataSource(tableNum(EcoResProduct));

qbds2.relations(true);

sysTableLookup.addLookupfield(fieldNum(InventTable,ItemId));

sysTableLookup.addLookupMethod(tableMethodStr(InventTable,itemGroupId));

sysTableLookup.addLookupfield(fieldNum(InventTable,NameAlias));

sysTableLookup.addLookupfield(fieldNum(InventTable,ItemType));

sysTableLookup.addSelectionField(fieldNum(InventTable,Product));

sysTableLookup.addLookupfield(fieldNum(EcoResProduct, SearchName));

sysTableLookup.parmQuery(query);

sysTableLookup.performFormLookup();

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report
Please never forget to explain your problem; "its not working" isn't sufficient.

Fortunately I see your bug in this case.

Let me explain what your code does. You've written this:

sysTableLookup.addLookupField(fieldNum(EcoResProduct, SearchName));

AX finds the ID of SearchName field in EcoResProduct table; lets say it's 5. The value is passed to addLookupField, so it looks like this:

sysTableLookup.addLookupField(5);

Notice that there is no information about table; sysTableLookup will use the table you specified SysTableLookup::newParameters(), which is InventTable. Therefore you're adding a field from InventTable (the one with ID 5), not from EcoResProduct as you intended. You need a different approach.

One possibility is downloading SysMultiTableLoookup, which works similarly to SysTableLookup, but it allows you to choose the datasource.

Alternatively you could create a view with those two tables joined and use the view in SysTableLookup.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Martin is right with the fieldId belonging to the original lookup table in your case.

Take a look at an example similar to your request, where they have built a query to their needs and built a custom lookup form, that is what you could/should do as well:

community.dynamics.com/.../how-to-create-form-lookup-lookup-multiple-tables

Was this reply helpful? Yes No