I've narrowed my orders list to a single order (by dates, statuses, and vendor) with Order Total: 80.22 Under it I got: Summary Profit $164.40 Shipping $63.72 Tax $12.54 Total $240.66 I'd post a screenshot if forum software allowed me to upload.
Yes, I think it's a bug. Try it without the Vendor in the filter criteria to see if you get correct totals.
The grid results are due to SearchOrdersAsync() in OrderService.cs The totals are due to GetOrderAverageReportLineAsync() in OrderReportService.cs
The queries are similar, but not exactly the same. In the former, the vendor section has additional query = query.Distinct();
(P.S. The name GetOrderAverageReportLineAsync - "Average"? It seems like they meant to say "Aggregate", since it does Sum()'s, and is used by PrepareOrderAggregatorModelAsync() )
Do you have any other orders on July 23rd and July 31st? If yes, it could be related to this issue?
Also please try to without the Vendor filter as suggested by "New York" above. Does it help?
Is it possible to share details of this order (without any sensitive data)? The following data only: 1. Order subtotal 2. Order shipping 3. Order tax 4. Order total 5. Profit 6. A list of products with subtotals
I looked at the timestamps issue before posting: that particular order is from 7am CDT, that should be UTC noon i.e. the same date.
Yes, I do have more orders for that week, I narrowed it down to one for the report. W/o the vendor filter there are 7, totaling at 596.98 -- and the summary cell matches.
Good catch @New York! (FWIW I just finished rewriting a LINQ expression in our custom plugin as a triple-nested loop: it worked in 4.20 and with all the `async`s and `SelectManyAwait()`s in 4.40 it simply never returns. So I can't say I'm surprised.)
Order subtotal $54.80 excl tax Order shipping $21.24 excl tax Order tax $4.18 Order total $80.22 Profit $54.80 Items (no discounts so same "price" and "total"): SKU: 900011 $12.95 excl tax SKU: 9780870203572 $12.95 excl tax SKU: 9780870204432 $12.95 excl tax SKU: 9780870208614 $15.95 excl tax
I.e. the order itself looks OK, only the summary in the grid's b0rk3d.