+6I created two subqueries. One totals the sales booked by order date and the other totals the invoices billed by doc date. When I add the two subqueries to the main query and try to filter on a date range I get the object reference error.
Booked Query
Invoiced Query
Both are grouping by date, the formula is makes the amount negative if a CM.
Conditions
Main left joins invoiced query to booked query by date.
Without the conditions the data is returned
+16Do you have the conditions on the main or on the subs?
+6yes, for bookings, exclude order type behavior of TR and QT and added OrderDate not empty
Yes, for invoiced, released and docdate not empty
For main, only the date range conditions.
+16Can I see your joins?
+6Even when I just had the booking subquery in the main query it blew up on the date conditions. If I don’t use the date conditions I can add filters like this month, this quarter, YTD using the start and end dates,
+16I’m afraid I don’t have any ideas 🤔
+6Thanks for trying.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.