Language:


Pipeline

This report can be used to predict future sales, based on currently outstanding Quotations, their Decision Dates and the probabilities that they will be converted to sales. Outstanding Quotations are those whose Status is Open, that are not Closed and from which no Order has been created.

The report is a list of outstanding Quotations sorted by Decision Date, showing for each the Quotation Number, the Customer Name, the Salesman, the Probability, the Decision Date, and the total value excluding VAT. Total values of Quotations in each calendar month in the Decision Date range are provided. Below this list, there is a summary section showing the number of open Quotations, the average, highest and lowest Quotation values, and the expected sales values. These are calculated by multiplying the Quotation value by the Probability.

When printed to screen, the Pipeline report has Enterprise's Drill-down feature. Click on the Quotation Number of any Quotation in the report to open that Quotation record.

Quotation Class
Paste Special    Quotation Classes setting, Quotations module
Enter a Quotation Class code to limit the report to Quotations of a single Class. If you enter a number of Classes separated by commas, the report will list Quotations belonging to all of those Classes.

Salesman
Paste Special    Person register, System module
To limit the report to Quotations generated by a single Salesman, enter their initials here.

Sales Group
Paste Special    Sales Groups setting, System module
To list Quotations with a particular Sales Group (shown on the 'Price List' card), enter that Sales Group here.

Only Probability Greater than
To restrict the report to Quotations whose Probability is greater than a certain figure, enter that figure here.

Decision on/before
Paste Special    Choose date
Quotations whose Decision Date is later than the date specified here will not be shown in the report.

Include Estimates
Use this option if you want to include Estimate column that is calculated as Quotation Total value excl. VAT multiplied by the Probability that a Quotation will be converted to an Order (taken from the 'Terms' card of the Quotation).

Sorting
Use these options to control sort order of the quotations in the report.
Number
This option produces a report with a section for each calendar month, including Quotations in each section sorted by Quotation Number.

Salesman
This option produces a report with a separate section for each Salesman and calendar month, including Quotations in each section sorted by Quotation Number.