<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv9502m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Conditional Formatting (ttadv9502m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 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.</Paragraph>
			<Paragraph class="Default">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.</Paragraph>
			<List><ListIntro>You can define various types of conditions, both simple and more complicated. For example:</ListIntro>
				<ListItem>In the <GUIRef href="/baanerp/ti/sfc/tisfc0501m000" role="session">Production Orders (tisfc0501m000)</GUIRef> session, all production orders with Order Status "Closed" must be displayed on a green back ground.</ListItem>
				<ListItem>In the <GUIRef href="/baanerp/td/sls/tdsls4100m000" role="session">Sales Orders (tdsls4100m000)</GUIRef> 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.</ListItem>
			</List>
		</AimSection>
		<GeneralSection><List><ListTitle>Points of attention</ListTitle>
				<ListItem>This session only runs in WebTop.</ListItem>
				<ListItem>Conditional formatting is only supported in WebTop. WorkTop users will not see the formats defined for a session.</ListItem>
				<ListItem>You can only define formats if the <GUIRef href="/baanerp/tt/ams/ttams1110m000#ttams110.cufi" role="manual">Application Personalization</GUIRef> check box in your user data template properties on the ERP LN server ( <GUIRef href="/baanerp/tt/ams/ttams1110m000" role="session">User Data Template (ttams1110m000)</GUIRef> session) is selected.</ListItem>
				<ListItem>Via the <GUIRef href="" role="menu">Specific</GUIRef> 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.</ListItem>
				<ListItem>You can start this session in multiple ways: <List><ListItem>From the <GUIRef href="" role="manual">View</GUIRef> menu in a session you started in WebTop.</ListItem>
						<ListItem>Directly, for example from the ERP LN <GUIRef href="" role="manual">Tools</GUIRef> menu or through the <GUIRef href="" role="manual">Run Program</GUIRef> command in the WebTop <GUIRef href="" role="manual">Tools</GUIRef> menu.</ListItem>
					</List>
				</ListItem>
			</List>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic>"Conditional Formatting" in the WebTop online help</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="ttadv902.cpac"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Session</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> code of the session for which the format is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv902.cmod"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Session</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#100004" role="glossary">module</Link> code of the session.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv902.cses"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Session</Title>
			</Header>
			<FuncDesc>The session's code.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv902.sest"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Session Type</Title>
			</Header>
			<FuncDesc>A session can run in various modes. This field indicates the session mode the conditional format applies to.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Select one of the following:</Paragraph>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">All</TD>
							<TD rowspan="1" colspan="1">The conditional format is applied in all situations, regardless of the mode in which the session runs.</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Overview</TD>
							<TD rowspan="1" colspan="1">The conditional format is applied only if the sessions runs as an overview session.</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Details</TD>
							<TD rowspan="1" colspan="1">The conditional format is applied only if the sessions runs as a details session.</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Zoom</TD>
							<TD rowspan="1" colspan="1">The conditional format is applied only if the sessions runs as a zoom session.</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Satellite</TD>
							<TD rowspan="1" colspan="1">The conditional format is applied only if the sessions runs as a satellite in a multi-main table (MMT) session.</TD>
						</TR>
					</TBODY>
				</TABLE>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="company.option"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Company</Title>
			</Header>
			<FuncDesc>The companies the format applies to</FuncDesc>
			<SimpleSection><Paragraph class="Default">Select one of the following:</Paragraph>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">All</TD>
							<TD rowspan="1" colspan="1">The conditional format is applied in all companies.</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Company</TD>
							<TD rowspan="1" colspan="1">The conditional format is only applied if the session runs in a specified company.</TD>
						</TR>
					</TBODY>
				</TABLE>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv902.comp"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Company</Title>
			</Header>
			<FuncDesc>The company the format applies to.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv902.levl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Creation Level</Title>
			</Header>
			<FuncDesc>Select one of the following:</FuncDesc>
			<SimpleSection><TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">User</TD>
							<TD rowspan="1" colspan="1">The conditional format applies only to the user that is specified in the <GUIRef href="/baanerp/tt/adv/ttadv9502m000#ttadv902.user" role="manual">User</GUIRef> field.</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">System</TD>
							<TD rowspan="1" colspan="1">The conditional format applies to all users.</TD>
						</TR>
					</TBODY>
				</TABLE>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListItem>If you start this session from the <GUIRef href="" role="manual">View</GUIRef> menu in another session, you can only create User formats that apply to your own user account.</ListItem>
					<ListItem>To create a System format, you must start this session directly, for example from the ERP LN <GUIRef href="" role="manual">Tools</GUIRef> menu or through the <GUIRef href="" role="manual">Run Program</GUIRef> command in the WebTop <GUIRef href="" role="manual">Tools</GUIRef> menu.</ListItem>
					<ListItem>Only super users can create System formats. Normal users can only create formats that apply to their own user account.</ListItem>
				</List>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv902.user"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">User</Title>
			</Header>
			<FuncDesc>The user the format applies to.</FuncDesc>
			<SimpleSection><Paragraph class="Default">For System formats the field is filled with a "^".</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldGroup><Title>Conditions</Title>
			<FieldHelp ID="ttadv902.desc"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Description</Title>
				</Header>
				<FuncDesc>The description of the conditional format.</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="ttadv902.enab"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Enabled</Title>
				</Header>
				<FuncDesc>
                                    If this check box is selected, the format is applied automatically when the session, for which the format is defined, is started.</FuncDesc>
				<SimpleSection><Paragraph class="Default">
                                       If this check box is cleared, the format is not started automatically. Users can enable the format through the session's <GUIRef href="" role="manual">View</GUIRef> menu.</Paragraph>
				</SimpleSection>
			</FieldHelp>
			<FieldHelp ID="field1"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field Name</Title>
				</Header>
				<FuncDesc>The field on which the condition is based. You can zoom to select one of the session's fields.</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="ttadv902.opeq"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Comparison Operator</Title>
				</Header>
				<FuncDesc>A comparison operator to compare the field with the field or value specified in the next field.</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="field2"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field Name/Value</Title>
				</Header>
				<FuncDesc>The field or value the first field is compared to.</FuncDesc>
				<SimpleSection><Paragraph class="Default">You can compare the field to a fixed value or to another field in the session. You can zoom to select the second field.</Paragraph>
					<List><ListTitle>Notes</ListTitle>
						<ListItem>If the field is an enumerate, you can zoom to select an enumerated constant.</ListItem>
						<ListItem>To compare a string field to a fixed value, the value must be surrounded by quotes.</ListItem>
						<ListItem>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, &gt;=0 (later than now), +1 (tomorrow), -7 (1 week ago), or -365 (1 year ago).</ListItem>
						<ListItem>You can check whether a field is empty. For example: <List><ListItem>&lt;date field&gt; = 0</ListItem>
								<ListItem>&lt;string field&gt; =</ListItem>
							</List>
						</ListItem>
					</List>
					<Paragraph class="Default">See the following examples:</Paragraph>
					<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><THEAD><TR><TD rowspan="1" colspan="1">Field Name</TD>
								<TD rowspan="1" colspan="1">Comparison Operator</TD>
								<TD rowspan="1" colspan="1">Field Name/Value</TD>
							</TR>
						</THEAD>
						<TBODY><TR><TD rowspan="1" colspan="1">Order Amount</TD>
								<TD rowspan="1" colspan="1">&gt;</TD>
								<TD rowspan="1" colspan="1">10000</TD>
							</TR>
							<TR><TD rowspan="1" colspan="1">Search Key</TD>
								<TD rowspan="1" colspan="1">&gt;=</TD>
								<TD rowspan="1" colspan="1">"C"</TD>
							</TR>
							<TR><TD rowspan="1" colspan="1">Search Key</TD>
								<TD rowspan="1" colspan="1">=</TD>
								<TD rowspan="1" colspan="1"></TD>
							</TR>
							<TR><TD rowspan="1" colspan="1">Order Status</TD>
								<TD rowspan="1" colspan="1">=</TD>
								<TD rowspan="1" colspan="1">Closed</TD>
							</TR>
							<TR><TD rowspan="1" colspan="1">Order Date</TD>
								<TD rowspan="1" colspan="1">&lt;</TD>
								<TD rowspan="1" colspan="1">-365</TD>
							</TR>
							<TR><TD rowspan="1" colspan="1">Planned Delivery Date</TD>
								<TD rowspan="1" colspan="1">&gt;</TD>
								<TD rowspan="1" colspan="1">Requested Delivery Date</TD>
							</TR>
							<TR><TD rowspan="1" colspan="1">Planned Delivery Date</TD>
								<TD rowspan="1" colspan="1">=</TD>
								<TD rowspan="1" colspan="1">0</TD>
							</TR>
						</TBODY>
					</TABLE>
				</SimpleSection>
			</FieldHelp>
			<FieldHelp ID="ttadv902.opar"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Arithmetic Operator</Title>
				</Header>
				<FuncDesc>Select an arithmetic operator if you want to combine the field or value entered in the previous <GUIRef href="/baanerp/tt/adv/ttadv9502m000#field2" role="manual">Field Name/Value</GUIRef> field with another field or value.</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="ttadv902.fld3"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field Name/Value</Title>
				</Header>
				<FuncDesc>Select a field or enter a value to combine with the field and operator entered in the previous 2 fields.</FuncDesc>
				<SimpleSection><Paragraph class="Default">See the following example:</Paragraph>
					<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><THEAD><TR><TD rowspan="1" colspan="1">Field Name</TD>
								<TD width="88" rowspan="1" colspan="1">
									<Paragraph class="Default">Comparison Operator</Paragraph>
								</TD>
								<TD width="177" rowspan="1" colspan="1">Field Name/Value</TD>
								<TD width="76" rowspan="1" colspan="1">Arithmetic Operator</TD>
								<TD width="133" rowspan="1" colspan="1">Field Name/Value</TD>
							</TR>
						</THEAD>
						<TBODY><TR><TD rowspan="1" colspan="1">Cost Price</TD>
								<TD width="88" rowspan="1" colspan="1">&gt;</TD>
								<TD width="177" rowspan="1" colspan="1">Material Costs</TD>
								<TD width="76" rowspan="1" colspan="1">+</TD>
								<TD width="133" rowspan="1" colspan="1">Operation Costs</TD>
							</TR>
							<TR><TD rowspan="1" colspan="1">Planned Delivery Date</TD>
								<TD width="88" rowspan="1" colspan="1">&gt;</TD>
								<TD width="177" rowspan="1" colspan="1">Requested Delivery Date</TD>
								<TD width="76" rowspan="1" colspan="1">+</TD>
								<TD width="133" rowspan="1" colspan="1">432000 (43200 seconds is 5 days)</TD>
							</TR>
						</TBODY>
					</TABLE>
				</SimpleSection>
			</FieldHelp>
		</FieldGroup>
		<FieldGroup><Title>Coloring</Title>
			<FieldHelp ID="ttadv902.ffld"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Color Field</Title>
				</Header>
				<FuncDesc>
                                    If this check box is selected, you can specify color settings for a specific field.</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="color.field"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Color Field</Title>
				</Header>
				<FuncDesc>The field for which you want to define the color(s).</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="ttadv902.ffor"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Foreground Color</Title>
				</Header>
				<FuncDesc>Select this check box if you want to apply a color to the characters displayed in the selected field.</FuncDesc>
				<SimpleSection><Paragraph class="Default">To select a color, click <GUIRef href="/baanerp/tt/adv/ttadv9502m000#start.color.dialog.for" role="command">Color</GUIRef>.</Paragraph>
				</SimpleSection>
			</FieldHelp>
			<FieldHelp ID="ttadv902.ffco"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Foreground Color</Title>
				</Header>
				<FuncDesc>A number that represents the selected color.</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="ttadv902.fbck"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Background Color</Title>
				</Header>
				<FuncDesc>Select this check box if you want to apply a background color to the selected field.</FuncDesc>
				<SimpleSection><Paragraph class="Default">To select a color, click <GUIRef href="/baanerp/tt/adv/ttadv9502m000#start.color.dialog.bck" role="command">Color</GUIRef>.</Paragraph>
				</SimpleSection>
			</FieldHelp>
			<FieldHelp ID="ttadv902.fbco"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Background Color</Title>
				</Header>
				<FuncDesc>A number that represents the selected color.</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="ttadv902.frow"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Color Row</Title>
				</Header>
				<FuncDesc>Select this check box if you want to apply a color to the rows that meet the condition.</FuncDesc>
				<SimpleSection><Paragraph class="Default">To select a color, click <GUIRef href="/baanerp/tt/adv/ttadv9502m000#start.color.dialog.row" role="command">Color</GUIRef>.</Paragraph>
				</SimpleSection>
			</FieldHelp>
			<FieldHelp ID="ttadv902.frco"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Color Row</Title>
				</Header>
				<FuncDesc>A number that represents the selected color.</FuncDesc>
			</FieldHelp>
			<FieldHelp ID="ttadv902.fico"><Header>
					<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Warning Icon</Title>
				</Header>
				<FuncDesc>
                                    If this check box is selected, a warning symbol is displayed at the beginning of each row that meets the condition.</FuncDesc>
			</FieldHelp>
		</FieldGroup>
	</Fields>
	<FormCommands><CommandHelp ID="fuf.export"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Export</Title>
			</Header>
			<FuncDesc>Starts the <Link href="/baanerp/tt/adv/ttadv9402s000" role="session">Export Conditional Formats (ttadv9402s000)</Link> session.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="fuf.import"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Import</Title>
			</Header>
			<FuncDesc>Starts a dialog that enables you to import formats from an XML file.</FuncDesc>
		</CommandHelp>
	</FormCommands>
</Session>
