Skip to Content
author's profile photo Former Member
Former Member

Alerts for Open GRPO more than 30 days from posting date

Posted on Mar 09, 2017 at 01:32 AM 232 Views

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
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Nagarajan K
    Nagarajan K
    Posted on Mar 09, 2017 at 02:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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