Hi there,
I'm trying to write an approval user query to check the sum of LineTotal of a particular item in a marketing document, such as a Purchase Quotation. Is that possible?
SELECT DISTINCT 'TRUE' WHERE
(SUM($[$38.21.number]) WHERE $[$38.1.11] = 'ZZ-SL-00005') > 5000
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.