Technical Information Export Templates (DOCX/XLSX) You can customize the Docx Exports to your individual needs. The following information will give you a detailed overview on how to use the different functions. General You can find all variables that you can use here, depending on the document type: Travel Document Document Dossier Customer TotalPrice Travellers Products Document Dossier Customer TotalPrice Positions If you want to get a deeper technology background, have a look at the Apache FreeMarker Library. Date formatting For example, formatting the current date: ${.now?string["dd.MM.YYYY"]} //returns 01.01.2022 ${.now?string["d. MMMM YYYY"]} //returns 1. January 2022 See details about formattingFormat Definition Month M Month, from 1 through 12 MM Two digit month, from 01 through 12 MMM Abbreviated name of the month, for example: Jan, Feb, etc. MMMM Full name of the month, for example: January, February, etc. Day d Day of the month from 1 through 31 dd Day of the month from 01 through 31 ddd Standard abbreviation for the day of the week, for example: Mon, Tue, etc. dddd Full name of the day of the week, for example: Monday, Tuesday, etc. Year y Year from 0 to 99 yy Year from 00 to 99 yyy Year with minimum of 3 digits yyyy Year as a four digit number Hour h Hour using 12-hour clock from 1 - 12 hh Hour using 12-hour clock from 01 - 12 H Hour using 24-hour clock from 0 - 24 HH Hour using 24-hour clock from 00 - 24 Minute m Hour using 12-hour clock from 1 - 12 mm Hour using 12-hour clock from 01 - 12 Second s Second, from 0 through 59 ss Second, from 00 through 59 Other t First character of the AM/PM designator tt AM/PM designator T A literal to separate date and time in 8061 or other formats z Hours offset from UTC, with no leading zeros — Example: -5 or +530 zz Hours offset from UTC, with leading zero — Example: -05 or +0530 zzz Hours and minutes offset from UTC, with leading zeros — Example -0500 or +0530 g or gg Period or era, such as A.D. K Zone information Lists If you want to repeat something, for example, all products in an offer. [#list products as product] // Use "product" for one product [/#list] Sorting You can sort lists directly in the export, for example to display all products, sorted by the field start. [#list products?sort_by('start') as product] // the products get listed, sorted by "start" [/#list] Variables Customer Usage ${customer.VARIABLE} // Replace VARIABLE with the appropriate field Definition Description Example addressAddition ${customer.addressAddition} addressFormatted The default formatting for a customer address. ${customer.addressFormatted} city ${customer.city} country The country of the customer ${customer.country} creationDate Date of the creation of the customer ${customer.creationDate?string["dd.MM.YYYY"]} creator Name of the creator of the customer ${customer.creator} email ${customer.email} firstName ${customer.firstName} lastName ${customer.lastName} name Combination of firstName and lastName ${customer.name} number The customer number in advatra (K1000001) ${customer.number} phone ${customer.phone} state ${customer.state} street ${customer.street} website ${customer.website} zipCode ${customer.zipCode} Document Usage ${document.VARIABLE} // Replace VARIABLE with the appropriate field Definition Description Example travelStart Start of the travel, only on travel documents ${document.travelStart?string["dd.MM.YYYY"]} travelEnd End of the travel, only on travel documents ${document.travelEnd?string["dd.MM.YYYY"]} expirationDate Date until the document is valid ${document.expirationDate?string["dd.MM.YYYY"]} number The document number (D1000001.101) ${document.number} currency The Currency of the document, ISO 4217 ${document.currency} note ${document.note} type Offer, Confirmation, Invoice, Deposit, Prepayment ${document.type} language ${document.language} locale Can be used for the translation of the document ${document.locale} date ${document.date?string["dd.MM.YYYY"]} charged Used for Deposit and Prepayment. Defines if they have been charged to an invoice. ${document.charged} exportDate Date, when the document have been exported to the accounting system ${document.exportDate?string["dd.MM.YYYY"]} canton Location ${document.canton} image days List of days contained in the offer/confirmation Dossier Usage ${dossier.VARIABLE} // Replace VARIABLE with the appropriate field Definition Description Example name openingDate status employee responsibleEmployee travelAgent number Product Usage [#list products as product] ${product.VARIABLE} // Replace VARIABLE with the appropriate field [#/list] Definition Description Example note start end title description voucherRelevant voucherText person images images3x2 type travellers See details here customer See details here notes prices See details here guides See details here drivers See details here supplierNotes locationSmall only available, when a template is linked. locationMedium only available, when a template is linked. locationLarge only available, when a template is linked. hasKickback true, if any service has a commission Price Usage [#list products as product] [#list product.prices as price] ${price.VARIABLE} // Replace VARIABLE with the appropriate field [/#list] [#/list] Definition Description Example name person quantity price type discount purchasingPrice creditorInvoiceReceived billingText effectivePurchasingPrice vat Vat Object kickback kickbackAmount kickbackInvoiceCreated kickbackVat total TotalPrice Object hotelNights supplier See details here TotalPrice Usage ${totalPrice.VARIABLE} // Replace VARIABLE with the appropriate field Definition Description Example vats surcharges priceNetto priceVat priceBrutto totalPriceBrutto priceNettoFormatted totalPriceFormatted Traveller Usage [#list travellers as traveller] ${traveller.VARIABLE} // Replace VARIABLE with the appropriate field [#/list] Definition Description Example firstName lastName name phone email passportNumber placeOfIssue birthday arrivalType arrivalDate arrivalTime arrivalNumber arrivalFlightClass arrivalSeat departureType Guide Usage [#list guides as guide] ${guide.VARIABLE} // Replace VARIABLE with the appropriate field [#/list] Definition Description Example firstName lastName name phone email Driver Usage [#list drivers as driver] ${driver.VARIABLE} // Replace VARIABLE with the appropriate field [#/list] Definition Description Example firstName lastName name phone email Flywire Integration Shared Calendar Reports