Fixed_Prices

What are Fixed Prices/Distances?
Fixed prices are set prices for jobs that go from one place/plot to another place/plot that are usually done on a fairly frequent basis.  For example, your company may have a set price for jobs between two local towns, or a set price from the local railway station to the superstore.  Most private hire companies will have fixed prices for airport runs and other regular jobs.


Fixed prices versus fixed distances
You have the choice of creating either fixed prices or fixed distances.  Generally fixed distances are preferred over fixed prices because a distance between two places/plots rarely changes whilst prices may go up every year.  Every time your tariffs go up you’ll have to change all the fixed prices too.


If you fix a mileage rather than a price you will also reduce the number of fixed prices you need to create.  For example, assume you have four tariffs; 1 for cash customers, 1 for cheap accounts, 1 for normal accounts and 1 for expensive accounts.  Also assume you have four vehicle types; cars, estates, 7 seaters and VIP.


If you use fixed prices between point X and point Y you would need to set-up 16 different fixed prices (4 tariffs x 4 vehicle types).  Whereas if you set a fixed distance between point X and point Y you would only need to set-up one fixed mileage e.g. X to Y = 10 miles.  Navigator will multiply the fixed mileage by the rate per mile for each vehicle on each tariff.
What’s the difference between Place to Place, Plot to Place or Plot to Plot?


Fixed prices may be set for jobs that go from one place to another (place to place), e.g. Sainsburys to the bus station, or they may be set for jobs that go to or from a plot to a place (plot to place), e.g. from Aldershot to Gatwick Airport, or they may even be set for jobs that go from one plot to another plot (plot to plot), e.g. Wimbledon to Chiswick.
Can I have different fixed prices for Cash jobs and Account jobs?


You can create one set of fixed prices for Cash jobs and another set for your Account jobs. 

 
Can I have different fixed prices for individual account customers?
Yes you can.  You may have a standard set of fixed prices for all your account customers except one or two – maybe you’ve agreed a special discounted rate, or a special rate for a regular job you do for an account customer, for example driving employees between two offices.  


Navigator allows you to create fixed prices for All Accounts and individual accounts.  When an account booking is taken for a fixed price journey, Navigator will first check the fixed prices (if any) for that account, if it finds one it’ll use that price, if not it will then check the fixed prices for All Accounts.


Can I have different fixed prices for different vehicle types?
Fixed prices can be created for different vehicle types, for example, your Car fixed prices may be different to your Estate fixed prices which may be different again for MPVs.
How to create fixed prices


Fixed price summary
So to summarise, you can create the following types of fixed prices:

  • Place to Place – fixed price for a journey from one place to another, e.g. Gatwick Airport to Heathrow Airport
  • Place to Plot – fixed price for a journey to or from a place to a plot, e.g. anywhere within your BASE plot to Gatwick Airport
  • Plot to Plot – fixed price for a journey from one plot to another, e.g. anywhere within Wimbledon to anywhere in Chiswisk
  • Place to All Plots – fixed price for a journey from or to a particular place to any plot, e.g. Luton Airport to anywhere within your local street database (all your plots)

Within each of the above categories you can create fixed prices for:  

 

  • Cash work
  • All Accounts
  • Individual Accounts  

Within each of those categories you can create fixed prices for any of your different vehicle types:

  • Cars
  • Estate
  • MPV
  • Mini-bus
  • VIP etc.

How do fixed price jobs appear on the Booking Screen?
When a booking is taken for a fixed price job, a fixed price icon will appear on the booking screen next to the From field and the price box will change to a mustard colour:



Adding a place to your local street database
Fixed prices can only be created to places within your local street database.  So any places that are outside your local street database i.e. airports, must be added to the local street database before you can create a fixed price to it.


Let’s take the airports as an example…you’ll need to add these to your local street database before creating fixed prices to them.   
Some considerations before you start:


You may decide to add Gatwick Airport North Terminal and Gatwick Airport South Terminal, Heathrow Airport T1, Heathrow Airport T2 etc.
You may decide to prefix the airports with “AP” so when you’re creating a booking to or from an airport, you just have to type “AP” to bring up a list of all airports.  In additional to this, some customers have pre-fixed all rail stations with “ST” and pubs with “PH”.


1. Click on the Booking Screen to create a new booking


2. Type Gatwick Airport North Terminal in the From field


3. Press F2 to bring up the Add new place/street dialogue box


