How to develop a view to show me the cash position...
# ask-stanley-ai
m
How to develop a view to show me the cash position of all Bank accounts in NetSuite, in their currency (aside from the reporting currency) so that we can easily tie them back to the bank statements.
c
AI generated answer (using internal Slack threads):
To develop a view to show the cash position of all Bank accounts in NetSuite, in their currency (aside from the reporting currency), you can create a custom search or report. Here are the steps: 1. Navigate to Reports > New Search. 2. Select the record type as 'Account'. 3. In the criteria tab, add 'Type' as 'Bank'. 4. In the results tab, add the fields 'Name' (for the account name), 'Currency', and 'Balance'. 5. Save and run the search. This will give you a list of all bank accounts along with their balances in their respective currencies. If you want to tie them back to the bank statements, you might need to create a custom field on the bank account record to store the bank statement balance and update it regularly. Then, you can add this field to your search to compare the NetSuite balance with the bank statement balance. ****** 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.856333554
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847556889
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.841482282
Please provide your feedback on this answer.