Skip to Content
0
Jan 14, 2021 at 10:21 AM

help with approval query

23 Views

Hi everyone

This is my approval query

SELECT Distinct 'True' from OINV a inner join INV1 b on a.docentry = b.docentry where $[$38.14.Number]= 0

Problem is that it also triggers when a text line is added to the document.

how can i solve this so that it allows text lines but not item lines at zero

Regards