Hi James, Have you checked the OrderHeader.grandTotal I think you can use OrderHeaderAndRoleSummary view entity, This will not open in web tools but with a valid field to select and condition this will return the correct result.
Kind Regards, Deepak Dixit DIRECTOR OF PRODUCT ENGINEERING mobile: +91 9826754548 email: [email protected] *www.hotwax.co <http://www.hotwax.co/>* On Thu, Jan 31, 2019 at 7:16 PM <[email protected]> wrote: > We are trying to create this report which list sales order number, > commission rep, order sub total. We are having a tough time finding out > where to locate the order sub total table/field. Can someone point us > in the right direction? >
