05-12-2026-031-INV-001

{
  "tax": 41.86,
  "notes": "Vendor branch/store suffix #1657 omitted from vendor_name per rules. Customer order number: 5107 Arden Ave. Job name on invoice: Arden - Roughs. Source Order#: 1504210. Tax jurisdiction: Dakota County. Items SP-SKDIF4GRKMBWD5, SP-SKDIF4GRKTSBGD8, SKD2FLKPVC (x2) were ordered but not shipped (quantity shipped = 0), so they have $0.00 amounts and are excluded from line_items. Master Account Number: 737714.",
  "terms": "Net 10th Prox",
  "total": 557.15,
  "due_date": null,
  "shipping": 0,
  "subtotal": 515.29,
  "confidence": {
    "total": 0.99,
    "vendor_name": 0.99,
    "invoice_date": 0.99,
    "project_name": 0.99,
    "invoice_number": 0.99
  },
  "line_items": [
    {
      "qty": 1,
      "amount": 43.36,
      "unit_price": 43.359,
      "description": "@ 1HDL P/BAL UNIV VLV ONLY (DR10000UNBX)"
    },
    {
      "qty": 1,
      "amount": 43.36,
      "unit_price": 43.359,
      "description": "@ 1HDL P/BAL UNIV VLV ONLY (DR10000UNBX)"
    },
    {
      "qty": 1,
      "amount": 95.1,
      "unit_price": 95.099,
      "description": "@ 3/6 SETTING DIV RI VLV (DR11000)"
    },
    {
      "qty": 1,
      "amount": 140.72,
      "unit_price": 140.722,
      "description": "LF 2HDL LAV/TUB FCT RI VLV WM (DR3500WL)"
    },
    {
      "qty": 1,
      "amount": 192.75,
      "unit_price": 192.749,
      "description": "PVC FS TUB DRN RI KIT (SH653PVC)"
    }
  ],
  "vendor_name": "Ferguson Enterprises LLC",
  "invoice_date": "2025-04-07",
  "project_name": "Arden - Roughs",
  "document_type": "invoice",
  "invoice_number": "1504234",
  "is_billable_invoice": true
}

{
  "alias_lookup": {
    "found": true,
    "alias_id": "alias_1e2f326fecee46f5b955324a2e70975d",
    "vendor_id": "vendor_15ec102255844f479fc29f8cb9362b73",
    "alias_name": "Ferguson Enterprises LLC",
    "canonical_name": "Ferguson Enterprises LLC",
    "category_count": 2,
    "category_options": [
      {
        "name": "Appliances",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Appliances (52).",
        "expense_category_id": "cat_6815fb48c53f4221ad0130eaa34c6238",
        "fully_qualified_name": "Building Materials:Appliances",
        "quickbooks_account_id": "104",
        "vendor_expense_category_id": "cmp1baudl001213pfmu17sj8z"
      },
      {
        "name": "Plumbing",
        "notes": "Mapped from JKath historical QuickBooks export: Building Materials:Plumbing (100).",
        "expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
        "fully_qualified_name": "Building Materials:Plumbing",
        "quickbooks_account_id": "113",
        "vendor_expense_category_id": "cmp1baug5001413pfbfb4fs2m"
      }
    ],
    "expense_category_id": null,
    "normalized_alias_key": "ferguson enterprises llc",
    "quickbooks_vendor_id": "6",
    "quickbooks_account_id": null,
    "default_expense_account": null,
    "invoice_processing_notes": "For Ferguson invoices, choose Building Materials for construction materials, plumbing supplies, fixtures, pipes, valves, and job materials. Choose Purchases only for general resale or non-project purchase invoices when the line items are not construction/job materials.",
    "missing_category_options": false
  },
  "category_selection": {
    "reason": "All line items are plumbing rough-in components: pressure balance universal valves (DR10000UNBX), a diverter rough-in valve (DR11000), a lav/tub faucet rough-in valve (DR3500WL), and a PVC tub drain rough-in kit (SH653PVC). The project context 'Arden - Roughs' further confirms these are rough-in plumbing materials. Per the vendor-specific notes, Ferguson invoices with construction/job plumbing materials map to Building Materials, and the only plumbing subcategory in the allowed list is 'Plumbing' (cat_173f2c1a36d74231bf0b9d9c755c7b0d).",
    "confidence": 0.97,
    "category_name": "Plumbing",
    "expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
    "quickbooks_account_id": "113",
    "selected_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d",
    "selected_expense_category_name": "Plumbing"
  }
}

