Sales by Item Summary Report
The Sales by Item Summary report is a general overview of your sales in dollar amounts by item.
With Narrative Insights, you can use generative AI to summarize the report, helping you pinpoint best and worst performing items and categories, and see whether sales are spread among multiple categories or focused on a few.
The generated insights may include:
-
Highlights of item categories generating the highest and lowest sales
-
Top performing items by revenue, showing dollar amounts and units sold
-
Top performing categories by revenue, with analysis of whether sales are dominated by a few categories or more evenly spread
-
Worst performing items by revenue
-
Risks and exceptions relevant to sales performance
To generate an insight on the Sales by Item Summary report, the Enable Narrative Insights preference must be enabled in the Narrative Insights tab of the AI Preferences page. This preference is enabled by default. For more information, see Managing Narrative Insights Preferences.
For more information about Narrative Insights, see Narrative Insights Overview.
To see the Sales by Item Summary report:
Go to Reports > Sales > Sales by Item.
A popup message appears to let you know your report is loading. The status bar in the footer of the report indicates the progress as your report loads. You can click Cancel Report next to the status bar to stop the report from loading.
To generate an insight on the Sales by Item Summary report:
-
Filter the report to include only the information you want the insight to reflect.
-
Click the Generate Insight button.
The Narrative Insights dialog is displayed. You can generate the insight again at any time by clicking the Generate Insight button.
Insights may differ each time they're generated, even when you're viewing the same data.
To run this report on a cash basis, ask an administrator to set the Cash Basis Reporting preference. Accounting preferences are at Setup > Accounting > Accounting Preferences. The Cash Basis Reporting preference is on the General subtab in the General Ledger section. The Cash Basis Reporting preference applies to all standard reports that support cash basis reporting. When you check the box for this preference, the report runs on a cash basis instead of on an accrual basis. If you don't use this preference, you can create a custom cash basis report by enabling the Cash Basis option on the More Options page of the Financial Report Builder. See Setting Up Cash Basis Reporting.