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:
[hidden email]
*www.hotwax.co <
http://www.hotwax.co/>*
On Thu, Jan 31, 2019 at 7:16 PM <
[hidden email]> 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?
>
Locked
