Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
Former Member replied

Lindsay,

Please confirm the following.

In your business process do you copy Sales Order directly to AR Invoice without the Delivery step?

48 hours from which time? Creation of Sales Order or Delivery?

Thread about using DocTime for comparison

GetDate() in query generator doesn' return the time!

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question