Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
userdocs:travelwise:reporting:bsp [2014/05/19 02:03]
dokuwiki_sync
userdocs:travelwise:reporting:bsp [2014/06/03 03:44] (current)
dokuwiki_sync
Line 1: Line 1:
-====== BSP Report ​======+====== BSP ======
  
-BSP (//Billing and Settlement Plan//) - is a mechanism for airlines to charge the money for air tickets from selling agents. +<​catlist ​userdocs:​travelwise:​reporting:​bsp:>
-For more info please visit IATA page: [[http://​www.iata.org/​ps/​financial_services/​bsp/​Pages/​index.aspx]] +
- +
-===== Purpose ===== +
-BSP Report in Travelwise.net is designed to import data file from BSP containing all tickets bought by the Agent, compare this data with Application database and generate a report showing the difference. It is a tool to trace expenses for air tickets and ensure that BSP charges correct amounts. +
- +
-===== Workflow ===== +
-BSP report in Application consists of 2 main steps: +
-  - Import of BSP file and calculation the difference (//Reports → BSP → Import BSP data from file//); +
-  - BSP report itself showing results of calculation (//Reports -> BSP -> BSP Report (New)//). +
- +
-//New functionality since version 1.85.11// +
- +
-One or several files can be used for comparison with new options: +
-  * invoice date period from/to; max difference in local currency; +
-  * expence only from invoice lines or exp+VAT; +
-  * no need to have IATA no selection since by choosing the files to compare (IATA is defined); +
-  * both //AGT// and //HOT// files are supplied. +
- +
-===== STEP 1 ===== +
- +
-**Navigation:​** //Reports -> BSP -> Import BSP data from file// +
- +
-All is needed is to browse for a file and push //'​Export'//​ button. Available data becomes exported by itself without any additional actions from user's side. The file title is going to be generated according to the green area, but it is allowed to type it manually in the //'​File name'//​ field: +
-{{:userdocs:​travelwise:​reporting:​import_bsp.png|}} +
- +
-===== STEP 2 ===== +
- +
-**Navigation:** //Reports -BSP -> BSP Report (New)// +
- +
-To generate the report: +
-  - Select the files for reporting. +
-  - Complete //Report parameters: Date from - Date to// and set //Max. Diff// (if maximum difference = 0, then even the slightest difference is going to be shown). +
-  - Push //​Export//​. +
-{{:​userdocs:​travelwise:​reporting:​bsp_report.png|}} +
- +
-To return the locked files back, please do the importing one more time (or contact helpdesk in case of difficulty). +
- +
-===== Report Notes ===== +
-  * Tickets are merged in case its number is the same, but different //'​TWDocType'//​.  +
-  * Totals of //PNR tickets// and //manual tickets// with the same number is summarized. For such records //'​Mixed'​ type ('​TWDocType'​)//​ is set, //issue date// and //PNR// are taken from PNR ticket, Order No, values are separated with comma.+