you can directly generate it by using account categories from chart of account…please have a look on gross profit margin KPI in general ledger cube
Kunal
In SO regardless not only 1 item some of the SO is more than 7 to 10 items, the user wanted to see the whole total of the SO. That must be seen in SO confirmation and view the totals.