OneWorld: Report to Show Amount Due of all Open Invoices in theTransaction Currency instead of Base Currency and excluding realized ForeignExchange Losses and Gains

To accomplish this in NetSuite perform the following steps:
 
1. Navigate to Reports > New Reports
2. Click Unpaid Receivable
3. Select the format of the report > Metric = Amount Due (Foreign Currency)
4. Select Detail
5. Select the subtotal of the report > Component = Customer > Field = Name (Grouped)
6. Click More Customization
6. On the Filters page, set the following:
    - Report Filter Date = before mm/dd/yyyy
    - Subsidiary = XXX Subsidiary
7. Add additional filters:
    - Open: Unpaid Receivables folder > Open: Transaction type folder > Add: Long Name
    -- Filter: Equal to Invoice
    - Open: Unpaid Receivables folder > Add: Amount Due (Foreign Currency)
    -- Filter: Not Equal to 0.00
8. Click Preview
9. Name and Save the report