{
  "lookup": {
    "quickbooks_vendor_id": "6",
    "quickbooks_account_id": "113",
    "existing_quickbooks_bill_id": null
  },
  "bill_created": {
    "path": "multi_category_direct",
    "total": "557.15",
    "due_date": "2025-05-07",
    "doc_number": "1504234",
    "vendor_ref": "6",
    "account_ref": "113",
    "jkath_terms": "Net 30",
    "vendor_terms": "Net 10th Prox",
    "quickbooks_bill_id": "353",
    "resolved_expense_category_id": "cat_173f2c1a36d74231bf0b9d9c755c7b0d"
  },
  "attachment_uploaded": {
    "path": "multi_category_direct",
    "file_name": "",
    "attachment_id": "",
    "quickbooks_bill_id": "353"
  }
}

{
  "run_id": "run_62091358572745b4a9fb86801339837b",
  "source": "make.com",
  "run_key": "05-12-2026-031",
  "make_trace_id": "make-20260512_002952_270",
  "source_file_name": "737714_20250409_30628354_14198516790.pdf",
  "source_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/01 Unprocessed/737714_20250409_30628354_14198516790.pdf",
  "source_dropbox_id": "id:CHX6_xJiKhAAAAAAAABjXw",
  "source_dropbox_rev": "0165198231b41c500000003549f4393",
  "multi_invoice_count": 1,
  "multi_invoice_index": 1,
  "source_content_hash": "f06befa7ec1e9ca1f10ccf82cfb059a1c062d87063515fbc8e76bcb6042c14ee",
  "processing_file_path": "/_01 Client Projects/Jkath/Sample Invoices/05 May Invoices/May 11-17/02 Processing/737714_20250409_30628354_14198516790.pdf",
  "multi_invoice_group_id": "bill_393baff9de7c4ba4aa2fb62c6edf1e17",
  "processing_dropbox_rev": "0165198272a187100000003549f4393",
  "multi_invoice_source_payload": {
    "notes": "Single invoice in this PDF. Ferguson Enterprises LLC branch #1657 located in Golden Valley, MN. Payment remit address is PO Box 802817, Chicago, IL 60680-2817.",
    "invoices": [
      {
        "tax": 41.86,
        "notes": "Vendor branch/store suffix #1657 omitted from vendor_name per rules. Customer order number: 5107 Arden Ave. Job name on invoice: Arden - Roughs. Source Order#: 1504210. Tax jurisdiction: Dakota County. Items SP-SKDIF4GRKMBWD5, SP-SKDIF4GRKTSBGD8, SKD2FLKPVC (x2) were ordered but not shipped (quantity shipped = 0), so they have $0.00 amounts and are excluded from line_items. Master Account Number: 737714.",
        "terms": "Net 10th Prox",
        "total": 557.15,
        "due_date": null,
        "shipping": 0,
        "subtotal": 515.29,
        "confidence": {
          "total": 0.99,
          "vendor_name": 0.99,
          "invoice_date": 0.99,
          "project_name": 0.99,
          "invoice_number": 0.99
        },
        "line_items": [
          {
            "qty": 1,
            "amount": 43.36,
            "unit_price": 43.359,
            "description": "@ 1HDL P/BAL UNIV VLV ONLY (DR10000UNBX)"
          },
          {
            "qty": 1,
            "amount": 43.36,
            "unit_price": 43.359,
            "description": "@ 1HDL P/BAL UNIV VLV ONLY (DR10000UNBX)"
          },
          {
            "qty": 1,
            "amount": 95.1,
            "unit_price": 95.099,
            "description": "@ 3/6 SETTING DIV RI VLV (DR11000)"
          },
          {
            "qty": 1,
            "amount": 140.72,
            "unit_price": 140.722,
            "description": "LF 2HDL LAV/TUB FCT RI VLV WM (DR3500WL)"
          },
          {
            "qty": 1,
            "amount": 192.75,
            "unit_price": 192.749,
            "description": "PVC FS TUB DRN RI KIT (SH653PVC)"
          }
        ],
        "vendor_name": "Ferguson Enterprises LLC",
        "invoice_date": "2025-04-07",
        "project_name": "Arden - Roughs",
        "document_type": "invoice",
        "invoice_number": "1504234",
        "is_billable_invoice": true
      }
    ]
  }
}