Skip to content
3 min read

Create an AR Invoice Saved Search with Multiple Currencies in NetSuite

Featured Image

Creating an AR (Accounts Receivable) invoice saved search in NetSuite with multiple currencies involved can be a bit tricky, but with the right approach and criteria applied, it can be done efficiently. In this article, we'll provide a step-by-step guide to creating a saved search in NetSuite for AR invoices with multiple currencies.

Step 1: Determine the search criteria

To begin, you need to define the search criteria that you want to include in the NetSuite invoice's saved search. This will include fields like the customer, invoice date, currency, and invoice amount. Additionally, you need to ensure that you have access to all of the necessary fields in the search results. 

Here is a list of fields to consider when creating a saved search in NetSuite:

  • Customer
  • Invoice Date
  • Currency
  • Exchange Rate
  • Amount (in functional currency)
  • Amount (in transaction currency)

Step 2: Create a new saved search

After determining the search criteria, you can create a new saved search. Navigate to Lists > Search > Saved Searches > New. From here, select the record type as "Transaction" and the search type as "Transaction".

Step 3: Define the search criteria

In the Criteria tab, define the NetSuite invoice search criteria based on the search criteria you have determined in Step 1. This could include criteria like "Currency is not equal to Functional Currency" or "Amount (Transaction Currency) is greater than 1000". Ensure that the criteria are accurate and inclusive of all the necessary fields.

Define the search criteria in NetSuite

Step 4: Define the search results

In the Results tab, select the fields that you would like to include in the NetSuite invoice search results. This could include the fields listed in Step 1, as well as any other fields that you may need for further analysis or reporting. You may also want to consider adding fields that allow you to filter and sort the search results more easily.

Define the search results in NetSuite

Step 5: Set currency and exchange rate fields

When dealing with multiple currencies, it's important to set the currency and exchange rate fields in the search. Navigate to the Available Filters section and select "Currency". This will add a currency field to the search criteria. Then, navigate to the Available Columns section and select "Exchange Rate". This will add the exchange rate field to the search results.

Step 6: Save the search

After setting up the search criteria and results, save the search by clicking "Save". You can then name the search and set the search permissions as necessary.

Step 7: Run the search

Finally, run the search to generate the results. You can then export the results to Excel or another program for further analysis or reporting.

Closing Thoughts

In conclusion, creating an AR invoice saved search in NetSuite with multiple currencies involved requires careful attention to detail and a solid understanding of NetSuite's functionality. By following the steps outlined above, you can create a search that accurately reflects your search criteria and allows you to analyze and report on AR invoices with multiple currencies.

If you want to be able to do even deeper analysis, check out what Payference has to offer for NetSuite users.