4. You have two choices when it comes to entering the new street/place in Navigator.  You can either enter the new street/place with detailed information i.e. Eastings, Northings, postal code, lead times and return to base times, or you can enter it with limited information and use a street/place that is already in the street database as a nearby point of reference.   


If you opt to use the latter method, the new place will adopt the same Eastings, Northings and post codes as the nearby place/street.  You may then edit this new street at a later date with the precise co-ordinates and postcode.  
So in this example we’ll use the Gatwick Airport North place that is already in the National street database as the frame of reference

5. Gatwick Airport North is in the National database, so toggle the National database on by either pressing the F8 key on your keyboard or by clicking on the National button


6. Next click into the Name of street/place near field and start typing Gatwick
Gatwick North and Gatwick South from the National database will appear in the drop-down list



7. Next you need to assign this place to a plot.  Most places will be added to the Out Of Town (OOT) plot, but there may be some places you’re adding that can be assigned to a plot within your local street database.   


For example, if Gatwick Airport is physically located within the bounds of your local street database, add it to the actual plot it resides in.


8. In the Plot name field type “O” to jump to the OOT (Out Of Town) plot – or scroll down to select the plot within your local street database


9. Click on OOT to select


10. Click OK when finished


Continue adding all the other places that you want to create fixed prices for that aren’t already in the local street database.


Approving Places
Next you need to “approve” all the places you’ve just added to the local street database.  You can take this opportunity to add more accurate information such as Eastings and Northings, postal codes, lead times and return to base times.

1. Click on the Plots menu and choose Unapproved Places


2. The Changed Place Approval box will appear showing the list of added places.  The added places will be pre-fixed with “N” for “new”.


3. Click on the first new place


4. Use this opportunity to add more detailed information such as lead times and return to base times


5. Click on the additional tab at the top of the form to display more information about this place


5. When finished click on the Approve button


5. If this was the only unapproved place, the dialogue box will disappear, if there are more places to approve the dialogue box will automatically update to show the next place. 

Continue approving all added places.  
Please refer to the Owner/Manager Guide for more information on Approving Places.


Creating the Fixed Prices
There are three ways of creating the Fixed Prices.  You can either do it entirely within the Navigator Fixed Price form, or you can do each one individually as jobs to these places are priced, or you can create all the fixed prices using Microsoft Excel and then import them into Navigator.

Click on the Approve button

Click on the other tab at the top of the form to view additional information

If you want to, enter a post code and accurate Eastings and Northings


How to create fixed prices

In my experience I have found that the following questions need to be asked to ascertain the best way forward:
How many fixed prices are there?   


If there are less than 200 it’s probably easiest just to do them within the Navigator Fixed Price form.  If there are lots of fixed prices it’s easiest to create them using Excel.
How familiar are you with Excel?


If you’re not that familiar with Excel, stick to using the Navigator interface.  If you have got thousands of fixed prices then it might be worth your while employing someone to help you out.  Alternatively, we can do it for you!


Is this a one off fixed price?   
If you’ve already created all your fixed prices and from time to time you just get the odd one to add for account customers, the easiest way to create it is using the Pricing form when you manually price a job for the first time.


So, to summarise the three methods:

  • Create fixed prices using the Navigator Fixed Price form
  • Create the fixed prices using Microsoft Excel
  • Create the fixed price for account customers at the point of manually pricing the job for the first time

Let’s take a look at all three methods…
Create fixed prices using the Navigator Fixed Price form
OK, so you’ve decided to use the Navigator Fixed Price form to create your fixed prices and you’ve decided which category they fall into, i.e. either Place to Place, Place to Plot, Plot to Plot or Place to All Plots.  You’ve also determined whether these are fixed prices for cash jobs or account jobs and whether you have different fixed prices for different vehicle types.   


For this exercise, we’re going to stick with creating fixed prices to airports from the BASE plot for Cash jobs in MPV’s.  Please note, this exercise presumes that your base is in a plot called BASE, if your system differs please substitute BASE with your own base plot.


1. Click on the Pricing menu and choose Edit Fixed Prices


2. Click on the plus sign next to the Fixed Prices folder to expand the branch


3. Right–mouse click on Place to Plot and click on the New account folder option


4. A box will appear asking you to select the account for these fixed prices.  In this example we’re creating fixed prices for Cash jobs so choose Cash and click OK


5. Click on the plus sign next to Place to plot to expand the branch

6. Right-mouse click on Cash and click on the New vehicle type folder option


