Scenario:
A Transaction Saved Search displaying the cumulative balance from the start to a specific period in NetSuite can provide valuable historical context that can be helpful in matching amounts in a balance sheet.
Solution:
1.) Navigate to Lists > Search > Saved Searches > New
2.) Select Transaction
3.) Under Criteria tab:
Select a Subsidiary (if you are using OneWorld)
Posting = True
Account = You can select a specific account or you can even use Account Type
4.) Under Results tab, you can add:
Account Name | Summary Type: Group
Formula (Numeric) | Summary Type: Sum | Formula: CASE WHEN {accountingperiod.startdate} BETWEEN TO_DATE('1/1/2016', 'MM/DD/YYYY') AND TO_DATE('3/1/2024', 'MM/DD/YYYY') THEN {amount} ELSE 0 END | Custom Label: As of March 2024
You can change these fields according to your account and reporting preference:
1/1/2016 - is the date the very first accounting period in your account.
3/1/2024 - is the start date of the reporting period or the target period
As of March 2024 - rename the reporting period
Users can also add multiple periods
4.) Rename the Search
5.) Save and Run
Compared to a Balance Sheet:
I hope this helps