Change Drill Down in the Page?

Hi all,

A freind of mine asked me yesterday that one of his client want to change the Drop Down option in RTC Page.

As shown in image below, and client says that when he want to choose item No. he don't want No.,Description,Base Unit of Measure,Bill of Materials,Unit Price.

Insted of it he want No.,No. 2,Description,Unit Price,Inventory Posting Group,Vendor No.

Yes this can be changed.

Goto the source Table of that page which is getting opened during drop down, in our case its item table.
Design the table and from the view menu you can access the Field Group as shown in picture below.

Here you can set the DropDown Menu as per customer requirment.

Below is the image that shown the changes i have done on the same.

Save the changes in the table and start RTC to see changes in the Drop Down Menu.

Finally we have achieved what we wanted.

There are somethings to remember -

1) It will change the DropDown for all the places where item will get lookup.

2) You cannot or i should say should not change the name of the Property, that is HARD CODED as DropDown. Any name other than this will not work.

Thanks,

Saurav Dhyani.