Skip to Content
avatar image
Former Member

Alert on time period for Invoice

Hi

We need to have a alert to alert the user if a order hasn't been converted within 48 hours. In SAP we have the Doctime field but how could one use this in a SQL query inconjuction with the docdate to see where a document haven't been converted within 48 hours.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 07, 2008 at 04:21 PM

    Hi Lindsay,

    It is possible by creating a user query to trigger the alert. However, it might be better to have a daily report to show them. You can create a XL Report with auto job to reach your goal.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 07, 2008 at 04:19 PM

    Could you ellaborate on what you mean by Convert?

    Convert from which document to Invoice?

    Add comment
    10|10000 characters needed characters exceeded