Alert on time period for Invoice

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

Hi

Sorry maybe i haven't said it clearly. The client wants to see what orders haven't been been closed by a invoice within 48 hours. The relavant product manager needs then to be notified so that the invoice is placed on high priority to get it.

[former_member583013 · Accepted solution]

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

[former_member583013]

Could you ellaborate on what you mean by Convert?

Convert from which document to Invoice?