Sales Reports and Analytics in Business Central
Sales reporting in Business Central allows sales and business professionals to get insights and statistics about current and past sales activities.
The following table describes some of the key reports in sales reporting.
|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.
|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 are sorted by sales amount or balance. The report gives a quick overview of the customers that purchase the most or that owe the most.
|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.
|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.
|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 that have total sales greater than the amount specified in the Amounts (LCY) Greater Than field on the Options FastTab.
|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.
|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.
|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.
|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 is also a capability with which you could set the amount of goods to be shipped. Note: This report is not available for advanced warehouse functionality.
|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.
|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 is not available for advanced warehouse functionality.
|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.
|Inventory Order Details
|Displays a list of the orders that have not 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.
The following articles describe some of the key tasks for analyzing the state of your business: