# Scenario: Investigating missing transactions

Source: https://developer.avalara.com/transaction-reconciliation/pnc4096219900862/

# Scenario: Investigating missing transactions

Learn how AI-assisted reconciliation identifies missing transactions and provides recommended actions.

This scenario illustrates how the AI assistant analyzes missing transactions and presents structured findings.

**User:**

```
 "Why are there transactions missing from AvaTax for last week?"
```

**AI Response:**

I found 12 transactions in your ERP from last week that don't have matching records in AvaTax. Let me analyze the patterns.

**Analysis complete**:

**API Errors (7 transactions):**

-   These failed during the sync attempt.

    -   4 transactions: Error 309 – `InvalidAddress`

        All ship to "123 Main St" with no city/state

        Customer: ABC Manufacturing (CUST-4521)

    -   2 transactions: Error 300 – `GetTaxError`

        Missing origin address on location "WAREHOUSE-2"

    -   1 transaction: Error 500 – `ServerUnreachable`

        Occurred during maintenance window (Nov 15, 2:00 AM)

-   Not Yet Invoiced (3 transactions):

    These are still in "Sales Order" status in your ERP. They’ll sync automatically when converted to invoices.

-   Excluded by Connector (2 transactions):

    Your connector is configured to exclude "Internal Transfer" document types.

**Recommended Actions**:

-   Fix address for ABC Manufacturing

-   Add origin address to WAREHOUSE-2 location

-   Resync the failed transaction from Nov 15

-   Review "Internal Transfer" exclusion setting