Skip to Content
avatar image
Former Member

Alerts for Open GRPO more than 30 days from posting date

Mar 09, 2017 at 01:32 AM | 171 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

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Nagarajan K
    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