How to Track Eliminated Intercompany Transactions in NetSuite Saved Searches

To create a saved search that exposes eliminated intercompany transactions, configure the search with the following parameters. Note that directly filtering by 'System Notes : Field is Eliminate' for intercompany transactions in a saved search is not directly available in current NetSuite versions. Instead, a more general approach to capture changes to relevant fields within System Notes is recommended, followed by a formula to interpret the 'newvalue'.

Criteria:

• Add a criterion to filter System Notes for changes to fields related to intercompany elimination. While a direct 'Eliminate' field may not be available, look for fields that indicate the elimination process or status change. For example, you might look for 'System Notes : Field' that indicates a change in a custom field used for elimination, or a related system field if one is exposed.

Results:

• Field Name: Field Name | Summary Type Group
• Field Formula (Test): Summary Type Maximum | Formula case when {systemnotes.newvalue} = 'T' then 'Yes' else 'No' end | When order by field System Notes : Date

This setup allows for the identification of transactions where the relevant elimination field's value changed to 'T' (True), indicating an elimination action.