Skip to Content
0
Former Member
Aug 24, 2015 at 08:04 PM

Query with the date that a sales order was cancelled

1224 Views

My Daily Bookings report is picking up the daily sales and daily cancelled sales orders. We have an issue when a sales order is created in month one, but cancelled in month 2. The bookings report in month one should show the sale, but in month 2 show the cancellation (with negative numbers)

I am having difficulty querying the date that a sales order was cancelled using ADOC and ADO1 etc tables. I am trying to select:

Select

Sale Order number,

Status,

Posting Date,

Date cancelled

From

ORDR

AD01

Where

Posting Date between '[%1]' and '[%2]'

OR

Date cancelled between '[%1]' and '[%2]'

If the cancellation date is with the same period as the posting date, then displaying only the cancellation date is fine (or both if need be)

thanks,

Tony