Interpret Match Status for Position Reconciliation

The Position Recon matches corresponding data for different sets of data sources and inspects field differences for the fields designated for tolerance checks. The matched position, lot, and ledger balance records are assigned a status, based on the severity of the field differences, if any. The status is determined by examining the status of each field reconciled. The status for the matched record is the most severe status for any of the reconciled fields.

For example, a position reconciliation for a matched set of fields is considered out of balance if one or more of the fields are considered out of balance. Conversely, the matched position is considered in balance when all fields reconcile as in balance.

The following lists the position, lot, and ledger balance statuses assigned during reconciliation:

  • Not Reconed (Status 0). Record has not yet been processed for reconciliation.
  • Auto Recon (Status 1). Matched records are the same for all reconciled fields.
  • Auto Recon With Tolerance (Status 2). Matched records have at worst only records that differ within tolerances.
  • Out-of-balance (Status 4). Matched records have one or more fields that equal or exceed the tolerance for that field.
  • Manual Recon (Status 5). Manually match record (Local only). Unmatched records that were manually matched using the manual reconciliation process. See the Manually Resolve Breaks (Local only) section for more information.

The automated reconciliation process assigns all statuses except Manual Recon.