replicate the income statement using a saved search

AI generated answer (using internal Slack threads):

To replicate the income statement using a saved search in NetSuite, you can follow these steps: 1. Create a new Transaction Saved Search. 2. In the Criteria tab, you can set the following filters: - Type: Transaction - Posting: Yes - Account Type: Income, Expense, Other Income, Other Expense, COGS (Cost of Goods Sold) - Period: This Fiscal Year (or any other period you want to report on) - Subsidiary: Select the subsidiary you want to report on (if applicable) 3. In the Results tab, you can add the following fields: - Name: Period (Group) - Formula (Numeric):

CASE WHEN {accounttype}='Income' THEN {amount} ELSE 0 END - CASE WHEN {accounttype}='Cost of Goods Sold' THEN {amount} ELSE 0 END

(This formula calculates the Gross Profit) - Amount (Sum): This will give you the Net Income/Loss Please note that this approach might not work perfectly for all scenarios, especially if you're not using the out-of-the-box Income Statement or if there are foreign exchange impacts. In such cases, you might need to adjust the formulas or use additional fields like FX Amount. Also, keep in mind that replicating the subtotals like Gross Profit, Net Operating Income, etc., as rows in a saved search might not be possible. These would typically appear as columns in the saved search results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******