Alert on time period for Invoice
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.
Suda Sampath replied
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