Use Accounting Contexts in Account Saved Searches

If accounting contexts are defined in your system, you can use the following five columns in the Account saved search, and any saved search where the Account field (Account Fields list) is joined to the saved search:

It is important to note that these five columns contain values for all combinations of accounting context and language including combinations where the localized name and localized number are the same for different combinations of accounting contexts and languages. Therefore, if the Multi-Language feature is enabled, best practice is to always specify the combination of both accounting context and language in the search criteria to avoid duplicated results.

Example

You have the following accounting contexts and languages defined in your system:

A user with permission to modify the 1110 Advances Paid account record defines the following rules on the Localization subtab:

The following table displays several applicable combinations of searchable data based on these rules for this account:

Table of searchable data combinations.

Search Criteria 1

Your search criteria is Number set to 1110. The results you want to retrieve are Localized Number and Localized Name. This saved search returns several lines and some of them are duplicated because the Accounting Context and Language were not specified.

Search Criteria 2

Your search criteria is Accounting Context set to Czech Republic, Language set to null, and Localized Number set to 314. The results you want to retrieve are Localized Name and Localized Number.

This saved search returns only one line with Localized Name and Localized Number because the Accounting Context and Language is clearly specified.

Note:

Users can create saved searches that are not dependent on the values set in User Preferences. For example, if a user creates a saved search where the criterion Name is set to Advances Paid, the search results will return the Advances Paid account if the user’s preferences are Language set to English and Accounting Context set to null. If the user’s preferences are Language set to English and Accounting Context set to Czech Republic, this save search will not return anything because the account Name is Zalohy.

In contrast, if this user creates a saved search where the criteria Accounting Context is set to null, Language is set to null, Localized Name is set to Advances Paid, the search results will return the Advances Paid account even if the user’s preference is Accounting Context set to Czech Republic. This criteria is useful when a controller wants to create a saved search that works for all accountants in local subsidiaries no matter if they have any localization in their NetSuite account.

Related Topics

Set Company Preferences
Accounting Contexts

General Notices