Differences
This shows you the differences between two versions of the page.
| 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. | ||
