sales by sales rep report, how do i exclude certai...
# ask-stanley-ai
t
sales by sales rep report, how do i exclude certain line items from the invoice total?
c
AI generated answer (using internal Slack threads):
To exclude certain line items from the invoice total in a 'Sales by Sales Rep' report, you would need to create a custom saved search. Here's how you can do it: 1. Navigate to Reports > New Search. 2. Select Transaction as the record type. 3. In the Criteria subtab, set the following filters: - Type is Invoice - Main Line is False (to bring in line item details) - Shipping Line is False (to exclude shipping charges) - Tax Line is False (to exclude tax charges) - You can also add any other specific criteria to exclude certain line items. For example, if you want to exclude a specific item, you can add 'Item is not [item name]'. 4. In the Results subtab, add the fields you want to display in the report, such as Sales Rep, Item, Amount, etc. This will give you a report of sales by sales rep, excluding the line items you specified in the criteria. ****** 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.831228793
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.812172294
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.807635725
Please provide your feedback on this answer.