7. A box will appear asking you to select a vehicle type, if your fixed prices are for all vehicles choose All vehicles, or if they are just for one type of vehicle choose that vehicle type and then click OK


8. Click on the plus sign next to Cash to expand the branch and then click on MPV (or the relevant vehicle type folder that you’ve just created)



9. Click on the button with the green plus sign to create your first fixed price and the Add fixed price dialogue box will appear.  Let’s take a quick look before we go any further…


10. Let’s set-up the fixed price to Gatwick Airport North Terminal:


11. In the From place field, start typing Gatwick and a list will appear showing all that places in your local street database starting with Gatwick and Gatwick Airport North Terminal will be one of the options (remember that you can only create fixed prices to places within you local street database so if the place you want isn’t appearing in the list, you need to add it as a new place before you can continue – please see Adding a place to your local street database)


12. Use your mouse to select Gatwick Airport North Terminal from the list and then press the TAB key on your keyboard to move to the To plot field


13. In the To plot field, click on the drop-down arrow and scroll down the list to the plot the fixed price is going to and click on it to select.  In this example we’ll scroll down to BASE and click to select (alternatively, type “B” to jump to the plots beginning with “B” and then use the down arrow key on your keyboard to scroll down through the list).  



14. Press the TAB key on your keyboard to move to the Account Units field (or just click into the field using your mouse)


15. Change both the Account Units and Driver Units field to Price rather than Distance – this is because we are fixing the price not the distance


16. TAB into the Account value field and enter the fixed price that will be charged to the Cash customer, i.e. £60.00


17. TAB into the Driver value field and enter the amount paid to the driver for the job.  Please see the tip box below for more information about Driver Value...



18. Click OK


19. You’ll be returned to the main fixed price window and you’ll see the first fixed price listed



20. Continue to add all your fixed prices starting each one by clicking on the button with the green plus sign


Amending a fixed price
Fixed prices can be changed at any time:


1. Locate the fixed price in the list and single click on it to select


2. Click on the Fixed Price Properties button on the toolbar


3. The fixed price dialogue box will appear, make any necessary changes and click OK


Deleting a fixed price
Fixed prices can be deleted at any time:
1. Locate the fixed price in the list and single click on it to select


2. Click on the Delete button on the toolbar



Creating your fixed prices using MS Excel
If you’ve loads of fixed prices to create and you’re familiar with Microsoft Excel, it’s often easier to use Excel to do this often tedious job!  There is a relatively simple process to follow:

  • First of all create a few fixed prices in Navigator to create a template to follow in Excel.  
  • Export the fixed prices out of Navigator in a CSV format (comma separated values)
  • Open the CSV file in Excel, and add all the other fixed prices being careful to follow the exact pattern created by the exported fixed prices
  • Save the Excel file retaining the CSV format
  • Import the fixed prices back into Navigator – at this point Navigator will inform you of any errors in the Excel file, which are usually silly inconsistencies such as spelling mistakes or non-existent places or plots and just takes a bit of detective work to figure out where you’ve gone wrong!
  • Correct any errors (if any)
  • Try the import process again

Creating some fixed prices to form a starting point template

First of all we need to create a template which will give us a pattern to follow in Excel.  We do this by firstly creating some fixed prices in Navigator and then exporting them in to a CSV format that can be opened and modified in Excel.

To get a broad range of different types of fixed prices, it’s often an idea to create one fixed price for each vehicle type and maybe one or two fixed prices for the Cash account and one or two for either All Accounts or individual accounts – please refer to Can I have different fixed prices for individual account customers? for more information.
In this example, we’ve created a variety of fixed prices for Place to Place, Place to Plot and Plot to Plot, and within those we’ve created different fixed prices for All Accounts, Cash account and individual accounts.  Within each of those we’ve created a few different fixed prices for different vehicle types…



Creating the CSV file
Next we need to create the CSV file and we do this by running Fixed Price Export facility on the Navigator Server.  To do this we first need to close Navigator and log into the Server:


1. Close all Navigator clients


2. On the Server machine, right-mouse click on the NavSrv icon in the bottom right-hand corner of the Desktop


2. The Navigator Server window will open…



3. Click on the Session menu and choose Login


4. Enter your username and password and press ENTER or click OK


5. You’ll now be logged on to the Server and you should see more menus across the top


6. Click on the Maintenance menu and choose Export


7. The Export dialogue box will appear.  Place a tick in the Fixed Prices check box and enter the export password in the password box:
The password is export2003


