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.