Differences

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

Link to this comparison view

Next revision
Previous revision
userdocs:travelwise:finance:transfer_to_finance [2013/06/19 08:40]
127.0.0.1 external edit
userdocs:travelwise:finance:transfer_to_finance [2019/09/21 09:20] (current)
dokuwiki_sync
Line 6: Line 6:
   * American Express ('​AMEX'​ format);   * American Express ('​AMEX'​ format);
   * Diners Club;   * Diners Club;
-  * Finance.+  * Finance
 +  * PRISM; 
 +  * AirPlus; 
 +  * FInvoice ('​E-Invoice'​ format); 
 +  * [[userdocs:​travelwise:​finance:​ftpuploading|Microsoft AX]]*.
  
 +*
 +**Read more:**
 +[[userdocs:​travelwise:​finance:​ftpuploading|Invoice data FTP uploading in JTB]]
  
-==== Transfer To Finance ====+Exported customers are marked in a database (CustomerAXExport) and are not taken again. If no customers are found, the export //xlsx// file is not created. 
 +1. Before exporting an invoice to INV file it is checked if there are MarginVAT products or packages exist on the invoice. 
 +2. If previous item is TRUE then when making export lines for INV file the value in field "24 Vat Code" is replaced to "​FI-TOMS-24"​ for the lines containing VATamount<>​0 ​ ("​FI"​ should be replaced with HostCompany Country code for offices different from HEL) 
 +2. In INV file for every MarginVAT invoice there is a line containing value "​TOMS"​ in field "24 Vat Code" and value to columns 26 "VAT Base amount"​ calculated by following formula: Value = TotlSell - VATamount1-VATbaseAmount1-...-VARamountX-VATbaseAmountX. 
 +Terms: "​TOMS"​ meaning is equal to MarginVAT. 
 +For more details see US 16531 in TFS. 
 + 
 +==== FInvoice ==== 
 +=== Format Description === 
 +http://​www.fkl.fi/​verkkolasku/​yrityksen_verkkolasku/​ladattavat/​Tekniset%20tiedostot/​Finvoice_def_2_1_18102013.xls 
 +http://​www.fkl.fi/​verkkolasku/​yrityksen_verkkolasku/​ladattavat/​Tekniset%20tiedostot/​Finvoice_2_1_implementation_guidelines.pdf  
 +http://​www.fkl.fi/​verkkolasku/​yrityksen_verkkolasku/​ladattavat/​Tekniset%20tiedostot/​schemat/​Finvoice.xsd 
 + 
 +**Additional info (JTB Helsinki):​** 
 +  * SellerPartyIdentifier - Bank info value is 1628820-5 (//Company Settings -> Settings -> BankInfo -> FInvoiceSellerPartyIdentifier//​);​ 
 +  * SellerOrganisationName - HC name (//Company Settings -> General -> Name//); 
 +  * SellerOrganisationTaxCode - value is FI16288205(//​Company Settings -> Settings -> BankInfo -> VatNo//); 
 +  * SellerPostalAddressDetails - HC address (//Company Settings -> General -> Address//​);​ 
 +  * SellerOfficialPostalAddress - HC address (//Company Settings -> General -> Address//​);​ 
 +  * SellerAccountID - HC setting (//Company Settings -> Settings -> BankInfo -> CompanyID//​);​ 
 +  * IBAN: FI50 1200 3000 026054 (//Company Settings -> Settings -> BankInfo -> BankCodeIBAN//​);​ 
 +  * SWIFT CODE = NDEAFIHH (//Company Settings -> Settings -> BankInfo -> BankCodeSWIFT//​). 
 +===== Transfer To Finance ​=====
 Travelwise supports data exporting in external finance systems (Axapta, Concorde, CODA). Travelwise supports data exporting in external finance systems (Axapta, Concorde, CODA).
 To transfer the data to finance system, select //'​Finance'//​ transfer type and define the search criteria or leave it blank to get all records, which are not transferred to finance. To transfer the data to finance system, select //'​Finance'//​ transfer type and define the search criteria or leave it blank to get all records, which are not transferred to finance.