Approval

[Former Member]

Dear all,

I would like to create an approval on credit notes to fire when my base document date is greater than 30 days. Does anyone have an idea.

Regards

[Former Member]

This could be done through user approval by query. Something start with:

SELECT 'TRUE' or SELECT DISTINCT 'TRUE'

Thanks,

Gordon

[Former Member]

Gordon,

Please give me an example of an approval query where i base it with my base documents date.

Regards.

[Former Member]

sorted it.. Thanx

[Former Member]

i want to do something similiar, did you find a solution?

[Former Member]

SELECT distinct 'true' FROM RIN1 T0 WHERE T0.[BaseType] = 13 and $[$38.45.1] in (SELECT docentry FROM OINV WHERE DocDate < Getdate()-30)