Block creation of an A/R invoice

[Former Member]

Hello everyone,

I have a doubt; during my operation itu2019s common to change the a/r invoice posting date, to create an Invoice. Do you know if thereu2019s a way for asking authorization in the creation of this kind of documents. If the date of creation differs from the posting date.

Thanks,

[Former Member · Accepted solution]

Try this one:

IF DateDiff(DD, $[$10.0.0\], GetDate()) != 0

SELECT 'true'

[Former Member · Accepted solution]

Thanks Gordon, it works Ok

[Former Member]

This could be done through user query approval template. You have to create an alert query first starting with SELECT Distinct 'true'.

Thanks,

Gordon

[Former Member]

Hello, I try buy doing this queries but they do not work,

1) SELECT DISTINCT 'TRUE' From OINV T0 Where T0.[Docdate] <> T0.[CreateDate]

2) If $[$10.0.0] <> $[$??.0.0] SELECT DISTINCT 'TRUE'

The second one is almost working but I donu2019t know how to obtain the Item id of the T0.[CreateDate]

Thanks