Skip to Content
0
Former Member
Apr 30, 2014 at 04:59 AM

Approval Query when a Sales Return Document is Created.

63 Views

Hi all,

When i post a Sale Return Document , the following Approval Query is not working when i try to work out for Approval of a New Sales Return document is Created.

Select 'TRUE' From ORDN T0 Where T0.DocStatus='O' And Datediff(dd,T0.DocDate,Getdate())=0

Is there any wrong with this Query?