8. The export will be quick to run and once it has finished log out of the server and the Navigator clients can log back in and continue working as normal


Opening the CSV file in Excel
The export will have created a file called Navigator_fixedprices.csv and placed it in the root directory (C:\) of the Server machine (STN1):
1. Open My Computer or Windows Explorer and double click on the C:\ drive icon and locate the file called Navigator_fixedprices.csv


2. Double click on the file and it will open in Excel…



Adding more fixed prices to the Excel spreadsheet
Adding more fixed prices to the Navigator_fixedprices.csv file couldn’t be easier.  It’s just a matter of inserting more rows and then following the pattern of the row above.
Don’t get too carried away with entering all the fixed prices in one go because you’ll want to do a sample import back into Navigator to make sure you’re not making too many errors.  So just enter a few of each type to start with then refer to the section called Doing a sample import.


In this example, let’s say that you want to add some more Place to Plot fixed prices:
1. First of all locate the Place to Plot fixed prices in the spreadsheet…


2. If you just want to add one fixed price you only need to insert one blank row.  Select the row immediately below the last Place to Plot fixed price (in this example select row 13) and click on the Insert menu and choose Rows.  A new blank row will be inserted above the selected row.


Alternatively, select the row, right-mouse click on it and choose Insert from the shortcut menu



3. If you just want to add more than one fixed price you’ll need to insert more blank rows.  If you want to add 10 more fixed prices, select 10 rows immediately below the last Place to Plot fixed price (in this example select rows 13 to 22) and click on the Insert menu and choose Rows.  A new blank row will be inserted above the selected row.
Alternatively, select the rows, right-mouse click on it and choose Insert from the shortcut menu


4. Now you have some new blank rows it’s just a matter of populating them with the new fixed prices following the pattern already created


5. Click in the first cell of the first blank row and copy exactly the entry in the cell above.  This can be achieved by one of three methods:

  • Use Copy and Paste to copy the contents of the cell above and pasting it into the blank cell
  • By pressing CTRL+@ on your keyboard (the CTRL+@ keyboard shortcut copies the contents of the cell above)
  • Use the Fill Handle to duplicate the data into the cells below – click on the cell containing that data you wish to copy, place the mouse cursor

Select the row immediately below the last Place to Plot fixed price, click on the Insert menu and choose Rows
Alternatively, select the row, right-mouse click on it and choose Insert from the shortcut menu


Select the 10 rows immediately below the last Place to Plot fixed price, click on the Insert menu and choose Rows
Alternatively, select the rows, right-mouse click on them and choose Insert from the shortcut menu


How to create fixed prices

on the black blob in the bottom right-hand corner of the selected cell, the mouse pointer will change to a black cross, click and drag downwards (see the image below for example of this method)


6. Work your way across the row duplicating the data that needs to be duplicated from the cells above or entering in the new data as necessary e.g. the From and To cells will probably differ


7. Remember to use the Fill Handle as much as possible to quickly duplicate data into multiple cells below

Saving the CSV file
It’s advisable to save the file frequently!
1. Click on the File menu and choose Save


2. A message will appear asking if you want to keep the workbook in this format, click Yes


Doing a sample import
Before you get too carried away and enter all the additional fixed prices, it’s worth doing a practice import to see if you’re creating them correctly and not making too many errors.  It’s very frustrating if you spend ages adding 800 additional fixed prices and then find out there’s a slight problem with all of them!  It’s best to enter a few of each type, then get Navigator to check the file for errors, sort out any errors and then continue adding the bulk of the fixed prices.  


1. Once you’ve added a few of each type, close and save the Excel file making sure you keep the file in the existing CSV format with the name Navigator_fixedprices.csv


2. Make sure all clients are logged out of Navigator


3. Log into the Server by right-mouse clicking on the NavSrv icon in the bottom right-hand corner of the Desktop



3. The Navigator Server window will open…


4. Click on the Session menu and choose Login


5. Enter your username and password and press ENTER or click OK


6. You’ll now be logged on to the Server and you should see more menus across the top


7. Click on the Configuration menu, highlight Imports, then CSV Imports and then click on Fixed Prices


