By that I mean the total of all the items ordered, excluding taxes, shipping and other miscellaneous charges. I'm using the Sales Order Header Master table for a GridView report. I'm sure I could use the order detail table and exclude misc. charges, but that would take a lot longer. Would be nice if the header table had that information somewhere.
Along those same lines, I noticed that even for credit notes, the Total Order Amount or Total Dollar Amounts are positive - when they should actually be negative. How do I get around that?
Thanks,
Andre