Yes, I know. I was setting up a view using the O/E Sales Order Header table and one of the fields was "Total Order Value". The problem I ran into was that this field only tallies items that have an order quantity. I can have returned items on an order: 0 Ordered; -1 Shipped. I had to set up another view from the O/E Sales Order Detail table and summarize each invoice. I thought I could link from the header table to the detail table but it's not available. I then tried from the detail table to the header table - success! But that now means I now have to insert six fields from the header into the detail instead of one field from the detail into the header, plus adjust formatting.

I realize that this has to do with database structures - it's just a pain. I just thought that since the Total Order Value field was calculated and available, then the value showing in the Subtotal Amount box might be available too.

Thanks

Thanks