The reason of the total amount in the summary save...
# ask-stanley-ai
n
The reason of the total amount in the summary saved search is different than the detail saved search
c
AI generated answer (using internal Slack threads):
The discrepancy between the total amount in the summary saved search and the detail saved search could be due to several reasons: 1. Summary Type Setting: The 'Summary Type' setting in your saved search could be causing this discrepancy. When you set the 'Summary Type' to 'Sum', NetSuite sums up all the records that have the same characteristics. However, when you email the results as a CSV, the 'Summary Type' setting may not apply, and thus each individual record is listed separately, causing the total quantity to be a multiple of the original amount. 2. Inactive Items: The report might be throwing incorrect values due to inactive items. If an item is inactive, it might still be included in the summary but not in the detail view. 3. Unit of Measure: The unit of measure could also be causing this discrepancy. If the unit of measure is different in the summary and detail view, it could lead to different total amounts. 4. Recipient from Results: If the "Recipient from Results" field is filled out, it could be multiplying the quantity by the number of recipients associated with each item, causing a discrepancy between the summary and detail view. To resolve this issue, you could duplicate the same thing in a saved search and check if the discrepancy still exists. If it does, you might need to adjust your saved search to not use summary fields, but instead use a formula field to calculate the difference on each line. This should provide consistent results across different output methods (on-screen, CSV, email, etc.). ****** 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.844031572
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.83686465
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836831808
Please provide your feedback on this answer.