The standard Balance Sheet shows "As Of" Period on its report. When Accounting Period is selected from the Column footer filter, the report will show all the prior periods from the Period selected. However, customer wants to show limited accounting periods only to prevent a timeout error. This will be helpful in minimizing the data shown and allowing the report to run and process faster.
NetSuite provides customization methods for financial statements, including Balance Sheet report. This can be achieved by doing the following:
1. Navigate to Transactions > Financial > Balance Sheet
2. On the Balance Sheet page, click Customize
3. On the Financial Report Builder page, go to Edit Columns tab
4. Under the Report Preview UI, toggle VIEW COLUMNS BY field then select Accounting Period
5. Highlight the Amount Column
6. On the Alternate Period Range Type dropdown field = select Relative to report date
7. On the Alternate Period Range dropdown field = select any Period Range you prefer
- Note: For testing purposes, we selected This Fiscal Year
8. On the Range Segment dropdown field = select Accounting Period
- Note: For testing purposes, we selected Accounting Period
9. Click Preview or Save
This is how it looks like. It's showing April 2022 to March 2023 since my accounting period for fiscal calendar is set up this way:
We can note that it's showing cumulative values and also able to limit the periods shown on the report.
-----
Do you have other tips that can help us? Let us know by sharing your thoughts with the community.