Thursday, September 27, 2018

OneWorld:Report to show all Open Invoices Billed Amount using theTransaction Currency instead of the Subsidiary Base Currency

To accomplish this in NetSuite perform the following steps:

1. Navigate to Reports > Sales > Open Invoices Report > Customize
2. On the Edit Columns, add the following:
    - Open: Open Invoices folder > Add: Amount (Foreign) Currency
    - Open: Open Invoices folder > Open : Currency folder > Add: Currency Symbol
3. Name the report and click Save

Note: A filter to show the transactions which are in a currency that is different from the subsidiary currency can also be added to the report.  Below are the additional steps:

4. On the Filters:
    - Open: Open Invoices folder > Open : Currency folder > Add: Name
    - Set the Filter = not equal to Euro (or the currency of the chosen subsidiaryin the report)

No comments:

Post a Comment