You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by ja...@productive1.com on 2019/01/31 13:46:06 UTC

Sales Order Report with Order Sub Total

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?

Re: Sales Order Report with Order Sub Total

Posted by Deepak Dixit <de...@hotwax.co>.

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: deepak.dixit@hotwax.co
*www.hotwax.co <http://www.hotwax.co/>*

On Thu, Jan 31, 2019 at 7:16 PM <ja...@productive1.com> 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?
>