Skip to Content
0

Alerts for Open GRPO more than 30 days from posting date

Mar 09, 2017 at 01:32 AM

99

avatar image
Former Member

Hi SDK Experts!

I need help with the creation of an alert query for open GRPO's more than 30 days from the posting date.

Thank you!

SAP Business One
SAP Business One SDK | query | alert | alert query
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
Nagarajan K Answered Mar 09, 2017 at 02:06 AM
0

Hi,

Try this query,

SELECT T0.Docentry,T0.[DocNum], T0.[CardName], T0.[DocDate], T0.[NumAtCard] FROM OPDN T0 WHERE Datediff(day,T0.[DocDate] ,Getdate()) = 30

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Former Member
Mar 09, 2017 at 02:58 AM

Hi Mr. Nagarajan K,

The query works well, thank you!

I just changed the Datediff(day,T0.[DocDate] ,Getdate()) = 30 to Datediff(day,T0.[DocDate] ,Getdate()) > 30

0
Comment