Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Balance Forward based on date range
Hi all,
I’m trying to add a Balance Forward column to the Sales by Customer report but don’t get the expected behavior when this is run based on date range (not period).
For example, when the date range is 12/01/2019 – 12/31/2019, the balance forward calculates from 1/1/1970 to 12/1/2019. I’d expect this to be from 1/1/1970 to 11/30/2019, but instead I get the transactions that are on 12/01/2019 on both columns.
Am I missing something here? Can anyone help?
Thanks.
Tagged:
0