Alert Tables specify which tables can be used in the Alerts module.

This makes it easier for users to create alerts by having a shorter list of tables they can select from. An administrator can add more tables if required.

Alert Tables

To modify which tables are available for use with alerts:

  1. Search for Alert Tables.
  2. Click New and select the Table ID.

Setting Fields available for a table

Default Fields can be used to monitor specific Field changes, filter Alerts when specific Fields match a given value, and will be displayed on Emails distributed from Alerts monitoring this Table.

You can use the Add Fields… action to add multiple Fields at once.

Pages allows you to decide which Page will open to display the related record for an Alert.

Default Pages are normally assigned automatically when creating a new Alert Table. This can be changed in scenarios where there are multiple pages for a given table.

For example, Table Sales Header where both Sales Order and Sales Quote pages are valid options.

Set which fields can be used as a recipient

Recipient Fields allow you to use fields from the Table to send out Alerts and Emails.

For example for the Sales Header you can use the Sell-to Customer No. to send an Alert to the Customer when a Sales Order is raised.

Table-specific events

Events are key points within a Business Central process. Events are used when a table trigger doesn’t provide quite the right point to run an alert.

Alerts comes with a handful of Events that are created during Initialise Defaults (see Initial set up for Alerts Setup), to create your own events see the Creating custom events for triggering Alerts article.

The following Events are included:

TableEventWhen
ItemITEMPOSTAn Item Ledger Entry is created
Stockkeeping UnitSKUPOSTAn Item Ledger Entry is created
CustomerCUSTPOSTA Customer Ledger Entry is created
VendorVENDPOSTA Vendor Ledger Entry is created
BankBANKPOSTA Bank Account Ledger Entry is created
G/L AccountGLPOSTA General Ledger Entry is created
ResourceRESPOSTA Resource Ledger Entry is created