Skip to main content
Question

How to add sql Custom Attribute to SUPPLIER_ENT ?


Forum|alt.badge.img+7

I am trying to add a custom attribute to supplier_ent in IFS Cloud. In this custom attribute i want to write a select query and pass argument as v.supplier_id but i get an error as following.

 

Is there a way to add a custom attribute to supplier_ent ? 

 

 

Error in validation of Custom Attribute [C]. The column supplier_id refered to in table t is not an approved persistent Custom Attribute. Using view SUPPLIER_ENT as v. Using table SUPPLIER_CFT as t.

2 replies

Forum|alt.badge.img+16
  • Superhero (Customer)
  • 249 replies
  • January 23, 2025

Hi ​@Pheonix 

SUPPLIER_ENT has the field SUPPLIER_ID but the SUPPLIER base view only has VENDOR_NO, so IFS can’t find your v.SUPPLIER_ID field since it doesn’t exist on the supplier view.

Can you post your select statement?

Thanks,
Bryan


Forum|alt.badge.img+7
  • Author
  • Do Gooder
  • 11 replies
  • January 24, 2025

Hi ​@bdoucette,

This is exacly my problem. supplier view and supplier_ent view have two different column names

 

select delivery_terms from ifasapp.supplier_address_tab  where t.vendor_no = :supplier_id;

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings