Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
userdocs:travelwise:finance:transfer_to_finance [2014/11/11 03:41] dokuwiki_sync |
userdocs:travelwise:finance:transfer_to_finance [2019/09/21 09:20] (current) dokuwiki_sync |
||
---|---|---|---|
Line 9: | Line 9: | ||
* PRISM; | * PRISM; | ||
* AirPlus; | * AirPlus; | ||
- | * FInvoice ('E-Invoice' format). | + | * FInvoice ('E-Invoice' format); |
+ | * [[userdocs:travelwise:finance:ftpuploading|Microsoft AX]]*. | ||
+ | |||
+ | * | ||
+ | **Read more:** | ||
+ | [[userdocs:travelwise:finance:ftpuploading|Invoice data FTP uploading in JTB]] | ||
+ | |||
+ | 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 ==== | ==== FInvoice ==== |