Skip to main content

how can i create a LOV that combine both suppliers and customers ? or how can i populate an enumeration using select statement ?

Hi @SarahS ,

Please note the IFS application version this question is in reference to. 

 

Thanks,

Kasun

IFSAPP10

If you don’t mind being restricted to the identities you’ve done business with, the IDENITY_INVOICE_INFO table contains both entities and could be used as part of a join to both the customer and supplier tables.

 

 

Otherwise you would need to establish a UNION query (which I’m not sure will work directly as an enumeration).

Reply


Terms & ConditionsCookie settings