10 Sales
← Technical Guide

Section 10

Sales

The six screens of the Sales module: net revenue, profit and margin summary, Sales explorer, quarterly trend, region × brand heat map, customer portfolio, and the analysis of declines from quarter to quarter.

Overview

The Sales module shows invoiced sales by region, brand, and customer. Your organization's sales_module license opens the module; without the license, the screen redirects you to the features page in Settings. With the license, a user whose role holds the sales.view permission sees the screens; for a user without the permission, the page returns not found. The screens of this module have no record entry or editing; all of them are read-only. Roles and license are described in Chapter 1.

The data consists of the «Invoice» records that arrive with PULS Connect. These records enter the sales ledger through the «PULS Connect › Imports › Sales import» import. «Product» records, through the «PULS Connect › Imports › Product catalog» import, do not add new rows to the sales rows; they fill in the empty material description and group of existing rows. Connect is described in Chapter 2.

Above all sales screens except the Explorer there is a shared filter bar: period selection, quarter (All, Q1, Q2), region, brand, and a customer search box. «Clear» resets all of them. The selections are written to the address bar. The preset periods are «This year», «Last quarter», «Last 6 months», «Last 12 months», «Last year», and «All time»; a custom range can also be selected. The preset periods are set relative to the last month in the data, not relative to today. If the selected period spans more than one year, the quarter selection is disabled.

Executive summary

The page title is «Sales analysis». There are six cards: Net Revenue (returns included), Profit, Margin (profit / net revenue; green at 30% and above, orange at 15% and above, red below that), Returns (orange when their ratio to net revenue exceeds 3%), Customer (distinct company), and Q2 − Q1 (the difference in net revenue between the two quarters). If profit is measurable only on some rows, the card states that the total is partial. If the period spans more than one year, Q2 − Q1 is not built.

  • The «Monthly net revenue» and «Monthly profit» charts. Months whose profit cannot be measured are not drawn as zero; the number of such months is written below the chart.
  • «Largest regions (net revenue)» and «Largest brands (net revenue)»: the top 6.
  • «Management findings»: revenue trend, profitability level, regional concentration risk and returns burden. If there is not enough data, the card says so.

If the organization has no sales rows at all, a warning banner appears at the top of the page stating that no sales data has been loaded.

Explorer

Lets you freely break down sales rows and turn them into charts. The shared filter bar is hidden on this screen; period selection is in the Explorer’s own top bar. The chart, filter, sorting, and export controls are common to all Explorer screens and are described in Chapter 7.

The Sales explorer also has a «Product breakdown» selection: Off, Product Type, Product Group, and Product (SKU). When you turn it on, all charts on the screen can also be broken down by the product dimension. If the product field cannot be measured in the rows, the dimension is not added to the list and the screen says so.

Trend & profitability

Shows the monthly revenue and margin trend and the quarter comparison. Four cards: Q1 net revenue (January–March), Q2 net revenue (April–June), Quarterly growth, and Average margin. Below them are the «Monthly net revenue» and «Monthly margin (%)» charts. In a month whose margin cannot be measured, the line is broken; if the margin of no month can be measured, the card says so. If the period spans more than one year, the quarter cards are not built and the month labels also show the year.

Region × Brand

Shows which region–brand intersection carries the revenue and which one drags the margin down. The «Coverage» strip gives the number of regions, the number of listed brands (top 20), and the number of brands on the map (top 12). In the «Brand × region heat map», rows are regions and columns are the top 12 brands; a dark cell means high revenue. The «How was this calculated?» expandable box under the heading explains the calculation.

TableColumnsCSV
Region summaryName, Net Revenue, Profit, Margin, Transactionsbolge-ozeti.csv
Brand summary (top 20)Name, Net Revenue, Profit, Margin, Transactionsmarka-ozeti.csv

Customer portfolio

Lists the largest customers. The strip contains Distinct customers, Top 20 share (how much of the revenue is concentrated in 20 customers), Total net revenue, and Listed; total net revenue is only the sum of the listed customers. The list is cut off on the server at the 150 largest customers. The columns of the «Largest customers» table are Customer, Net Revenue, Profit, Margin, and Transactions; clicking a header sorts only this list. If there are no customers, the table says so. «Download CSV» downloads the table as musteri-portfoyu.csv.

Decline analysis

Calculates the net revenue loss from Q1 to Q2 within the same year per customer × region × brand combination. In addition to invoices, the calculation also counts open orders: an order that has not been delivered and has not entered an invoice is added to the quarter in which the order date falls, and the decline verdict comes from the sum of the two. Open orders are read from CRM’s order records. The region, brand, and search filters apply to this screen; the quarter selection does not. If the period spans more than one year, the screen shows a warning asking you to select a single-year period.

The strip contains Decline pool · TOTAL (invoice + open order), Decline pool · INVOICE, Open order · Q1+Q2, and Recovered count. The «What this calculation covers» card states with counts what does not enter the calculation: open-order items outside the comparison window and those with an empty date, customer+brand pairs that match no decline row, pairs that appear in more than one region or that produce more than one row because their name is spelled differently in the source, and items in a currency other than TRY.

  • «Summary» tab: «Critical finding», «Reverse direction» for combinations whose decline grows with the open order, and a «Recovered» table for those that decline on invoices but do not decline together with the open order (first 100 rows). If there is no finding, the tab says so.
  • «Records» tab: the «Largest declines» table, first 160 rows. The columns are Customer, Region, Brand, Q1, Q2, Open order, Invoice decline, Total decline, and Status. Status can be recovered, worse, partially closed, region unclear, or spelling collision.
  • At most 5,000 decline rows are read from the server; if there are more, the coverage card states how many rows were left out. «Download CSV» downloads the rows as dusus-intelligence.csv.