System ➔ General ➔ Settings
When you are creating layouts for documents used in your administration, you need to insert database fields in the layouts. Database fields are fields used to enter information from your database, such as item data or customer information, in the layouts.
The information in this document is applicable to product update 410 and higher. If you have versions lower than this, certain features explained here will not be applicable.
Select the block that contains the database field to be inserted. For more information, see Maintaining layouts: Explanation on blocks.
Type the length of the selected database field per line. The length defines the number of positions which is allowed to be entered in this database field on every line. If the description takes up more than the length (number of positions) specified for each line of the database field, the part of description that exceeded the length will automatically be displayed in the subsequent line.
Select the database field to be inserted in the layout.
Select this check box to prevent the header from being printed more than once even if the invoice has more than one order number or our reference number.
Select this check box to distribute the text evenly within the Description column. The distribution will be done based on the value defined at Length. See the following examples of the invoice layout:
Type the introductory text for the database field.
Type the subsequent text for the database field.
Select the alignment for the database field, introductory text, and subsequent text. The following options are available:
Click Introductory text to select the color for the introductory text, Subsequent text to select the color for the subsequent text, and Database field to select the color for the database field.
Depending on the block and the field you select, you will see different settings options for database fields. In this example, the layout for purchase order is edited. You will see the additional settings options as below for database fields if you select the Item block and the Discount amount field.
Type the amount of spaces before the decimal for precision in recording the discount amount.
Note: This field is only displayed when Define precision is selected.
Type the amount of separator spaces after the decimal for precision in recording the discount amount.
Select the precision settings option for the database field. Three options are available, which include Define precision, Price precision, and Precision for amounts. If you select Price precision or Precision for amounts, you can type the length of the precision at Length.
Select this check box to display the numbers in the layout with the thousand separator. For example, for the amount of one thousand, it will be recorded as “1,000” in the layout.
Select the unit of numbers for your data to be displayed in the layout. This is useful if you work with extremely huge or small numbers. For example, if you set the unit to “1,000,000”, the quantity for “47,000,000” will be displayed in the layout as “47”.
Select this check box if you want the layout to leave out any undefined database fields.
Click this to insert the database field in the layout.
Click this to exit.