Edit templates

In this screen templates can be created and managed. It is accessible on the right bottom corner of the screen via the Beas icon > Template administration.

Many settings are available and distributed under several tabs. Depending on the window type only selected tabs are available.

Tab

Meaning

General

Basic settings, Title .

Field	Meaning
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

Fields

Up to 6 additional fields can be defined. On SQL-level you can define which information is displayed.

Enter title here.

Below the orange arrow an additional definition is stored. See Definition of fields

Note

The defined fields are displayed right in the list, and by using window settings they can be moved to the desired position. See window setting.

Sorting and Filter

NOTE:

If you switch from a template with sorting to a template without sorting, the filter and sorting are not removed.

A new sorting/filter is available on SQL-level and on window level (DW). Click the orange arrow to transfer the current sorting/filter from the window. That means the list can be sorted clicking on the field header and then this setting can be read and transferred out as SQL- or DW-syntax.

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.

Design

Many parameters can be set for design to make templates more distinguishable.

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

Background

Only visible if "xxx - gradient" was selected in Design – background type.

All additional settings are made here. Every change can be viewed immediately.

Picture

Only visible if "Picture" was selected in Design – Background type.

A background image and the type of display can be defined

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%)

Start Script

Beas – Script is executed after the view was built up. Additional properties can be defined.

Example: Change field and row height for displaying a picture

dw.datawindow.detail.height=180

dw.templatefield1_c.height=180