How to Retrieve ‘Represents Subsidiary’ for Intercompany Journal Entry Names in NetSuite Saved Searches

To accurately retrieve the 'Represents Subsidiary' value, a formula utilizing CASE WHEN and NS_CONCAT functions can be implemented in a saved search. This approach accounts for how NetSuite displays entity names in the 'Name' column by comparing it against combined entity ID and company name fields.The following formula can be used:

CASEWHEN {name} = NS_CONCAT({customer.entityid},' ',{customer.companyname}) THEN {customer.representingsubsidiary}WHEN {name} = {vendorline.entityid} THEN {vendorline.representingsubsidiary}ELSE nullEND

This formula works by:

1. Comparing the {name} field (which contains both the entity ID and name) to a concatenated string of {customer.entityid} and {customer.companyname}. The NS_CONCAT function is used for robust string concatenation, gracefully handling potential NULL values.

2. If a match is found for a customer, it returns the {customer.representingsubsidiary}.

3. It then checks if the {name} field matches the {vendorline.entityid}.

4. If a match is found for a vendor, it returns the {vendorline.representingsubsidiary}.

5. If neither condition is met, it returns null.This solution is specifically tailored for Intercompany Journal Entries. For other transaction types, additional CASE WHEN conditions based on the transaction type would be necessary to apply different logic.