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:finance:transfer_to_finance [2015/11/10 23:06]
dokuwiki_sync
userdocs:travelwise:finance:transfer_to_finance [2019/09/21 09:20] (current)
dokuwiki_sync
Line 10: Line 10:
   * AirPlus;   * AirPlus;
   * FInvoice ('​E-Invoice'​ format);   * FInvoice ('​E-Invoice'​ format);
-  * Microsoft AX*.+  * [[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.
  
-*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. 
 ==== FInvoice ==== ==== FInvoice ====
 === Format Description === === Format Description ===