Software_Documentation_BSPReconciliation
Software Documentation
Functional Description
„BSP Reconciliation"
Created by:
Christine Dollmann
Bewotec GmbH
Date |
Version |
Description |
Author |
12.08.2013 |
0.1 |
Document Created |
C. Dollmann |
16.08.2013 |
0.2 |
Update Document |
C. Dollmann |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Content
1. Import BSP File
1.1. Reconcile
1.2. Change error
2. Work through the error list
2.1. Standard Ticket
2.2. Refund / ADM / ACM
Import BSP File
The .agt file can be loaded for reconciliation via Configuration – Import/Export – Import BSP Data…
Here, a new file can be selected in the dialogue which is opened via the "Import data" button.
In the dialogue, the following parameters need to be entered to load the file and start first reconciliation run against the table including the tickets in DaVinci:
After entering the required information and selection of the BSP file path the data can be imported.
Please make sure that the correct regional selection is made, here Scandinavia.
During the import, the BSP data from the file is now compared with the ticket information stored in DaVinci. This comparison is defined as reconciliation.
Reconcile
In case that changes need to be made in DaVinci ticket information due to differences in the BSP file, an update of the compared information can be done with the "Reconcile" button.
With click on „Reconcile", the period for BSP reconciliation (column BEST_MONAT_BSP) is set on those tickets, where ticket issue date matches the period.
If a ticket is available in BSP and DaVinci ticket information, the "Compared" checkbox (column AUSGEGLICHEN) is set to 1 after "Reconcile".
Change error
The "Change error" button opens the dialogue of the BSP error list.
Within this feature Bewotec compares the invoice information of BSP with the entered ticket information in DaVinci.
The following errors are possible within the BSP error list:
Error Message |
Description |
Ticket not found |
Ticket cannot be found in DaVinci |
Fare unequal |
Fare of BSP invoice and DaVinci ticket information does not match |
Tax unequal |
Tax of BSP invoice and DaVinci ticket information does not match |
Commission unequal |
Commission of BSP invoice and DaVinci ticket information does not match |
Amount of conjunctions unequal |
Amount of conjunctions of BSP invoice and DaVinci ticket information does not match |
Currency unequal |
Currency of BSP invoice and DaVinci ticket information does not match |
Cash unequal |
Cash amount of BSP invoice and DaVinci ticket information does not match |
Credit unequal |
Credit amount of BSP invoice and DaVinci ticket information does not match |
Tax on Commission unequal |
Tax on commission of BSP invoice and DaVinci ticket information does not match |
Airline does not match |
Airline of BSP invoice and DaVinci ticket information does not match less than sales tax (variance) |
Ticket type unknown |
Ticket type of BSP invoice unknown |
Ticket type might be different (Booking xxx) |
Ticket type of BSP invoice and DaVinci ticket different, booking number will be mentioned. |
Wrong reconciliation period |
Ticket issuing date does not match with the reconciliation period. |
Once all errors have either been corrected or accepted, the BSP error list can be closed.
Work through the error list
Standard Ticket
This error message comes up, if the ticket has been invoice by BSP, but cannot found in DaVinci.
In this case you need to find out to which booking the ticket belongs and enter it to the corresponding booking.
The ticket information can be entered manually from the Genesis mask. Display the respective booking file – Menu – Get booking
Klick on „Tickets" to open the ticket mask
All tickets of the booking file are displayed here.
A new ticket can be entered via „New" – or in case that similar tickets are available – as a "Copy".
Within this mask you need to enter all the ticket details.
In a next step, the comparison between BSP file and ticket information from DaVinci can be repeated by "Reconcile".
After the reconciliation has been done, the amount of errors is reduced.
As you can see from the BSP error list the error message disappears, as the ticket can be found and is assigned to a booking number.
In this case, the tickets information from DaVinci is matching completely with the BSP file data. So the ticket can only be found on the error list when "Error tickets only" is de-activated.
Remark: In case that a ticket/booking is found, it is possible to access the booking file from here, e.g. for correction of fare, tax, etc., by right click – Open booking
Refund / ADM / ACM
The error message "ticket not found" does also appear for ticket types which need to be manually entered in DaVinci. These document types can only be entered in relation to tickets which are already available as DaVinci ticket information.
For those ticket types, it is possible to access the dialogue for manual entry via button "Properties"
After correction of the difference, the respective information can be saved.
The entry can be taken from the error list with „Update" button.
For booking related ADMs, ACMs a specific dialogue can be used as described below. This one is quite helpful if the ADM and ACM is split over different tickets and bookings.
Workaround possibility non booking related ADMs, ACMs and MCOs
Entry of a dummy booking per BSP period which will be maintained manually and to which the ticket details will be manually added.