Sales Summary - Management Reports Monthly Sales Tab
Table Of Contents
The Monthly Sales tab in Sales Summary | Management Reports gives you a year-long view of stock performance based on your selected filters. You can use it to review sales, credits and lost demand for individual stock items across the whole year or month by month. Khaos Control provides Sales Summary as part of its business reporting functionality.
For a practical example, see Using Sales Summary to Report on Poor Selling Items.
Important
- The Monthly Sales tab uses Sales Order information, not invoices.
- After changing your filters, use the Refresh button to update the grid.
Filters
Use the filters at the top of the tab to control which stock items and sales information appear in the grid.
- Start from Order Date: Select the date from which you want to analyse orders.
- Show Value (not Qty): By default, the Sales, Credits and Lost Demand columns show quantities. Select this option to show the gross value instead, using the selling price including VAT.
- Hide Discontinued: Hides stock items marked as Discontinued on the
[ Stock | Detail | Options ]screen. - Publish to Web(traffic light filter): Filters according to whether the stock item is marked as Publish to Web on
[ Stock | Detail | Options ]. - Publish to Catalogue(traffic light filter): Filters according to whether the stock item is marked as Publish to Catalogue on
[ Stock | Detail | Options ]. - Stock Type(traffic light filter): Filters the results by Level 2 stock type.
- Supplier URN(traffic light filter): Filters by supplier. Use the supplier lookup to find the required supplier.
After setting your filters, use Refresh to update the grid.
Understanding the Results
Keep the following points in mind when reviewing the information:
- Stock items shown with a red background have been marked as Run to Zero on
[ Stock | Detail | Options ]. - Order and Available levels relate to the current site.
- Sales, Credit and Lost Demand figures are taken across all sites.
- The supplier shown for an item is not guaranteed to be the supplier from which that particular stock was originally purchased.
- The Value figure is calculated as Sell Price × Qty.
Selling packs: The Value calculation can count child items twice when selling packs. A child item can be included once as part of the pack and again in its own right. In these situations, green-selecting the non-pack lines can make the resulting information more relevant.
Grid Columns
The grid contains the following information:
Stock Details
- Stock Code and Description: The stock item's code and description.
- Type: The Level 2 stock type.
- Supplier URN: The preferred supplier's URN from
[ Stock | Detail | Suppliers ]. - Supp Code: The preferred supplier's stock code for the item, as recorded on
[ Stock | Detail | Suppliers ]. - Supp Price: The preferred supplier information recorded on
[ Stock | Detail | Suppliers ]. - Supp Currency: The supplier's currency from
[ Supplier | Detail | Financial ]. - Sk Buy Price: The stock item's buy price from
[ Stock | Details | Properties ]. - Sk Value: The stock value from
[ Stock | Details | Properties ]. - Sk Sell Price: The stock item's selling price from
[ Stock | Details | Properties ]. - Order Lv: The number of items currently on purchase order.
- Available Lv: The total number available to sell.
- RTZ: Identifies stock items marked as Run to Zero on
[ Stock | Detail | Options ].
Whole Year
The Whole Year columns provide totals for the year beginning with your selected Start from Order Date:
- Sales: The number of stock items on sales orders.
- Credits: The number of credited items, normally resulting from returned items.
- Lost Demand: The number of stock items recorded as lost demand on sales orders.
Month 1 to Month 12
These columns provide the same information broken down by month:
- Sales: Stock items on sales orders for each month.
- Credits: Credited items for each month, normally resulting from returns.
- Lost Demand: Stock items recorded as lost demand for each month.
If Show Value (not Qty) is selected, the Sales, Credits and Lost Demand columns display value rather than quantity.
Adding Safe and Minimum Levels
You can add the following hidden columns using Grid Configuration:
- Safe Level: The item's safe level from
[ Stock | Details | Properties ]. - Minimum Level: The item's minimum level from
[ Stock | Details | Properties ].
Note: These columns show the item's default safe and minimum levels. They do not show site-specific safe and minimum levels where these have been configured.
You must have permission to configure grids in
[ System Data | Users | User Permissions ]. Grid Configuration can be accessed from the grid menu using Configure Grid, and allows authorised users to hide and reposition columns, among other configuration options. Viewing Grid Totals
If a Total cell at the bottom of the grid has a red background, its contents are too wide to display within the current column width.
To see the complete value, either: