Skip to Content
ERPX Documentation — Your complete guide to the ERPX platform
ModulesCRMReports

CRM Reports

Go to: CRM → Reports

Six reports cover the CRM module. They differ in what they are for, not just what they show:

ReportAnswers
Sales PipelineWhat is in the pipeline and how healthy is it?
Lead ReportsWhich leads exist, and who owns them?
Opportunity ReportsWhich deals exist, at what stage and value?
Lead LifecycleWhat has happened to this lead, end to end?
Transaction ChainWhat did this record turn into?
Sales FunnelWhere are we losing people between stages?

Reports appear only if your role has access to them. If one described here is missing from the tile list, ask your administrator — see Roles.


Sales Pipeline

Go to: CRM → Reports → Sales Pipeline

The management view of the pipeline: value, health, and movement.

Headline figures

MetricWhat it means
Total PipelineThe raw value of all active opportunities
Weighted PipelineThe same value adjusted by each deal’s probability
Total OpportunitiesHow many active deals make up that value
Win RateShare of closed deals that were won
Avg Deal SizeAverage opportunity value

Weighted pipeline is the number to forecast on. Total pipeline treats a 10%-probability deal the same as a signed one. If the two figures are far apart, your pipeline is thinner than it looks.

Views on the report

SectionWhat it shows
Opportunities by Sales StageThe value distribution across stages, as a donut
Pipeline by StageActive deals organised into stage columns
Pipeline Value by StageThe same distribution as a bar chart
Pipeline TrendHow the pipeline has moved over time
Top OpportunitiesThe highest-value deals, across every stage

The report can be exported to PDF.


Lead Reports

Go to: CRM → Reports → Lead Reports

A filterable, exportable list of leads with the fields your team asks for most.

Columns

Lead Name · Gender · Email · Mobile Number · Status · Next Follow-up Date · Territory · Lead Owner · Industry · Lead Type · Lead Source

Filters

FilterNarrows to
From Date / To DateLeads created in a period
Next Follow Up DateLeads due to be chased
StatusOne or more lead statuses
TerritoryOne or more territories
Lead OwnerOne or more sellers
Lead SourceOne or more sources
IndustryOne or more industries

Set the filters, click Generate Report, and export the result to CSV.


Opportunity Reports

Go to: CRM → Reports → Opportunity Reports

The same idea for deals.

Columns

Opportunity No. · Opportunity Name · Party Type · Amount · Expected Closing · Probability (%) · Sales Stage · Territory · Opportunity Owner · Status

Filter by status, sales stage, territory, owner, and date range, then export to CSV.

Sort by Expected Closing and scan the current month. Deals whose closing date has passed but whose status is still Open are the ones that need a conversation this week.


Lead Lifecycle

Go to: CRM → Reports → Lead Lifecycle

Where the other reports list records, this one traces one lead’s whole history — everything that happened to it, in one place.

For each lead it shows:

SectionContents
Lead summaryName, status, email, phone, territory, owner, source, industry, created date, expected value
OpportunitiesEvery deal generated from the lead
EmailsEmails exchanged
NotesNotes logged against the lead
CallsCalls logged
MeetingsMeetings logged
Sales QuotationsQuotations raised, with the customer they went to

Filter by status, territory, lead owner, lead source, industry, a specific lead, and date range. The CSV export preserves the section structure.

This is the report to open before a difficult customer conversation, or when auditing why a lead stalled. It reads as a story rather than a table.


Transaction Chain

Go to: CRM → Reports → Transaction Chain

The chain report follows the documents a record produced. Start from a lead, prospect, or opportunity, and it traces forward through the related CRM records and converted customers, ending at sales quotations.

Use it when you need to prove where a piece of business came from, or to find every document produced by a single lead.


Sales Funnel

Go to: CRM → Reports → Sales Funnel

A visual funnel showing how many records survive each stage of the journey:

StageCounts
Active LeadsLeads currently being worked
OpportunitiesDeals generated from them
QuotationsQuotations raised
ConvertedRecords that became customers

The funnel can be zoomed, fitted to screen, and downloaded as PNG or PDF — useful for board packs and review meetings.

Read the funnel by the biggest drop, not the smallest number. A steep fall from Leads to Opportunities is a qualification problem; a steep fall from Quotations to Converted is a pricing or closing problem. They need completely different fixes.


Choosing the right report

Everyday tips

  1. Compare Total and Weighted pipeline every week. The gap between them is your forecasting risk.
  2. Export lead and opportunity reports with the filters applied — an unfiltered export is rarely the question anyone asked.
  3. Use Lead Lifecycle for the one-record deep dive and Sales Funnel for the population view; they answer opposite questions.
  4. If pipeline velocity or sales cycle look implausible, check stage discipline on opportunities before trusting the number.