Query for terms in approval template of approval procedure

[Former Member]

dears

i need to write a user query for approval template terms that chek for any price zero in invoice items .

i tried the true query

select 'true' from inv1 where $[inv1.price]=0

however the invoice executed without asking for approval procedurs.

any help will be appreciated!!

talal

[Former Member]

Hi Jesper

thank u for reply

i really dont know the functionality of alert or transaction notificatiofor this purpose !!!

can u advice me where i can read about them or f u have abrief example how to setup an alert that alert on zero price n sales doument line items before processing the document

thank n advance

talal

[JesperB1]

Hi Talal,

Yes, that is the problem, the Alert would be after the document has been added. If that is not use for you then discard.

Try TransactionNotification. Unfortunately I am not the person to give you that code but there should be other people here who can advice.

Jesper

[Former Member]

Hi,

Its not possible on row level Price.

Try to Document total procedure, it will work.

SELECT Distinct 'True'  FROM OINV T0 WHERE $[OINV.DocTotal]='0.00'

Thanks,

Madhan.

[JesperB1]

Hi Talalh,

The approvals will not work on row level.

Any approval query can only see the first line of the document.

You can set up alerts or maybe try with Transaction Notification.

Hope it helps,

Jesper