Have you ever wanted or needed a quick comparative view of your Intercompany transactions between your subsidiaries? One way to achieve this is through the use of CASE Statements in Saved Searches. What is a CASE Statement? A CASE Statement is similar to that of an if-then-else statement. You may have encountered this in spreadsheets. In NetSuite, it’s an available function that allows you to program conditions to return values when those conditions are met. So, when a condition is true, NetSuite will provide the results based on those conditions. You can have multiple conditions in one CASE Statement.
CASE STATEMENT use case – Intercompany Reconciliation
Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Saved Search, Reconciliation, CASE, Formula, If-Then