Sales reports and analytics in Business Central

Sales reporting gives sales and business professionals insights and statistics about current and past sales activities.

Reports

The following table describes some of the key reports in sales reporting.

Report Description Id
Customer - Order Summary Shows the order detail with the quantity not yet shipped for each customer in three periods of 30 days each, starting from the specified date. There are also columns with orders to be shipped before and after the three periods and a column with the total order detail for each customer. Use the report to analyze a company's expected sales volume. 107
Customer - Top 10 list Shows information on customers' purchases and balances for a selected period. You can choose the number of customers that will be included in the report. Only customers that have either purchases during the period or a balance at the end of the period will be included.
The customers are sorted in order of amount, and you can choose whether they're sorted by sales amount or balance. The report gives a quick overview of the customers that purchase the most or that owe the most.
111
Customer/Item Sales Shows a list of item sales for each customer during a selected time period. The report contains information on quantity, sales amount, profit, and possible discounts. It can be used, for example, to analyze a company's customer groups. 113
Inventory - Customer Sale An overview from the perspective of the warehouse sight. This is a different view compared to the Customer/Item sale report, and it shows the item first and then the customer who bought this product. 713
Customer - Sales list Shows customer sales for a period. You use it to report to the customs and tax authorities. You can choose to include only customers with total sales that exceed a minimum amount. You can also specify whether you want the report to show address details for each customer.
The report is based on recorded sales (LCY) from customer ledger entries. At the bottom of the report, the total reported sales are shown in LCY. The total is based on the customers you have included in the report, that is, the customers that are within the filters on the Customer FastTab and have total sales greater than the amount specified in the Amounts (LCY) Greater Than field on the Options FastTab.
119
Customer - Balance to date Shows a detailed balance for selected customers. Use the report at the close of an accounting period or fiscal year, for example. 121
Customer - Trial Balance Shows a detail balance for selected customers. You can use the report to verify that the balance for a customer posting group is equal to the balance on the corresponding G/L account on a certain date. Use the report at the close of an accounting period or fiscal year, for example. If you need a more detailed version of this type of report, use the Customer Detail Trial Balance (104) report. 129
Sales Statistics Shows amounts for sales, profit, invoice discount, and payment discount in LCY, and the profit percentage for each customer. The costs and profits are given as both the original and adjusted amounts. The original costs and profits are those values that were calculated at the time of posting, and the adjusted costs and profits reflect changes to the original costs of the items in the sales. The cost adjustment amount shown in the report is the difference between the original cost and the adjusted cost.
The figures are divided into three periods. You can select the length of the period, starting on a selected date. There are also columns for amounts before and after the three periods. Use the report to analyze earnings from an individual customer and earnings trends, for example.
In the US, Canada, and Mexico, this report is not available. Instead, use the Customer Sales Statistics (10047) report.
112
Sales Reservation Avail. Shows the availability of items for shipment on sales documents. You determine whether the report indicates the status of each document or of each sales line. When you print the report, you can also update the quantity that is available for shipment in the Qty. to Ship field on the sales lines. Then you can use the report to determine which documents to post.
There's also a capability with which you could set the amount of goods to be shipped. Note: This report isn't available for advanced warehouse functionality.
209
Warehouse Shipment Status This report can be used for all locations where the Require Shipment field is selected. The Warehouse Shipment Status report shows you all unposted warehouse shipment documents, including the locations, bin codes, document status, quantities, and so on. This report is perfect to get an overview. 7313
Inventory Picking List Displays a list of the sales orders in which an item is included. The following information is shown for each item: Sales order line with the name of the customer, variant code, location code, bin code, shipment date, quantity to be shipped, and unit of measure. The quantity to be shipped is totaled for each item. The report can be used when items will be collected from the inventory.
Note: This report isn't available for advanced warehouse functionality.
813
Inventory Sales Back Orders Shows a list with the order lines whose shipment date has been exceeded. The following information is shown for the individual orders for each item: number, customer name, customer's telephone number, shipment date, order quantity and quantity on back order. The report also shows whether there are other items for the customer on back order. 718
Inventory Order Details Displays a list of the orders that haven't yet been shipped and the items in the orders. It shows the order number, customer's name, shipment date, order quantity, delayed quantity, outstanding quantity, and unit price, as well as any potential discount percentage and amount. The quantity on back order and outstanding quantity and amount are totaled for each item. Use the report to find out whether there are currently shipment problems or any can be expected. 708

Tasks

The following articles describe some of the key tasks for analyzing the state of your sales:

Explore sales reports with Report Explorer

To get an overview of the reports that are available for sales, choose All Reports on your Home page. This action opens the Role Explorer, which is filtered to the features in the Report & Analysis option. Under the Sales and Marketing heading, choose Explore.

Example of reports on the finance role center.

To learn more, go to Finding Reports with the Role Explorer.

See also

Ad-hoc analysis of sales data
Sales analytics overview
Setting Up Sales
Sales overview
Reserve Items

Find free e-learning modules for Business Central here