Skip to Content
0
Former Member
Sep 05, 2013 at 05:27 AM

Sample Query for using in Tranaction Notification SP

28 Views

Hi,

Does anybody know how to write a query in Transaction Notification SP to control the value of a field based on a dynamic list of data?

This request is different from using linked table in UDFs definition.

For example, I need to control the "account code" field based on a formatted query list that I set in "Goods Issue" document and I want to block adding document how users can not enter other accounts out of the list.

Please consider that the list is based on a query and it is dynamic and when "IN" function is not usable.

Thank you