Solved

Add columns in by default IFS LOV ?

  • 16 December 2020
  • 3 replies
  • 606 views

Userlevel 5
Badge +8

Dear All,

 

    Could we add some columns in Default LOV in IFS 10 like

   In purchase order have Supplier column and data comes from LOV ( IFS LOV).

   I want to add column in this LOV.

  Is this possible , If Yes, then how can add columns.

   Kindly assist us.

 

Thanks in advance.

icon

Best answer by durette 16 December 2020, 23:10

View original

This topic has been closed for comments

3 replies

Userlevel 7
Badge +18

In IFS Enterprise Explorer, you can use a custom field.

When you publish a custom field, you should be able to add the _LOV view under Approved Detail Views.

But which Logical unit should get the field, and which view under that logical unit should display it for the LOV?

You can get the LOV view name by running the debug console while attempting the open the LOV. In this case, the LOV on the Supplier field for Purchase Order is VALID_SUPPLIER_LOV. (I’m in Apps 9 UPD 13.)

Once you get this, you need to know the Logical Unit it’s attached to, which isn’t always obvious. (In this case, does that belong to Supplier or SupplierInfo?)

You can run this in the SQL Query Tool:

SELECT * FROM dictionary_sys_view WHERE view_name = 'VALID_SUPPLIER_LOV';

In this case, it’s Supplier.

Then you’ll need to set up custom fields. Activate the rowkey, enable the LOV detailed view, create your reference field, and publish.

Userlevel 7
Badge +28

Once you publish the custom fields, you can change what columns are visible in the LOV using the Properties dialog on the field you want to adjust.

 

Userlevel 5
Badge +8

Thnx brother for you kind information.

 My issue is resolve as per ur answer