You can use the layout templates for serial letters, printouts or as a basis for the certificate generator.
As a starting point for a layout template, it is recommended to use a previously created Office file (e.g. Word, Open Office Writer), which is exported as a PDF. On PDF, dynamic variables from xentral, such as address data, can be loaded.
With a click on the +NEW button, you can create a new layout template. Under Background you can upload the PDF created in Office.
Click Save to save the template. After that you can edit under Positions/Elements you can add texts, images and other elements dynamically with variables. To do this, select at least a description, the type, the positions of the element and the content.
Note
The desired position of the element can also be measured on the paper to save yourself time. Under Preview you can examine the arrangement of the elements. Here it would be the address block in curly Brackets (variables) under the address.
For example, to add a cover sheet to a quote, you need to use the Layout Templates and Layout Templates Attachment modules.
You can upload your cover sheet using the Layout Templates module (Search bar > Layout Templates):
Then you can add elements, such as the name, under Positions/Elements in the created template. Then you can set the position of the name (via variables):
Then you need to go to the Attachment Layout Templates module (Search Bar > Attachment Layout Templates) and assign the created layout to the offer there:
If then in the corresponding project (Master data > Projects > *Your project* > Settings > Logistics/Shipping) then the "PDF attachment" is activated, the cover sheet will be printed every time. When sending by e-mail, the cover sheet is attached as an additional PDF file:
If you create particularly large/complicated layout templates, it may make sense to save them in order to exchange or reuse them as desired. To do this, simply click on the download icon in the overview.
A list of all the variables that you can currently use in the layout templates can use:
-
{NAME}
-
{STREET}
-
{PLZ}
-
{TOWN}
-
{ADDRESS}
More variables are available in the Layout Templates appendix app.
The following variables can be used as elements for serial letters:
-
{TITLE}: Title of the address
-
{NAME}: Name of the address
-
{DIVISION}: Department of the address
-
{contact person}: Contact person of the address
-
{STREET}: Street of the address
-
{ADDRESS ADDITION}: Address suffix of the address
-
{PLZ}: ZIP code of the address
-
{LOCATION}: City of the address
-
{Country}: Country of the address
-
{PHONE}: Phone number of the address
-
{TELEFAX}: Fax of the address
-
{MOBILE}: Mobile number of the address
-
{EMAIL}: E-mail address of the address
-
{USTID}: VAT ID of the address
-
{CUSTOMER NUMBER}: Customer number of the address
-
{SUPPLIER NUMBER}: supplier number of the address
-
{BANK}: Bank name of the address
-
{INHOLDER}: Account holder of the address
-
{IBAN}: IBAN of the address
-
{BIC}: BIC of the address
-
{CURRENCY}: Currency of the address
-
{ADDRESS}: Salutation of the address
-
{FREEFIELD1}: Free field1 of the address, the number 1 can be replaced with the numbers from 1 to 20 can be replaced
-
{DATE_TODAY}: Today's date in the format dd.mm.yyyy
It is also possible to create a wide variety of cards using the layout template. Such as a birthday card, here you can upload a background. But you can also use a printing company printing paper for various cards. These layout templates can be saved and used to print serial letters.
You can get to the serial letters via App Center → Serial letters
Here it is possible via the filter button e.g. to filter according to the birthday of certain persons (Birthday must be created in the addresses). After that, birthday cards can be conveniently printed for these selected people (or even other cards).
You can also create a visit report using the layout templates. You can do this in Addresses > Edit > Correspondence > Appointments with the click of a button and print it for the customer. In the layout templates, you create a template with the category visit report.
After that, a Visit report button will appear under an existing appointment in the address.
After clicking on it, the visit report will be printed with the variables created in the layout template to the customer.
Address: All possible fields from the customer address (table address), e.g:
-
{ADDRESS_NAME}
-
{ADDRESS_ADDRESS_ARTNER}
-
{ADDRESS_STREET}
-
{ADDRESS_LOCATION}
-
{ADDRESS_PLACE}
-
{ADDRESS_PHONE}{ADDRESS_MOBILE}
-
{ADDRESS_EMAIL}
Calendar: All possible fields from a calendar entry (table calendar_event), e.g:
-
{DATE}
-
{DATEBIS}
-
{TIME}
-
{TIME}
-
{DESCRIPTION}
-
{DESCRIPTION}
-
{EMPLOYEE}
To be able to use the Multilabel print module, you must first create a new layout for it in the layout templates.
In order to get different items on one PDF sheet, the variables for the content of the layout elements are numbered consecutively. E.G. {1_NUMBER}, {2_NUMBER} for the article numbers of the first two articles.
Note
Only the numbering on page 1 has to be differentiated. From page 2 onwards the numbering begins again.
Example: 4 products fit on 1 page. But we mark 7 articles in the module Multilabel print. Nevertheless, we only need to use {1_NUMBER}, {2_NUMBER}, {3_NUMBER} and {4_NUMBER} for the product numbers. From page 2 on, the 5th product uses the first variable, but still uses its correct product number.
The following variables can be used as elements for the multilabel print. (X always stands for numbering here):
-
{X_NUMBER}: Item number
-
{X_NAME_EN}: Item name
-
{X_NAME_EN}: Item name English
-
{X_ANABREGS_TEXT}: Item description
-
{X_ANABREGS_TEXT_EN}: Item description English
-
{X_MANUFACTURER}: Manufacturer of the item
-
{X_EAN}: EAN of the item
-
{X_CUSTOMS TARIFF NUMBER}: Customs tariff number of the item
-
{X_WEIGHT}: Weight of the item
-
{X_SALE PRICE}: Selling price of the item
-
{X_PROPERTY_Y}: Property of the item, Y must be replaced here with the property name as it was entered under Master data → Item → Edit → Properties has been entered
-
{X_FREIFELD1}: Free field1 of the article, number 1 can be replaced by any number be replaced from 1 to 40
-
{X_UNIT}: Unit of the item
-
{X_LAENGE}: Length of the item
-
{X_WIDTH}: Width of the item
-
{X_HEIGHT}: Height of the article
-
{X_COUNTRY OF ORIGIN}: Country of origin of the item
-
{X_ORIGINATION REGION}: Region of origin of the item
Example PDF sheet.
In our example, we map the following:
-
Part number
-
Part name
-
Selling price
-
2 property values
-
Article image
As elements for 1 page we create 6 descriptions and 6 images:
For example, the content of a description field looks like this (3rd element):
Note
For the properties, please enter the property name as a variable at the end, as it was entered under Master data> Product > Edit > Properties. Upper / lower case, umlauts do not have to be carefully considered. We then get this PDF sheet as a preview in the multi-label print module:
You can also upload the layout as a JSON file. Copy the code into a text editor and save the file as a .json file. Then load them into the layout generator.
{"Layout":{"id":"1","name":"Artikellabels","typ":"pdf","pdf_hintergrund":"","format":"A4","kategorie":""},"Layoutpositionen":[{"id":"1","layoutvorlage":"1","name":"beschreibung-1","beschreibung":"Beschreibung 1","typ":"textfeld","position_typ":"absolute","position_x":"10","position_y":"10","position_parent":"0","breite":"60","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"{1_NUMMER}\r\n{1_NAME_DE}\r\n{1_VERKAUFSPREIS} \u20ac\r\nFarbe: {1_EIGENSCHAFT_FARBE}\r\nGr\u00f6\u00dfe: {1_EIGENSCHAFT_GROESSE}","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"8"},{"id":"2","layoutvorlage":"1","name":"beschreibung-2","beschreibung":"Beschreibung 2","typ":"textfeld","position_typ":"absolute","position_x":"100","position_y":"10","position_parent":"0","breite":"60","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"{2_NUMMER}\r\n{2_NAME_DE}\r\n{2_VERKAUFSPREIS} \u20ac\r\nFarbe: {2_EIGENSCHAFT_FARBE}\r\nGr\u00f6\u00dfe: {2_EIGENSCHAFT_GROESSE}","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"7"},{"id":"3","layoutvorlage":"1","name":"beschreibung-3","beschreibung":"Beschreibung 3","typ":"textfeld","position_typ":"absolute","position_x":"10","position_y":"100","position_parent":"0","breite":"60","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"{3_NUMMER}\r\n{3_NAME_DE}\r\n{3_VERKAUFSPREIS} \u20ac\r\nFarbe: {3_EIGENSCHAFT_FARBE}\r\nGr\u00f6\u00dfe: {3_EIGENSCHAFT_GROESSE}","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"6"},{"id":"4","layoutvorlage":"1","name":"beschreibung-4","beschreibung":"Beschreibung 4","typ":"textfeld","position_typ":"absolute","position_x":"100","position_y":"100","position_parent":"0","breite":"60","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"{4_NUMMER}\r\n{4_NAME_DE}\r\n{4_VERKAUFSPREIS} \u20ac\r\nFarbe: {4_EIGENSCHAFT_FARBE}\r\nGr\u00f6\u00dfe: {4_EIGENSCHAFT_GROESSE}","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"5"},{"id":"5","layoutvorlage":"1","name":"beschreibung-5","beschreibung":"Beschreibung 5","typ":"textfeld","position_typ":"absolute","position_x":"10","position_y":"190","position_parent":"0","breite":"60","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"{5_NUMMER}\r\n{5_NAME_DE}\r\n{5_VERKAUFSPREIS} \u20ac\r\nFarbe: {5_EIGENSCHAFT_FARBE}\r\nGr\u00f6\u00dfe: {5_EIGENSCHAFT_GROESSE}","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"5"},{"id":"6","layoutvorlage":"1","name":"beschreibung-6","beschreibung":"Beschreibung 6","typ":"textfeld","position_typ":"absolute","position_x":"100","position_y":"190","position_parent":"0","breite":"60","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"{6_NUMMER}\r\n{6_NAME_DE}\r\n{6_VERKAUFSPREIS} \u20ac\r\nFarbe: {6_EIGENSCHAFT_FARBE}\r\nGr\u00f6\u00dfe: {6_EIGENSCHAFT_GROESSE}","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"5"},{"id":"7","layoutvorlage":"1","name":"1-produktbild","beschreibung":"1_produktbild","typ":"bild","position_typ":"absolute","position_x":"10","position_y":"40","position_parent":"0","breite":"50","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"4"},{"id":"8","layoutvorlage":"1","name":"2-produktbild","beschreibung":"2_produktbild","typ":"bild","position_typ":"absolute","position_x":"100","position_y":"40","position_parent":"0","breite":"50","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"3"},{"id":"9","layoutvorlage":"1","name":"3-produktbild","beschreibung":"3_produktbild","typ":"bild","position_typ":"absolute","position_x":"10","position_y":"130","position_parent":"0","breite":"50","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"2"},{"id":"10","layoutvorlage":"1","name":"4-produktbild","beschreibung":"4_produktbild","typ":"bild","position_typ":"absolute","position_x":"100","position_y":"130","position_parent":"0","breite":"50","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"1"},{"id":"11","layoutvorlage":"1","name":"5-produktbild","beschreibung":"5_produktbild","typ":"bild","position_typ":"absolute","position_x":"10","position_y":"220","position_parent":"0","breite":"50","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"1"},{"id":"12","layoutvorlage":"1","name":"6-produktbild","beschreibung":"6_produktbild","typ":"bild","position_typ":"absolute","position_x":"100","position_y":"220","position_parent":"0","breite":"50","hoehe":"40","schrift_art":"times","zeilen_hoehe":"5","schrift_groesse":"12","schrift_farbe":"#000000","schrift_align":"left","hintergrund_farbe":"#FFFFFF","rahmen":"0","rahmen_farbe":"#FFFFFF","sichtbar":"1","inhalt_deutsch":"","inhalt_englisch":"","bild_deutsch":"","bild_englisch":"","schrift_fett":"0","schrift_kursiv":"0","schrift_underline":"0","bild_deutsch_typ":"","bild_englisch_typ":"","sort":"1"}]}
Layout templates are also required to create a check template in the Check extra module.
Note
The category must be set to scheck. You should clarify with your bank whether a blank check from the bank can be deposited as a PDF.