Language:


Pipeline

This report can be used to predict future sales, based on the current stock of open Quotations, their Decision Dates and the probabilities that they will be converted to Orders. Open 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 open 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 Hansa'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.

Only Probability >
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.