| Conditional Formatting (ttadv9502m000) |  |
| Use this session to define conditions to apply special formatting effects to the data displayed in ERP LN sessions. You can define multiple conditions per session. You can define different types of formatting effects, for example a specific color for particular fields or rows, and a warning symbol for particular rows. You can define various types of conditions, both simple and more complicated. For example: In the Production Orders (tisfc0501m000) session, all production orders with Order Status "Closed" must be displayed on a green back ground. In the Sales Orders (tdsls4100m000) session, a warning symbol must be displayed and the order Amount must be displayed on a blue background, for all sales orders with an order amount greater than 10000. Points of attention This session only runs in Web UI. Conditional formatting is only supported in Web UI. WorkTop users will not see the formats defined for a session. You can only define formats if the Application Personalization check box in your user data template properties on the ERP LN server ( User Data Template (ttams1110m000) session) is selected. Via the Specific menu, super users can export formats to an XML file and import formats from an XML file. In this way a super user can distribute formats to multiple ERP LN environments. You can start this session in multiple ways: From the View menu in a session you started in Web UI. Directly, for example from the ERP LN Tools menu or through the Run Program command in the Web UI Tools menu. Related topics "Conditional Formatting" in the Web UI documentation
Fields | Description
Session | The package code of the session for which the format is defined.
Session | The module code of the session.
Session | The session's code.
Session Type | A session can run in various modes. This field indicates the session mode the conditional format applies to. Select one of the following:
All | The conditional format is applied in all situations, regardless of the mode in which the session runs.
Overview | The conditional format is applied only if the sessions runs as an overview session.
Details | The conditional format is applied only if the sessions runs as a details session.
Zoom | The conditional format is applied only if the sessions runs as a zoom session.
Satellite | The conditional format is applied only if the sessions runs as a satellite in a multi-main table (MMT) session.
Company | The companies the format applies to Select one of the following:
All | The conditional format is applied in all companies.
Company | The conditional format is only applied if the session runs in a specified company.
Company | The company the format applies to.
Creation Level | Select one of the following:
User | The conditional format applies only to the user that is specified in the User field.
System | The conditional format applies to all users.
Note If you start this session from the View menu in another session, you can only create User formats that apply to your own user account. To create a System format, you must start this session directly, for example from the ERP LN Tools menu or through the Run Program command in the Web UI Tools menu. Only super users can create System formats. Normal users can only create formats that apply to their own user account.
User | The user the format applies to. For System formats the field is filled with a "^".
Conditions
Description | The description of the conditional format.
Enabled | If this check box is selected, the format is applied automatically when the session, for which the format is defined, is started. If this check box is cleared, the format is not started automatically. Users can enable the format through the session's View menu.
Field Name | The field on which the condition is based. You can zoom to select one of the session's fields.
Comparison Operator | A comparison operator to compare the field with the field or value specified in the next field.
Field Name/Value | The field or value the first field is compared to. You can compare the field to a fixed value or to another field in the session. You can zoom to select the second field. Notes If the field is an enumerate, you can zoom to select an enumerated constant. To compare a string field to a fixed value, the value must be surrounded by quotes. You cannot compare a date field or a UTC field to a fixed date. You must always compare to a relative date. You can enter, for example: `>=-0` or `>=+0` (later than now) The `+` or `-` is mandatory. If you specify a `0` without a `+` or `-`, the `0` is considered as an absolute value. In that case the filter checks whether the field is empty. `+1` (tomorrow) `-7` (1 week ago) `-365` (1 year ago) You can check whether a field is empty. For example: <date field> = 0 <string field> = See the following examples:
Field Name | Comparison Operator | Field Name/Value
Order Amount | > | 10000
Search Key | >= | "C"
Search Key | = |
Order Status | = | Closed
Order Date | < | -365
Planned Delivery Date | > | Requested Delivery Date
Planned Delivery Date | = | 0
Arithmetic Operator | Select an arithmetic operator if you want to combine the field or value entered in the previous Field Name/Value field with another field or value.
Field Name/Value | Select a field or enter a value to combine with the field and operator entered in the previous 2 fields. See the following example:
Field Name | Comparison Operator | Field Name/Value | Arithmetic Operator | Field Name/Value
Cost Price | > | Material Costs | + | Operation Costs
Planned Delivery Date | > | Requested Delivery Date | + | 432000 (43200 seconds is 5 days)
Coloring
Color Field | If this check box is selected, you can specify color settings for a specific field.
Color Field | The field for which you want to define the color(s).
Foreground Color | Select this check box if you want to apply a color to the characters displayed in the selected field. To select a color, click Color.
Foreground Color | A number that represents the selected color.
Background Color | Select this check box if you want to apply a background color to the selected field. To select a color, click Color.
Background Color | A number that represents the selected color.
Color Row | Select this check box if you want to apply a color to the rows that meet the condition. To select a color, click Color.
Color Row | A number that represents the selected color.
Warning Icon | If this check box is selected, a warning symbol is displayed at the beginning of each row that meets the condition.
Commands | Description
Export | Starts the Export Conditional Formats (ttadv9402s000) session.
Import | Starts a dialog that enables you to import formats from an XML file.