query support for approval templates

[Former Member]

hi

i want set approval on the base of query so i write query as follow

SELECT T0.[CardName], T0.[CreditLine] FROM OCRD T0 INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode INNER JOIN OINV T2 ON T0.CardCode = T2.CardCode

WHERE T1.[GroupName] ='INSTATION' AND

T0.[CreditLine] >= 0 AND

T0.[CreditLine] <=50000

GROUP BY T0.[CardName],T0.[CreditLine]

but on this condition approval is not set so if i write query wrong then pls send updated quer

regards,

sandip

[Former Member · Accepted solution]

The approval query has specific format. Please try this one to assign to your approval:

SELECT Distinct 'TRUE' FROM OCRD T0 INNER JOIN OCRG T1 ON T0.GroupCode = T1.GroupCode AND T1.GroupName ='INSTATION'

WHERE

T0.CreditLine >= 0 AND

T0.CreditLine <=50000 AND

T0.CardCode = $[$4.0.0\]

It can not be run under Query Generator.

Thanks,

Gordon

[Former Member]

Hi

There are plenty of threads how to write user defined query for writing approval query .

You have to use something like this ;

Select Distinct true ...

Here is what I found for you

Please search forum first

Thank you

Bishal

Edited by: BIshal Adhikari on Dec 11, 2008 9:59 AM