DB Management

Use this tab to manage the databases used by your Kofax AP Agility solution.

The database purging available on this tab does not apply to your vendor master data.

Depending on your configuration, the following groups may be available:

Database Tables

Availability Description

Invoice Status Entries

Always available.

Entries for each document are written to database tables related to the document status, field status, and any invalid reasons.

Invoices in Workflow

Available if there is at least one organization using an ERP connector.

Entries are recorded in multiple tables whenever an invoice is passed to the AP Workflow.

For solutions not using an ERP connector, such as Process Director or MarkView integrations, these tables remain empty.

Master Data Import Log

Available if there is at least one organization using an ERP connector.

Entries are added each time the AP Data Import job is run.

For solutions not using an ERP connector, such as Process Director or MarkView integrations, these tables remain empty.

Invoice Export Log

Available if there is at least one organization using an ERP connector.

Entries are added each time a document is exported via an ERP connector.

For solutions not using an ERP connector, such as Process Director or MarkView integrations, these tables remain empty.

General Log Entries

Available for OPMT and Azure environments only.

This is a single table where log entries are written.

The following settings are available for each of the above database table types:

Number of Entries

The total number of entries in the database.

Oldest

The date of the oldest record in the database.

Newest

The date of the most recent record in the database.

Automatic Purging

Enables you to configure automatic purging of the log. (Default: Cleared)

When selected, the following setting is displayed:

Entries older than X days

Specify which entries are deleted automatically. For example, if you set the value to 7 then database entries older than 7 days will be purged regularly. (Default: 0)

The following buttons are available for the invoice status entries:

Update

Applies any changes made to automatic purging.

Purge Now

When you click this button, the Purge entries before setting is displayed so that you can enter a date.

The following buttons are available:

OK

Immediately removes any records from the database that were written before the specified date.

It is not possible to remove entries from the Invoices in Workflow log that are still in progress. This means that records are removed only if an invoice is exported or canceled.

Cancel

Cancels the purge request.