can I run a usage report for locations from 1/1/20...
# ask-stanley-ai
q
can I run a usage report for locations from 1/1/2024 to present? i want to see what locations have not been used, and I plan to inactivcate them
c
AI generated answer (using internal Slack threads):
In NetSuite, there isn't a direct way to run a usage report for locations from a specific date to present. However, you can use a workaround to achieve a similar result. You can create a saved search to identify the transactions that have used the locations. Here's a basic example of how you can do this: 1. Go to
Reports > Saved Searches > All Saved Searches > New
. 2. Select
Transaction
as the record type. 3. In the
Criteria
tab, add the following filters: -
Date
is after
1/1/2024
-
Location
is not empty 4. In the
Results
tab, add the following fields: -
Location
-
Date
5. Save and run the search. This will give you a list of locations that have been used in transactions since 1/1/2024. To find out which locations have not been used, you can compare this list with the list of all active locations. You can get the list of all active locations by creating another saved search with
Location
as the record type and
Inactive
is
F
as the filter. Please note that this method only considers the transactions. If a location is used in other records (like items, employees, etc.), it won't be considered in this method. ****** 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.817199707
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.790283203
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.789184451
Please provide your feedback on this answer.