Am I able to daisy chain the balance forward filte...
# ask-stanley-ai
m
Am I able to daisy chain the balance forward filter in NetSuite reports?
c
AI generated answer (using internal Slack threads):
Based on the conversations provided, it seems that the ability to daisy chain the balance forward filter in NetSuite reports is not directly addressed. However, there are discussions about creating running totals, forecasting bank balances based on due dates, and producing a trial balance with saved searches. In the first thread, the user is trying to forecast bank balance based on due dates for Accounts Payable and Receivable. The responses suggest that it might be possible but challenging, and a link to a blog post about solving the NetSuite cumulative saved search tally challenge is shared. In the second thread, the user is trying to run a balance sheet by accounting period for only a few periods. The response suggests running a comparative balance sheet, but it defaults to the prior end of year as the "opening" position and it's unclear if this can be changed. In the third thread, the user is trying to produce a trial balance with saved searches but with months instead of years. The responses suggest modifying the EXTRACT YEAR formula to something comparing Month/Year of sysdate to month/year of the accounting period end date. However, it's noted that filters can't be added to dynamically set date ranges. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.817915142
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.813194394
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.805448771
Please provide your feedback on this answer.