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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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