is there a way to pull a list of outstanding check...
# ask-stanley-ai
p
is there a way to pull a list of outstanding checks against a bank account as of a date in the past?
c
AI generated answer (using internal Slack threads):
To pull a list of outstanding checks against a bank account as of a date in the past, you can use a saved search in NetSuite. You would need to create a saved search for checks where the status is 'Outstanding' and the date is on or before the date you are interested in. Here are the steps to create this saved search: 1. Go to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction as the type of search. 3. In the Criteria subtab, add the following filters: - Type is Check - Status is Outstanding - Date is on or before [your date] 4. In the Results subtab, add the columns you want to display in your search results. For example, you might want to include the check number, date, amount, and payee. 5. Save and run the search. Please note that this will give you a list of all outstanding checks as of the date you specified, not just those against a specific bank account. If you want to limit the search to a specific bank account, you would need to add another filter in the Criteria subtab for Account is [your bank account]. ****** 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.811645508
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.805480957
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.804687619
Please provide your feedback on this answer.