Layout Designer: Insert > Conditional Expression dialog

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

Accounting CS enables you to insert conditional expressions for selected elements in the design grid of the Layout Designer to specify content to print only when the criteria for the condition are met.

Inserting a new conditional expression

  1. In the design grid of the Layout Designer, select an element and choose Insert > Conditional Expression.
  2. Use the Condition grid to build a conditional expression.

The following table lists the operators available for the conditional expressions.

Operator Description
= Equal to
<> Not equal to
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
Has data The selected item includes data
Has no data The selected item does not include any data
Contains The selected item contains specified text
Does not contain The selected item does not contain specified text
Notes
  • The operator field in each row of the Condition grid is preceded and followed by text fields. Click the Formula Insert formula button button to insert a formula, variable, amount, or text as part of the conditional expression. To enter static text for a condition to test, be sure to enclose that text within quotation marks.
  • Existing conditional expressions are tagged with a green triangle in the upper-right corner of the element.
  • You can build complex conditions by selecting AND or OR at the end of a row in the grid, which opens another row to add to the condition. Note that you can keep building to the current condition beyond the six visible rows in the Condition grid. When you have filled the six rows, and then select AND or OR at the end of the sixth row, a scrolling region is displayed so that you can add more items to the condition.
  • Multiple tabs are displayed in the Conditional Expression dialog only if more than one condition is set up for the current expression.
  • A new tab is automatically added in the Conditional Expression dialog (for example, Condition 1, Condition 2, and so forth) when you select the Test next condition option.

Action conditions

If true, print

If false . . .

Editing an existing conditional expression

Select an element in the design grid of the Layout Designer where a conditional expression already exists and choose Format > Conditional Expression.

Removing an existing conditional expression

Select an element in the design grid of the Layout Designer where a conditional expression already exists and choose Insert > Remove Conditional Expression.

example icon Example of a conditional expression that prints only if the Net Check amount is greater than zero

If you are designing a check from scratch, you may not want to include several elements in the check when the account is set up for direct deposit. There is a common conditional expression that can be applied to variables such as, Bank Name (Payroll.Check.BankName), Routing number (Payroll.Check.BankRoutingNumber), Signature (Payroll.Check.Images.Signature), and MICR Line (Payroll.Check.MICRLINE) that enable you to print those elements only if the amount for that item is greater than zero. That way, those elements do not show up on zero-amount checks that are direct deposited to the bank. In the following example, we will apply the zero-amount conditional expression to the Net Check Amount variable.

  1. Open a check layout in the Layout Designer.
  2. Click the Payroll.Check.NetPay.NetCheckAmount variable in the check layout.
  3. Choose Insert > Conditional Expression to open the Conditional Expression dialog.
  4. Click the Formula formula button button in the first field of the first row to open the Formula dialog.
  5. Select Payroll > Check > NetPay > Net Check Amount, and then click OK to close the Formula dialog.
  6. In the Conditional Expression dialog, select the greater than (>) sign from the drop-down list in the second column of the first row.
  7. Enter 0 in the third field of the first row, and then click OK. Show me
    conditional expression

Notes

  • You can only use double quotes ("), not single quotes (') when you enter text as part of the conditional expression.
  • You can apply conditional expressions on layout elements such as, a text box, drawing/shape, variable, or a whole repeating region (yellow section).

Related topics

Layout Designer overview

Predefined check layouts overview

Layout Designer procedures

Share This