Feedback

  • Contents
 

Configure Global Custom Business Rules

Use the Custom tab on the General tab to configure business rules that identify accounts to exclude during imports. Custom business rules only apply to maintenance, financial, and final recall imports. They don't apply to new business imports. Exchange Manager flags accounts that meet the specified criteria with a red exception when processing the import file.

To configure global custom business rules

  1. In the Navigation pane, click Clients.

Clients pane

  1. In the Clients pane, expand the appropriate folder and then double-click the client. The tab for the specified client appears in the Information pane.

General tab

  1. On the General tab in the Global Business Rules section, click the Custom tab.

General tab - Custom tab

  1. Click Add New Custom Business Rule. The Edit Query column indicates "NO DATA."

New Business Rule

  1. Double-click the box next to "NO DATA." The Select Accounts window appears.

Select Accounts window

  1. Specify the conditions for selecting the accounts to exclude from the import. In the previous example, Exchange Manager excludes accounts where the last payment date occurred within the last 30 days. For more information about using queries, see Queries.

  2. Click Save.

Note: We recommend that you create simple conditions. If you combine conditions, the exception message doesn't indicate why Exchange Manager didn't process the account.

  1. On the Custom tab, rest your mouse on the query to view the full SQL statement.

SQL statement

  1. In the Exception Message box, type the exception message to display in red above the account when processing the import file.

 Exception message

  1. Select the import types to which to apply the business rule. For example, if you select Final Recall, Exchange Manager doesn't recall accounts that received a payment in Latitude within the last 30 days.

  2. Add more business rules as necessary and then, in the toolbar, click Save. The Update Comment dialog box appears.

  3. In the Update Comment box, type a comment regarding your changes and then click OK.

Related Topics

Configure Global Account Business Rules

Configure Global Financial Business Rules

Queries

General Configuration