Sales Analysis

The Sales Analysis model is a sales-oriented model designed to give insights into a company’s revenue stream. Several KPIs are available such as sales volumes, sales margin and profitability, credits, number of orders, and order lines. The model provides analysis from different perspectives to give you a deeper understanding of factors driving the business.

You can analyze the information in the Sales Analysis model from different perspectives.

Customer perspective:

  • Sales and sales growth per customer and per customer group
  • Comparison of performance among customer groups
  • Discounts, costs, and credits explaining the profitability
  • Shipped volumes expressed as gross or net weight, units, and other information

Product perspective:

  • Products with exceptional performance and growth
  • Products selling below expected levels for profitability
  • Best-selling products and product performance from a profitability perspective
  • Products that have decreased most in sales and products that should be phased out
  • Products with exceptional levels of discounts and credits that erode the margins

Sales organization perspective:

  • Top sales performers
  • Top sales organization for controlling discount
  • Sales people who improved the most, as compared to last year
  • Sales people who markedly reduced the profitability by manually reducing prices or generating credit notes

You can perform analyses on several dimensions such as on the customer, product, sales organization, and supply chain (warehouse) dimensions.

Invoice Date is used to analyze the facts in this model. See Infor M3 Analytics for M3 CloudSuites Administration Guide for a list of available dates for this model.

Source information

The Sales Analysis model is driven by invoice sales statistics captured in the OSBSTD table. To populate this table with transactions, you must set the order type sales statistics.

The model provides analysis for these order types:

  • Customer Orders (ORIG = 0)
  • Service Orders (ORIG = 1)
  • Project Orders (ORIG = 2)
  • Maintenance Customer Orders (ORIG = 7)
  • POS Transactions (ORIG = 8)