Report Wizard

Navigation: Reports → Wizard → New

Select groups on which statistics is going to be collected.

• Carrier*;
• City;
• Country;
• Customer;
• Product;
• Product Category;
• Region;
• Supplier;
• User;
• Brand.

*When calculating carrier for invoice line, RW takes related flight documents.
It was discussed if RW should take carrier from invoice/offer header in case it is empty for the line, and decided not to do that, cos that would lead to ANY line having carrier (even hotel line). So carrier exists only for a line related to flight travel document.

Add filter parameters separately or in combination of groups (by using 'and/or' operators).

Define report type: annual or generated by dates range.

Select types by

• Customer;
• Customer Mandatory;
• Order.

Layout and miscellaneous options (report header, output settings).

'Use Grid' mode supports data export to Excel;
outputs the following information for a 'Date Range' report type:

1. Selected categories code and name;
2. Product name;
3. Product code;
4. Product category code;
5. Product category name;
6. Exp price;
7. Invoice no;
8. Invoice date;
9. Invoice departure date;
10. Order no;
11. Customer code;
12. Customer name;
13. Dest. region code;
14. Dest. region name;
15. Dest. country code;
16. Farebasis;
17. Passenger type is collected from passengers or related flight tickets linked to each invoice line in the report. The field is blank when: passenger types are different in the Invoce line; there are no flight tickets linked. Other document type like vouchers and etc. are ignored.
18. PNR Creation Date. Required location - in the end of the grid. It is picked from non-OZ flight segment related to flights tickets linked to each line in the Invoice. In case there are several PNRs in the same invocie line, then the earliest creation date is taken. When there are no flight tickets, the field is blank.

Data from grid is taken for exporting according to below selection.

• As displayed;
• As displayed without totals;
• Complete data sheet.

Saving report template. Read more...

This is a prototype version!
All figures should be rechecked accurately, as it is quite a complicated job to calculate proper pricing based on a current segments logic.
To be improved by a request if needed.

All steps work common way as in 'Wizard for Invoiced Data', but figures are taken from segments and not from invoices.

The default segment arrival date period in Step 3 is 1 year.

In Step 4 the booking type and segment status are treated.