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:
Sale Order number,
Posting Date between '[%1]' and '[%2]'
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)