1. Navigate to Reports > Saved Searches > All Saved Searches > New.
2. Choose Transaction.
3. Under Criteria tab > Standard subtab, set Main Line = T.
4. Click the Results tab > Columns subtab, set the following:
– Document Number
– Formula (Currency)
Formula = {amount} – nvl({taxtotal},0) – nvl({shippingamount},0)
Label = Subtotal
– Amount (Tax Total)
– Amount
5. Click Save & Run.
NOTE
Please make sure that you are selecting the correct CONSOLIDATED EXCHANGE RATE under the result section.