Report Designer: Creating inline conditional expressions for letters

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.

You can use inline conditional expressions to customize predefined letters or to create your own letters in the Report Designer. Using inline conditional expressions in letters enables you to include or exclude information as defined by the criteria of the conditional expressions and provides a time-saving advantage by allowing you to apply them globally across multiple clients in the firm.

Inline conditional expressions consist of formulas that contain standard operators (=, <>, <=, <, >, >=) separated by arguments such as & (and), | (or) that are entered directly into a letter within the design grid.

Show example

Examples of inline conditional expressions

Operator Description
Has Data [HasData(Client.DBAName) ? ("DBA Name has data.")]
Has No Data [HasNoData(Client.DBAName) ? ("DBA Name is blank.")]
Contains [Contains(Client.Name,"test") ? ("Client name contains test.")]
Does Not Contain [DoesNotContain(Client.Name,"abc") ? ("Client name doesn't contain abc.")]
Equals ("="), with the or ("|") argument [Client.CustomFields.Checkbox.Value = "Yes" | Client.CustomFields.Text.Value = "Testing" ? ("The checkbox is yes or the text is testing.")]
Equals ("="), with the and ("&") argument [Client.CustomFields.Checkbox.Value = "Yes" & Client.CustomFields.Text.Value = "Testing" ? ("The checkbox is yes and the text is testing.")]
Greater than or equal to (">=") a number and less than ("<") another number [Client.CustomFields.Number.Value >= 1 & Client.CustomFields.Number.Value < 100 ? ("The number is greater than or equal to 1 and less than 100.")]

To open a letter for editing, choose File > Report Designer, click the plus (+) sign next to the Letters folder in the Letters list frame to expand the list, and then double-click a letter to open it in the design grid.

Recommended: Prior to making changes to a report (including letters and financial statements) in the Report Designer, choose File > Save As to save the report with a different name. (To restore a predefined report in which changes have been made, you can choose File > Restore Default.)

The examples below include commonly used conditional expressions.

Example: Changing the salutation based on the client’s entity type

Compilation Letter

This inline conditional expression changes the salutation based on the client's entity type. (The default greeting used in the application is To the Board of Directors.)


[Client.EntityType.Entity = "1120S" ? ("To the shareholders")][Client.EntityType.Entity = "1065" ? ("To the partners")][Client.EntityType.Entity = "1120" | Client.EntityType.Entity = "990" | Client.EntityType.Entity = "990PF" ? ("To the board of directors")]


Result: One of the following salutations is displayed in the Compilation Letter.

Example: Displaying a different value based on a client custom field

Compilation Letter

The following inline conditional expression is based on the value of a client custom field variable. (Also see:

See also: See Creating list entries for custom fields.)

  1. Choose Setup > Custom Fields > Clients and add a Type List with Item IDs as shown in the following illustration.

  2. Choose Setup > Client and enter the appropriate data for the custom fields, as shown in the following illustration.

  3. Replace the words balance sheet in the first paragraph of the letter with the following inline conditional expression, adjusting the fonts, as needed.

    [Client.CustomFields.Basis.Value = "US GAAP" ? ("balance sheet")][Client.CustomFields.Basis.Value = "Tax, Cash" | Client.CustomFields.Basis.Value = "Tax, Accrual" ? ("statement of assets, liabilities, and equity—income tax basis")]

    Result 1

    The following changes in the paragraph result when the client custom code is US GAAP.

    Result 2

    The following changes in the paragraph result when the client custom codes are Tax, Cash or Tax, Accrual.

Related topics

Reporting and Report Designer: Procedures

Letters

Creating a new report, financial statement, or letter

Sharing a custom report, statement, or layout via the Accounting CS Ideas Community

Share This