05-12-2026-058-INV-001

{
  "tax": 0,
  "notes": "Invoice total field shows '#VALUE!' (spreadsheet formula error). Per vendor-specific processing notes, the amount shown in the Amount column ($1,300.00) is used as the total. No printed invoice number found; generated using missing-number rule: rui-042125-1300. All line items appear to be bundled under a single lump-sum amount. Tax rate is 0.00% so no tax applied.",
  "terms": null,
  "total": 1300,
  "due_date": null,
  "shipping": 0,
  "subtotal": 1300,
  "confidence": {
    "total": 0.9,
    "vendor_name": 1,
    "invoice_date": 0.95,
    "project_name": 0.85,
    "invoice_number": 1
  },
  "line_items": [
    {
      "qty": null,
      "amount": 1300,
      "unit_price": null,
      "description": "Hallway floor protection with paper masking; type dust control; hung 5/8 drywall ceiling repair floated skim; sand ready for paint; wall small repair hung 1/2 inch drywall floated sand ready for paint; seal with primer one coat affected area; paint the whole ceiling 2 coats; paint the wall affected area 2 coats"
    }
  ],
  "vendor_name": "Ruiz Painting LLC",
  "invoice_date": "2025-04-21",
  "project_name": "2258 Saint Clair Ave, St. Paul MN 55105",
  "document_type": "invoice",
  "invoice_number": "rui-042125-1300",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "cmp1abgyc0068agtbmw3bk4pz",
    "vendor_id": "vend_b9fde06fd72d49f5adf6384719b37923",
    "alias_name": "Ruiz Painting LLC",
    "canonical_name": "Ruiz Painting LLC",
    "category_count": 3,
    "category_options": [
      {
        "name": "Demolition",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Demolition (1).",
        "expense_category_id": "cat_021f38de79874d818ff5b224551d5f6e",
        "fully_qualified_name": "Building Services:Demolition",
        "quickbooks_account_id": "122",
        "vendor_expense_category_id": "cmp1bazj5004013pffnba5vq3"
      },
      {
        "name": "Drywall & Taping",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Drywall & Taping (28).",
        "expense_category_id": "cat_5fe2c67d22934b5c9db2adf0a6ed8237",
        "fully_qualified_name": "Building Services:Drywall & Taping",
        "quickbooks_account_id": "123",
        "vendor_expense_category_id": "cmp1bazlu004213pfwclbkf9u"
      },
      {
        "name": "Painting",
        "notes": "Mapped from JKath historical QuickBooks export: Building Services:Painting (13).",
        "expense_category_id": "cat_5cd8cff9602249029902722ebd6e200d",
        "fully_qualified_name": "Building Services:Painting",
        "quickbooks_account_id": "134",
        "vendor_expense_category_id": "cmp1bazoa004413pf5sxkd2jk"
      }
    ],
    "expense_category_id": null,
    "normalized_alias_key": "ruiz painting llc",
    "quickbooks_vendor_id": "59",
    "quickbooks_account_id": null,
    "default_expense_account": null,
    "invoice_processing_notes": "These invoices often contain \"#VALUE!\" in the \"Total\" section. If this is the case, use the number in the \"Amount\" section as the total.",
    "missing_category_options": false
  }
}

No payload stored.

{
  "run_id": "run_b77a2c3bdd7142029b9907fa8340b984",
  "source": "make.com",
  "run_key": "05-12-2026-058",
  "run_error": {
    "source": "manual_stale_run_cleanup",
    "message": "Make scenario ended before finalizing this run; stale RUNNING run marked failed during cleanup.",
    "run_key": "05-12-2026-058",
    "recorded_at": "2026-05-13T00:38:00.102135+00:00"
  },
  "make_trace_id": "make-20260512_160210_641",
  "source_file_name": "Ruiz Copy of 2258 Saint Clair ave St. Paul Mn_VALIDATION-FAILED.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/Ruiz Copy of 2258 Saint Clair ave St. Paul Mn_VALIDATION-FAILED.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABjcA",
  "source_dropbox_rev": "01651a52cd5ea3f00000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "105599a7b238a29470372f777a8cf77d3962f1e60c0584fd43f6e181fc6f636b",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/Ruiz Copy of 2258 Saint Clair ave St. Paul Mn_VALIDATION-FAILED.pdf",
  "multi_invoice_group_id": "bill_bf9653ebd3e14e6db478e3aca1ae068f",
  "processing_dropbox_rev": "01651a52d5d10f100000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice PDF. The invoice contained a '#VALUE!' error in the Total and Sales Tax fields, consistent with vendor-specific processing notes for Ruiz Painting LLC. Total resolved to $1,300.00 per the Amount column. Invoice number was generated as none was printed on the document.",
    "invoices": [
      {
        "tax": 0,
        "notes": "Invoice total field shows '#VALUE!' (spreadsheet formula error). Per vendor-specific processing notes, the amount shown in the Amount column ($1,300.00) is used as the total. No printed invoice number found; generated using missing-number rule: rui-042125-1300. All line items appear to be bundled under a single lump-sum amount. Tax rate is 0.00% so no tax applied.",
        "terms": null,
        "total": 1300,
        "due_date": null,
        "shipping": 0,
        "subtotal": 1300,
        "confidence": {
          "total": 0.9,
          "vendor_name": 1,
          "invoice_date": 0.95,
          "project_name": 0.85,
          "invoice_number": 1
        },
        "line_items": [
          {
            "qty": null,
            "amount": 1300,
            "unit_price": null,
            "description": "Hallway floor protection with paper masking; type dust control; hung 5/8 drywall ceiling repair floated skim; sand ready for paint; wall small repair hung 1/2 inch drywall floated sand ready for paint; seal with primer one coat affected area; paint the whole ceiling 2 coats; paint the wall affected area 2 coats"
          }
        ],
        "vendor_name": "Ruiz Painting LLC",
        "invoice_date": "2025-04-21",
        "project_name": "2258 Saint Clair Ave, St. Paul MN 55105",
        "document_type": "invoice",
        "invoice_number": "rui-042125-1300",
        "is_billable_invoice": true
      }
    ]
  }
}