Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Now, you can stay up-to-date with the latest discussions, helpful tips, and important announcements, all delivered straight to your inbox. Whether you’re looking to catch up on what you missed or just want a quick overview, our email digest has you covered. To learn more and to subscribe, click here.
NSC | Customize Balance Sheet: Display Relative Last Month's Balance selected on the Report Date
Scenario
User wants to see the last month's balance for the month in which the report is displayed.
For example, if the report is displayed in May, the balance at the end of April is displayed. If February is selected on the report, user wants to see the ending balance for January and so on.
Solution
For this scenario, user can customize the Comparative Balance Sheet Report:
- Highlight the Comparison Amount column
- Alternate Period Range Type = Relative to report date
- Alternate Period Range = Last Period
This is how it looks like when previewed:
-----
If you find this information useful, let us know by reacting or commenting on this post!
Clarisa De Torres | Ask a Guru
- Earn Community badges now! Refer a Member | Answer Accepter |
Did you know your engagement in our programs can lead to awesome surprises? That's right!
By participating and showcasing your skills, you'll get a chance to win exclusive rewards. Are you ready to unlock your potential and claim these amazing perks?
Learn more and join in the fun: