Profitability Reports

note

This module generates the Profitability Dashboard, which shows how profitable your parts and customers are. It offers four reports grouped into two families:

Sales-based (what you actually earned from invoices in a period): Part-Wise Sales Profitability and Customer-Wise Sales Profitability.
Catalog-margin (the built-in margin on the current price list, regardless of sales): Part Profitability and Customer-Wise Parts Profitability.

1. Generate Profitability Reports

Step-by-Step User Guide

1.1 Access the Profitability Report Section

Open the main menu
Navigate to Management (or the Dashboard menu)
Click Reports
Select Info Graphics – Profitability Dashboard
Use the ribbon tabs to switch between the four reports

info

Access to these reports is controlled by the PROFITABILITY_DASHBOARD permission. If you cannot see the report, contact your administrator.

1.2 Understanding the Search Fields

note

All fields marked with (*) are mandatory.

Field	Description
Date Range	The reporting period, filtered by Invoice Date. Used only by the two Sales reports. The two catalog-margin reports ignore it.
Part	Choose one or more parts, or leave blank for ALL.
Customer	Choose one or more customers, or leave blank for ALL (used by the two Customer reports).
Unit	Magnitude unit for large numbers. Defaults to 1,00,000 (Lakhs) so charts stay readable.

tip

Sales reports answer "how much did we actually earn?" over a date range. Catalog-margin reports answer "how much margin is built into our price list right now?" and are not affected by the date range.

1.3 Field Validations

For Sales reports, only invoices whose date falls inside the Date Range are counted.
Part and Customer default to ALL when left blank.
Unit defaults to 1,00,000 (Lakhs) if not provided or invalid; all money values are divided by this figure.
If nothing matches the filters, the system displays No Data Available.

1.4 Generate the Report

Select the required filters
Choose a report from the navigation ribbon
Charts and summary cards update automatically
Hover on charts to view specific data points
Click Clear to reset filters

1.5 No Data Found Message

If no data matches the selected filters:

No Data Available

Recommended actions:

For Sales reports, verify the date range contains invoices for the selected part/customer.
For Catalog-margin reports, ensure the parts have an active Selling Price (Price Master) and, for the customer view, a Part ↔ Customer mapping.
Remember that tool line items are excluded from the Sales reports.

2. Common Rules

2.1 Currency Conversion to INR

All values are converted to INR using the Currency Exchange Rate master.
The rate applied is the one currently in effect (valid as of today's date). If no active rate exists for a currency, a rate of 1 is used.
Because the current rate is used, historical values are expressed at today's exchange rate.

2.2 Part Cost (Spending Value)

Each part's cost is taken from its Other Charges (partothercharges), summed per part.
In Sales reports this cost is treated as a cost per piece and multiplied by the invoiced quantity.
In Catalog-margin reports it is subtracted once, as the cost of a single piece against its selling price.

2.3 Selling Price Source

Sales reports use the actual price charged on the Purchase Order line behind each invoice.
Catalog-margin reports use the current Selling Price from the Price Master (partprice, category PROD), always taking the latest active price (non-expiring prices are preferred, otherwise the most recent effective date).

2.4 Tool Exclusion & Unit Scaling

Sales reports exclude line items whose part type is TOOL.
All financial figures (Sales, Cost, Profit) are divided by the selected Unit (default Lakhs) for readability.

3. Report Types & Formulas

Part-Wise Sales
Customer-Wise Sales
Part Profitability
Customer-Wise Parts

Family: Sales-based · Grouped by: Part · Uses Date Range: Yes

Purpose: Profit earned for each part from its invoiced sales in the selected period. Sorted from most to least profitable.

Invoice Qty = Sum of invoiced quantity.
Sales Value = Sum of (PO Line Price × Invoiced Qty × Exchange Rate), in INR.
Spend for Invoice = Invoice Qty × per-piece part cost.
Profit = Sales Value − (Invoice Qty × per-piece cost).

4. How to Interpret the Results

Observation	Meaning
High Sales profit on a part/customer	Actually earning well above cost in this period.
Low / negative Sales profit	Cost is close to or above the price charged; review pricing or costing.
High Sales Value but low profit	High turnover, thin margin — volume isn't converting to profit.
High Catalog Profit %	The price list has healthy built-in margin for that part/customer.
Low Catalog Profit %	List price is barely above cost — a pricing risk even before discounts.
Sales profit low but Catalog % high	The part should be profitable; check discounts, exchange rate, or actual PO prices.

5. Final Notes

info

If figures look unexpected, always verify:

Which family of report you are on — Sales reports change with the Date Range; Catalog-margin reports do not.
Whether a specific Part or Customer was selected, or the view is aggregated across ALL.
That parts have an up-to-date cost (Other Charges), an active Selling Price, and an active Currency Exchange Rate.

All Profitability Reports are currency-normalised to INR and unit-scaled for readability. The Sales reports are additionally tool-aware (tooling line items excluded) and based on actual invoiced sales.

For further assistance, please contact the DMeX Support Team.

1. Generate Profitability Reports​

Step-by-Step User Guide​

1.1 Access the Profitability Report Section​

1.2 Understanding the Search Fields​

1.3 Field Validations​

1.4 Generate the Report​

1.5 No Data Found Message​

2. Common Rules​

2.1 Currency Conversion to INR​

2.2 Part Cost (Spending Value)​

2.3 Selling Price Source​

2.4 Tool Exclusion & Unit Scaling​

3. Report Types & Formulas​

4. How to Interpret the Results​

5. Final Notes​