overview | features | menus | reports | access levels | invoices | supplier seasons | flt desk | ops desk | prices

Supplier Seasons

Seasonal supplier commission bands can be set using the accounts package option: Database: Supplier: Seasons.

Enter the supplier name and a list of season bands relevant to that supplier (or the option to enter a new one) will appear.

Press Insert, Delete, or Enter to add, delete, or edit seasonal commission bands.  

The season can be named purely for readability (for example: Winter advance sales) followed by the two criteria, the range of booking days and the range of flying days and lastly the flight, holiday,  and car hire commission rates applicable to that band.

For example, if supplier ABC is now giving an 18% commission on sales made between the 1st and 31st of July for bookings travelling between 1 November and 30 November, perhaps to stimulate low season winter sales, the Valid_from range would be 1st of July to 31st of July and the Fly_from range would be 1st November to 30th November.  The flt_comm and hol_comm would then be 18%.On exiting the screen editing a seasonal band, the software will ask you if you want the passengers applicable to that seasonal band to be counted.  This means you are in a position to report to your supplier on how many passengers were covered by this sales offer, confirming the success or otherwise of that particular seasonal commission band, and validating any retro-active commission they may give.

Important note:
By default, these commissions are used when new sales are made.  In some cases, it may not be desirable for the reservation staff to use these rates, and therefore they should use the standard rates for that supplier, as maintained in the Database: Supplier: Edit pages.

In this case, you must alter the default behaviour for that retailer, by using the Utilities: Setup: Retailer: TAB and changing USECOMSPLS on page 1 of the edit box to be No.

This means that instead of looking in the seasonal commissions file above, the system will use the standard commission rates for any given supplier when the booking is first made.

Changing an existing booking
Using Client: Display: Pg Dn: Supplier and highlighting the supplier concerned, press F2.  This will automatically change the commission stored against the booking to that stored in the relevant seasonal commission band.   It will report on the following exceptions:        

if the NEW commission is the same as the OLD one
if the NEW commission is LESS than the old one
if there is NO new commission available from the seasonal commission bands file.

The booking and related VAT is then recalculated, with the relevant changes added to the history file marked "Real  Comm: 15%" (or whatever percent applies in each case).See also: Software Features: Reports: Staff +-: Variations on this web site for information on including or excluding figures from the Staff +- report.

Reporting on commission differences
Use Accounts: Outgoing: +- and enter a date range (meaning the date range in which admin staff used the F2 key to change commissions from the lower ones to the higher, real ones) to generate a report.This report will scan the entire history file between those two dates (possibly a large number of entries) and EXTRACT the ones which represent a F2 action on the part of the admin staff, to raise a commission from the lower ones to the real, higher ones.The report will calculate the original commissions, and offer a choice of browsing the accumulated report, or printing/viewing on screen a report which is organised by:

Supplier (subtotalled by supplier)
Booking number (subtotalled by month of booking's sale date)
Date swapped (subtotalled by month of swap-over (F2) date)

Page No.     1
06/04/00                                   Commission swap report  

Bookno Sold on  Supplier   Orig.% Swapped  ..at  ..by     New % Extr.prof.  Tot.prof.

** Supplier: AVRO
  1277 17/02/94 AVRO         0.00 21/03/00 16:00 User     10.00     54.05      54.05
  1277 17/02/94 AVRO         0.00 21/03/00 16:00 User     10.00     54.05      54.05
 30021 22/03/00 AVRO         9.00 22/03/00 08:48 User     35.00    305.50     350.00
** Subtotal **                                           413.60    458.10
*** Total ***                                            413.60    458.10

The above report sample shows an increase in profit on three bookings.   It also shows the new profit total, the day of the swap, the staff name who pressed the F2 key to perform the swap, etc.