Tahir Ansari
09/18/2024, 6:07 PMCeligo AI
09/18/2024, 6:07 PMAI generated answer (using internal Slack threads):Based on the conversations, it seems that creating a cash/bank treasury report that includes opening of bank account, inflow, outflow, and then ending during a data range is possible in NetSuite, but it may require some customization or use of third-party tools. In the first thread, a user is trying to retrieve a balance sheet report with only opening balances and without transactions from the same date. The suggestion was to use the closing amounts from the previous day. However, if the previous day's data is not available due to a system migration, it was suggested to check answerid 38890 for instructions on how to modify the balance sheet report. In the second thread, a user is having trouble with the cash flow report. The suggestion was that canned cash flows in NetSuite are known to not work properly and creating a custom cash flow report from scratch might be necessary. In the third thread, a user is looking for a 13-week rolling Cash Flow Projection report. One suggestion was to use a third-party Excel add-in called Vena to bring the data from NetSuite to Excel for creating forecasts. Another suggestion was to use the Cashflow statement report in NetSuite. Please note that these are suggestions based on the conversations and the actual implementation may vary based on your specific requirements and NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
09/18/2024, 6:07 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830805838
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821449339
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.817808032
Celigo AI
09/18/2024, 6:07 PM