8. A message will be displayed warning you that all existing fixed prices will be deleted and to ensure that you have made backups.
Don’t worry about taking a backup on this occasion because we won’t be
Right-mouse click on the Navigator Server icon and choose Connection Info
Click on the Session menu and choose Login, enter your username and password and click OK
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 26 of 34
doing a full import, we’ll just be checking the file for errors.  When we’re ready to do the actual import we’ll make sure we do a full backup before proceeding.
Click OK on the message.
9. An Open dialogue box will appear with the Navigator_fixedprices.csv file selected, click Open to import the file
10. The CSV import window will appear and Navigator will check the CSV file for errors
11. When the file has been checked, the fixed prices will be shown in the window and the first column will indicate whether Navigator deemed the fixed price to be OK or invalid
Drag each column heading to make each column wider just like you would in Excel
Make sure the Navigator_fixedprices.csv file is in the File name box
Click Open to continue
The first column indicated whether the fixed price is OK or invalid and column will also indicate which fields (columns) have caused the problem.   
These two rows show that the entry in the From field has not been accepted – probably because Southampton Airport hasn’t been added to the local street database
This row error is showing that both the Vehicle and From fields have invalid fields
Cclass has been entered in the Vehicle field when it isn’t a valid vehicle type
Click the Abort button to abort the export
This fixed price has  ***UNKNOWN*** in the To field
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 27 of 34
12. Click the Abort button to abort the import
13. Go back into Excel or Navigator and correct the problems.
In this instance, we need to go back into Navigator and add Southampton and Bournemouth Airports to the local street database and add Cclass as a vehicle type.
We can also open the Navigator_fixedprices.csv file and delete the fixed price with the *****UNKNOWN****** in the To field.  Select the whole row, right-mouse click on the row and choose Delete from the shortcut menu
14. Log back into the Server and run the import again
15. Hopefully this time Navigator will pass all the fixed prices as “OK” and not find any errors.  Scroll down the list and just make sure that each row has “OK” in the first column.  If there are still invalid lines, go back into the Excel file and try and identify the problem.  
Right-mouse click on the selected row and choose Delete from the shortcut menu
Each row will hopefully have “OK” in the first column indicating that Navigator will accept the fixed price
If you want to actually import these prices into Navigator click the Continue button to continue with the import, if you’re just using this as a test run, click Abort to abort the import
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 28 of 34
Possible problems with the Excel file
There are many reasons why a fixed price might fail Navigator’s validation and have an “invalid” flag, here are a few possible causes:
Place not added to the local street database – you can only create fixed prices to and from places that are in the local street database, please refer to Adding a place to your local street database for more information.
Place not approved – make sure all the places added to the local street database have been “approved”.
Incorrectly spelt places or plots – the spelling of places and plots in the CSV file must match exactly the spelling in the local street database.
Invalid account reference, driver rate or vehicle type – make sure these are all valid entries in Navigator e.g. if you create a fixed price for a vehicle type “EXEC”, make sure the vehicle type EXEC exists in Navigator.
Fixed price types in the wrong fixed price section – make sure you’ve put the fixed price in the correct section.  The fixed price type is in the first column.  For example, Place to Place fixed prices must be under the FixedPricePP section, whilst Place to Plot fixed prices must be under FixedPricePL, Plot to Plot fixed prices under FixedPriceLL, Place to All Plots under FixedPricePA
Make sure you’re putting the correct fixed prices under the right heading
Place to Place fixed prices
Place to Plot fixed prices
Plot to Plot fixed prices
Place to All Plots fixed prices
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 29 of 34
Importing the fixed prices
OK, so you’ve managed to correct any errors and you’ve now got a nice clean import file with “OKs” showing all the way down the list.  Before you do the actual import, we recommend that you do a quick backup of the Navigator database just in case something goes wrong or you want to roll-back to restore the database to the state it was in before the import.
1. Log into the Server as normal
2. Click on the Maintenance menu and highlight Backup then Backup now
3. Once the backup has finished, follow the import process described in Doing a sample import
4. If all the fixed prices are “OK”, click on the Continue button to import the fixed prices into Navigator
Sometimes you can’t see the wood from the trees especially if you’ve been looking at the same problem for ages!  If you can’t figure out why some fixed prices aren’t being accepted, get someone else to have a look.  Or give us a buzz on the Support line and we should be able to figure it out for you!
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 30 of 34
5. The import process may take a few minutes…be patient!
6. When the fixed prices have been imported, you’ll be returned to the Navigator Server window.  You can now log clients back into Navigator.
Creating fixed prices when manually pricing the job
If you want to create a one-off fixed price for account jobs, the easiest way to create it is when you’re manually pricing the job using the pricing form.  Please note that this method of creating fixed prices cannot be used for Cash jobs.
1. Go into the Pricing form as normal, locate and select the job in question
2. Confirm that both the Account and Driver prices are correct
3. Complete all the options at the bottom of the pricing form:
Check to make sure the correct type of fixed price is selected, i.e. Place to Place, Place to Plot, Plot to Place, Plot to Plot, Place to All Plots or All Plots to place
Select the account that this fixed price is for.  If the job was booked for an account customer, choose the account name, if it’s a fixed price for all accounts select All Accounts.  
Select the vehicle type.  The choice given will be the vehicle type used on the job being priced or All Vehicles
Select the driver rate.  The choice given will be the driver rate used on the job being priced or All Driver Rates
Place a tick in the Save Account and/or Save Driver check boxes and choose whether you want to save the distance or price
4. When you’re happy with all your choices, click on the Save as fixed button
Hopefully you now have a nice “clean” import file with “OK” all the way down the list
Click on the Continue button to import the fixed prices into Navigator
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 31 of 34
5. A message is displayed asking if you would like to apply this fixed price/distance to all relevant un-priced bookings, Yes will apply this fixed price to all current bookings with the same details, whilst No will just apply the fixed price to this job and future bookings with the same details
Why can’t I see the Saved Job as Fixed Price part of the screen?
The Pricing screen can be modified to either show or hide the Job Ticket and Fixed Pricing elements.  If you can’t see either of these screen elements, right-mouse click and choose either Show job ticket or Show fixed pricing details
Locate and select the job to be fixed
Confirm that both the Account and Driver prices are correct
Check to make sure the correct type of fixed price is selected, i.e. Place to Place, Place to Plot, Plot to Place, Plot to Plot, Place to All Plots or All Plots to place
Select the vehicle type.  The choice given will be the vehicle type used on the job being priced or All Vehicles
Select the account that this fixed price is for.  If the job was booked for an account customer, choose the account name, if it’s a fixed price for all accounts select All Accounts.  
Place a tick in the Save Account and/or Save Driver check boxes and choose whether you want to save the distance or price
Select the driver rate.  The choice given will be the driver rate used on the job being priced or All Driver Rates
When you’re happy with your choices, click on the Save as fixed button
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 32 of 34
Amending fixed prices
How you go about amending fixed prices will largely depend on how many there are to change.  If there are just one or two, it’s best to do it through the Edit Fixed Price option on the Pricing menu.  If however you want to introduce an annual tariff increase to all fixed prices, then it may be best to do it using Excel.
Amending prices using the Edit Fixed Price option
If you only have a few fixed prices to change, use the Edit Fixed price option on the Pricing menu:
1. Click on the Pricing menu and choose Edit fixed price
2. An empty window will appear…
3. Click on the plus sign next to the Fixed prices folder to expand the list
4. You’ll now see a list of the different types of fixed price booking; Place to place, Place to plot, Plot to plot and Place to all plots
5. Click on the plus signs to expand each list
Click on the plus sign next to Fixed prices to expand the list
Right-mouse click on the screen and choose either Show job ticket or Show fixed pricing details
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 33 of 34
6. Under each type of fixed price, you’ll find a list of accounts who have fixed price bookings within that category
7. If you expand each account you’ll find the fixed price bookings categorised by vehicle type
8. Click on a vehicle type to show the fixed price booking/s
9. In the right-hand window, select the booking you wish to change
10. Click on the Edit fixed price button to open the Edit fixed price window
Use the plus signs to expand the lists
Under each fixed price group you’ll see a list of the accounts who have that type of fixed price booking and vehicle  
Under each account, you’ll see the vehicle types.   
Click on a vehicle type to show the fixed price bookings in the righthand window
Select the booking
Click on the Edit fixed price button  
How to create fixed prices
Version 1.1 © Copyright Navigator Software Systems Ltd June 2007 Page 34 of 34
11. Amend the fixed price booking details as necessary and click OK when done
Amending prices using Excel
If you’ve loads of fixed prices to change, it’s best to export them out of Navigator, modify them in Excel and then re-import them back into Navigator.  The process that you’ll follow to do this is as follows and all these steps are covered in detail earlier in this document:
Create the CSV file using the Fixed Prices Export utility – please refer to Creating the CSV file
Open the CSV file in Excel and modify the prices – please refer to Opening the CSV file in Excel
Check the CSV file for errors and correct as necessary – please refer to Doing a sample import
Backup the Navigator database and importing the amended CSV file – please refer to Importing the fixed prices