Skip to main content
Solved

How to add ASSOCATION_NO field to Supplier Search Box Manual Supplier Invoice

  • March 10, 2023
  • 4 replies
  • 113 views

Forum|alt.badge.img+1
  • Do Gooder
  • 1 reply

Hi all,

Is there any way to add ASSOCATION_NO field to Supplier Search Box referred to Manual Supplier Invoice? 

 

Best answer by rado

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. 

4 replies

Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Ultimate Hero (Partner)
  • 768 replies
  • March 10, 2023

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


Forum|alt.badge.img+1
  • Author
  • Do Gooder
  • 1 reply
  • Answer
  • March 10, 2023

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. 


Forum|alt.badge.img+10
  • Hero (Partner)
  • 222 replies
  • November 18, 2025

@Furkan Zengin ​@rado  would this be possible in IFS Cloud? How would a modification look like for this?


Forum|alt.badge.img+5
  • Sidekick (Customer)
  • 57 replies
  • November 18, 2025

@kvbe you need to add a custom field on the ManSuppInvoice Entity, then, via page designer, you’ll be able to add the field to search / read / filter your data