Edit templates

Max. lines

The number of rows to be displayed. If empty, settings from Configuration wizard – System are applied. By default, only the first 200 entries are displayed.
If you want to have all rows displayed, enter a large number
e.g. 1.000.000

Note:

This function is not available in the HANA version.

Title

If active, you can insert a title.

Text

Title (only available if field above "Title" was activated. In contrast to window header the title is printed.

Authorization

If only dedicated users shall have access to some template, you can select them here.

See Templates - Authorizations

Terminal mode - Personnel

Controls the authorizations on Personnel level.

Beas standard:

This filter is considered additionally if the current user is connected with a Personnel-Entry.

"Authorization" and "Employee" will be checked if the terminal window is opened.

A Special example:

User "A" logged on in SAP Business One. This user is connected to personnel entry "A".
Personnel "B" opens the Terminal window (not beas in terminal mode)

In this case:  
Authorization according to user "A" + condition from "Terminal Mode - Personnel" for Personal "B"
 

The user has access generally if no entry is deposited.

Beas Terminal mode

In terminal mode, only the field "Personnel" is checked instead of authorization.

The employee has access to all templates if the field is empty in all template definitions.

The employee has only access to the templates in which he is deposited in this list, if at least one field in a template is filled.

If an employee opens a window for the first time, not the default template is used but the first one to which the employee has access. The standard template will be used if no template was found.

Standard Template

The employee has always access to the Standard Template. This has to be deposited.

See Templates – Authorizations

Field

Meaning

Sorting

Sorting on SQL-level

Enter the SQL-fragment following the "ORDER"-statement of the  SQL-command

Example: Item list, sort item descending

OITM.ItemCode desc

Filter

Filter on SQL-level

Enter the SQL-fragment following "WHERE"

Example: item list, only items beginning with A

substring(OITM.ItemCode,1,1)='A'

Sorting (DW)

You can sort within the display after the list was loaded from SQL-server. Use this option, if a sorting on SQL-level is not possible, e.g. if lists are filled using an object or if a SQL-statement was used with "union all"

Sorting is entered in DW-Syntax. See Datawindow-Syntax

Enter ascending sorting with "asc", descending with "desc". Field names are entered in the screen (see Debug-Fenster) and not the SQL-name

Example: sort item number descending, but items of item group "material" first.

if(oitm_u_gruppe='material',1,2) , oitm_itemcode desc

Filter (DW)

Set filter on existing list

Sorting is entered in DW-Syntax. See Datawindow-Syntax

See notes above.

Field

Meaning

Font

Font

Note: use only fonts which are available at all clients

Font size

Font size in PowerUnits (usually between 30 and 100)

Font field height

Determines the number of PowerUnits in a list row

Color

Determines font color

Note: several fields have a fixed color rule or have assigned color from window settings. These settings have a higher priority.

Zoom

The whole view can be magnified or scaled down. Default view is 100% (with default font 10 SAP Business One – general settings)

Background type

Background setting; dependent fields are displayed.

Picture: a tab is displayed to define the background

Solid: In field "Color" a background color can be defined.

xxx-Gradient (= color gradient): the first color is defined under "color". All other properties can be set under "Design" tab.

Color

Only visible if "type" was set to "solid" or "xxx-gradient" determines background color

Field

Meaning

Type

Type of display: original size, distorted, repetition etc.

File

Select image file

NOTE:

It needs to be located on a network drive, accessible from all clients

Transparent

Transparency in % (0 –100%)