Hello

This requires a modification. The view in LoV is based on identity_invoice_info (invoice tab on supplier), however assosication_no field is on supplier_info_general.

I can propose you a workaround for this

In search, go to SQL tab for the advanced query and put the function below. Save it saved searches and whenever you search, it will pop-up small window to enter associaction no

IDENTITY = ifsapp.supplier_info_api.Get_Id_From_Association_No('&ASSOSIACTION_NO')

Hope this helps

Hello

 

This requires a modification. The view in LoV is based on identity_invoice_info (invoice tab on supplier), however assosication_no field is on supplier_info_general.

 

I can propose you a workaround for this

In search, go to SQL tab for the advanced query and put the function below. Save it saved searches and whenever you search, it will pop-up small window to enter associaction no

IDENTITY = ifsapp.supplier_info_api.Get_Id_From_Association_No('&ASSOSIACTION_NO')

 

 

 

 

 

Hope this helps

Thanks! Works as excepted.