Reader Last Run Date

Running from a Schedule

IMan maintains a lookup table to keep track of the last date of any query made with the Intacct Reader.

When an Intact Reader successfully completes a record in this table is either updated or added.

The record's key is a combination of three values:

• Transform Hash - This is an unique, non-changing, hidden value assigned to the Intacct Reader's transform.
• System ID - The System Connector ID of the particular reader. Individual records will be created for each connector selector on the Reader.
• Intacct Entity - The Intacct Entity being queried.

Resetting the Last Date/Time

From time-to-time the Intacct Reader will successfully connect and query Intacct recorders, but an error further in the integration processing prevent either some or all records being integrated.

To allow the records to be re-processed the last run date can be reset to a value in the past in conjunction with the matching the parameters from the reader screen modified after that date.

Preventing Record Duplication

Since only the date is recorded, the Intacct Reader will read the same the data if an integration is run more than once on a given day.

If the data is sensitive where duplication may occur (typically transaction type data) a filter transform should be used to query the destination (using a lookup of some sort) and determine if record already exists, and filtering the record from being integrated.