Execution Details COMPLETED

Automated Invoice Processing Workflow

View Workflow Back to Executions

Execution Information

Execution ID: c333eced-08e7-46ee-905b-1412c8fe39ed

Workflow ID: invoice_processing_workflow

Status: COMPLETED

Started: 2025-07-16 03:46:41

Completed: N/A

Duration:

Quick Actions

View JSON

Execution Inputs

{
  "EXECUTION_ID": "c333eced-08e7-46ee-905b-1412c8fe39ed",
  "execution_id": "c333eced-08e7-46ee-905b-1412c8fe39ed",
  "image_url_data": "https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/sample_docs/batch1-0001.jpg",
  "notification_email": "finance@company.com"
}

Execution Outputs

Workflow Execution Summary

Mode: Distributed
Tasks: 5/6
Duration: N/A
Dependencies: No

Started: 2025-07-16 03:46:41
Ended: 2025-07-16 03:47:00
Status: FAILED

Task Results & Logs

post_to_sap

COMPLETED

Duration: Calculating...
Dependencies: No

Thread: N/A
Started: 03:46:58

validate_data

COMPLETED

Duration: Calculating...
Dependencies: No

Thread: N/A
Started: 03:46:57

ocr_processing

SUCCESS

Duration: Calculating...
Dependencies: No

Thread: N/A
Started: 03:46:42

generate_summary

COMPLETED

Duration: Calculating...
Dependencies: No

Thread: N/A
Started: 03:46:58

upload_to_supabase

COMPLETED

Duration: Calculating...
Dependencies: No

Thread: N/A
Started: 03:46:58

extract_invoice_data

COMPLETED

Duration: Calculating...
Dependencies: No

Thread: N/A
Started: 03:46:50

Complete Execution Output (JSON):

{
  "execution_summary": {
    "completed_tasks": 5,
    "dependencies_detected": false,
    "end_time": "2025-07-16T03:47:00.837385",
    "execution_mode": "distributed",
    "start_time": "2025-07-16T03:46:41.510424",
    "total_tasks": 6
  },
  "extract_invoice_data": {
    "agent_type": "assistant",
    "ai_response": "{\n  \"vendor_name\": \"Andrews, Kirby and Valdez\",\n  \"invoice_number\": \"51109338\",\n  \"date\": \"2013-04-13\",\n  \"po_number\": null,\n  \"amount\": 6204.19,\n  \"line_items\": [\n    {\n      \"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\",\n      \"quantity\": 3,\n      \"price\": 209.00,\n      \"total\": 627.00\n    },\n    {\n      \"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\",\n      \"quantity\": 5,\n      \"price\": 37.75,\n      \"total\": 188.75\n    },\n    {\n      \"description\": \"gaming pc desktop computer\",\n      \"quantity\": 1,\n      \"price\": 400.00,\n      \"total\": 400.00\n    },\n    {\n      \"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\",\n      \"quantity\": 3,\n      \"price\": 464.89,\n      \"total\": 1394.67\n    },\n    {\n      \"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\",\n      \"quantity\": 5,\n      \"price\": 221.99,\n      \"total\": 1109.95\n    },\n    {\n      \"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\",\n      \"quantity\": 4,\n      \"price\": 269.95,\n      \"total\": 1079.80\n    },\n    {\n      \"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\",\n      \"quantity\": 5,\n      \"price\": 168.00,\n      \"total\": 840.00\n    }\n  ]\n}",
    "execution_details": {
      "actual_result": {
        "agent_type": "assistant",
        "execution_details": {
          "agent_type": "assistant",
          "input_length": 1400,
          "model": "gpt-4o-mini",
          "output_length": 1366,
          "provider": "openai",
          "system_message": "Extract only these key fields from the OCR text. Return ONLY a JSON object:\n{\n  \"vendor_name\": \"extracted vendor name or null\",\n  \"invoice_number\": \"extracted invoice number or null\",\n  \"date\": \"YYYY-MM-DD format or null\",\n  \"po_number\": \"extracted PO number or null\", \n  \"amount\": \"numeric amount or null\",\n  \"line_items\": [\n    {\n      \"description\": \"item description\",\n      \"quantity\": \"numeric quantity\",\n      \"price\": \"numeric price\",\n      \"total\": \"numeric total\"\n    }\n  ]\n}\n"
        },
        "input_format": "json",
        "model_client_id": "invoice_extractor",
        "output": "{\n  \"vendor_name\": \"Andrews, Kirby and Valdez\",\n  \"invoice_number\": \"51109338\",\n  \"date\": \"2013-04-13\",\n  \"po_number\": null,\n  \"amount\": 6204.19,\n  \"line_items\": [\n    {\n      \"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\",\n      \"quantity\": 3,\n      \"price\": 209.00,\n      \"total\": 627.00\n    },\n    {\n      \"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\",\n      \"quantity\": 5,\n      \"price\": 37.75,\n      \"total\": 188.75\n    },\n    {\n      \"description\": \"gaming pc desktop computer\",\n      \"quantity\": 1,\n      \"price\": 400.00,\n      \"total\": 400.00\n    },\n    {\n      \"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\",\n      \"quantity\": 3,\n      \"price\": 464.89,\n      \"total\": 1394.67\n    },\n    {\n      \"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\",\n      \"quantity\": 5,\n      \"price\": 221.99,\n      \"total\": 1109.95\n    },\n    {\n      \"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\",\n      \"quantity\": 4,\n      \"price\": 269.95,\n      \"total\": 1079.80\n    },\n    {\n      \"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\",\n      \"quantity\": 5,\n      \"price\": 168.00,\n      \"total\": 840.00\n    }\n  ]\n}\n__OUTPUTS__ {\"ai_response\": \"{\\n  \\\"vendor_name\\\": \\\"Andrews, Kirby and Valdez\\\",\\n  \\\"invoice_number\\\": \\\"51109338\\\",\\n  \\\"date\\\": \\\"2013-04-13\\\",\\n  \\\"po_number\\\": null,\\n  \\\"amount\\\": 6204.19,\\n  \\\"line_items\\\": [\\n    {\\n      \\\"description\\\": \\\"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\\\",\\n      \\\"quantity\\\": 3,\\n      \\\"price\\\": 209.00,\\n      \\\"total\\\": 627.00\\n    },\\n    {\\n      \\\"description\\\": \\\"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 37.75,\\n      \\\"total\\\": 188.75\\n    },\\n    {\\n      \\\"description\\\": \\\"gaming pc desktop computer\\\",\\n      \\\"quantity\\\": 1,\\n      \\\"price\\\": 400.00,\\n      \\\"total\\\": 400.00\\n    },\\n    {\\n      \\\"description\\\": \\\"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\\\",\\n      \\\"quantity\\\": 3,\\n      \\\"price\\\": 464.89,\\n      \\\"total\\\": 1394.67\\n    },\\n    {\\n      \\\"description\\\": \\\"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 221.99,\\n      \\\"total\\\": 1109.95\\n    },\\n    {\\n      \\\"description\\\": \\\"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\\\",\\n      \\\"quantity\\\": 4,\\n      \\\"price\\\": 269.95,\\n      \\\"total\\\": 1079.80\\n    },\\n    {\\n      \\\"description\\\": \\\"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 168.00,\\n      \\\"total\\\": 840.00\\n    }\\n  ]\\n}\", \"model_client_id\": \"invoice_extractor\", \"agent_type\": \"assistant\", \"model\": \"gpt-4o-mini\", \"provider\": \"openai\", \"status\": \"completed\", \"token_usage\": {\"prompt_tokens\": 683, \"completion_tokens\": 451, \"total_tokens\": 1134, \"estimated_cost\": {\"amount\": 0.000373, \"currency\": \"USD\"}, \"model\": \"gpt-4o-mini\", \"provider\": \"openai\"}}",
        "output_format": "json",
        "return_code": 0,
        "status": "completed",
        "stderr": "",
        "token_usage": {
          "completion_tokens": 451,
          "estimated_cost": {
            "amount": 0.000373,
            "currency": "USD"
          },
          "model": "gpt-4o-mini",
          "prompt_tokens": 683,
          "provider": "openai",
          "total_tokens": 1134
        }
      },
      "duration_seconds": 6.824267,
      "end_time": "2025-07-16T03:46:57.809140",
      "message_sent": true,
      "start_time": "2025-07-16T03:46:50.984873",
      "timestamp": "2025-07-16T03:46:57.809140",
      "worker_executed": true,
      "workers_notified": true
    },
    "model": "gpt-4o-mini",
    "model_client_id": "invoice_extractor",
    "output": "{\n  \"vendor_name\": \"Andrews, Kirby and Valdez\",\n  \"invoice_number\": \"51109338\",\n  \"date\": \"2013-04-13\",\n  \"po_number\": null,\n  \"amount\": 6204.19,\n  \"line_items\": [\n    {\n      \"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\",\n      \"quantity\": 3,\n      \"price\": 209.00,\n      \"total\": 627.00\n    },\n    {\n      \"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\",\n      \"quantity\": 5,\n      \"price\": 37.75,\n      \"total\": 188.75\n    },\n    {\n      \"description\": \"gaming pc desktop computer\",\n      \"quantity\": 1,\n      \"price\": 400.00,\n      \"total\": 400.00\n    },\n    {\n      \"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\",\n      \"quantity\": 3,\n      \"price\": 464.89,\n      \"total\": 1394.67\n    },\n    {\n      \"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\",\n      \"quantity\": 5,\n      \"price\": 221.99,\n      \"total\": 1109.95\n    },\n    {\n      \"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\",\n      \"quantity\": 4,\n      \"price\": 269.95,\n      \"total\": 1079.80\n    },\n    {\n      \"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\",\n      \"quantity\": 5,\n      \"price\": 168.00,\n      \"total\": 840.00\n    }\n  ]\n}\n__OUTPUTS__ {\"ai_response\": \"{\\n  \\\"vendor_name\\\": \\\"Andrews, Kirby and Valdez\\\",\\n  \\\"invoice_number\\\": \\\"51109338\\\",\\n  \\\"date\\\": \\\"2013-04-13\\\",\\n  \\\"po_number\\\": null,\\n  \\\"amount\\\": 6204.19,\\n  \\\"line_items\\\": [\\n    {\\n      \\\"description\\\": \\\"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\\\",\\n      \\\"quantity\\\": 3,\\n      \\\"price\\\": 209.00,\\n      \\\"total\\\": 627.00\\n    },\\n    {\\n      \\\"description\\\": \\\"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 37.75,\\n      \\\"total\\\": 188.75\\n    },\\n    {\\n      \\\"description\\\": \\\"gaming pc desktop computer\\\",\\n      \\\"quantity\\\": 1,\\n      \\\"price\\\": 400.00,\\n      \\\"total\\\": 400.00\\n    },\\n    {\\n      \\\"description\\\": \\\"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\\\",\\n      \\\"quantity\\\": 3,\\n      \\\"price\\\": 464.89,\\n      \\\"total\\\": 1394.67\\n    },\\n    {\\n      \\\"description\\\": \\\"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 221.99,\\n      \\\"total\\\": 1109.95\\n    },\\n    {\\n      \\\"description\\\": \\\"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\\\",\\n      \\\"quantity\\\": 4,\\n      \\\"price\\\": 269.95,\\n      \\\"total\\\": 1079.80\\n    },\\n    {\\n      \\\"description\\\": \\\"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 168.00,\\n      \\\"total\\\": 840.00\\n    }\\n  ]\\n}\", \"model_client_id\": \"invoice_extractor\", \"agent_type\": \"assistant\", \"model\": \"gpt-4o-mini\", \"provider\": \"openai\", \"status\": \"completed\", \"token_usage\": {\"prompt_tokens\": 683, \"completion_tokens\": 451, \"total_tokens\": 1134, \"estimated_cost\": {\"amount\": 0.000373, \"currency\": \"USD\"}, \"model\": \"gpt-4o-mini\", \"provider\": \"openai\"}}",
    "provider": "openai",
    "return_code": 0,
    "status": "completed",
    "stderr": "",
    "task_id": "extract_invoice_data",
    "token_usage": {
      "completion_tokens": 451,
      "estimated_cost": {
        "amount": 0.000373,
        "currency": "USD"
      },
      "model": "gpt-4o-mini",
      "prompt_tokens": 683,
      "provider": "openai",
      "total_tokens": 1134
    }
  },
  "generate_summary": {
    "amount": 6204.19,
    "automation_level": "fully_automated",
    "execution_details": {
      "actual_result": {
        "output": "Generating summary for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_amount\nProcessing summary generated\nStatus: completed\nInvoice: 51109338\n__OUTPUTS__ {\"processing_status\": \"completed\", \"invoice_number\": \"51109338\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"amount\": 6204.19, \"po_number\": null, \"line_items_count\": 7, \"sap_document\": \"51502037\", \"processing_time\": \"5 minutes\", \"automation_level\": \"fully_automated\"}\n",
        "return_code": 0,
        "status": "completed",
        "stderr": ""
      },
      "duration_seconds": 0.159634,
      "end_time": "2025-07-16T03:46:58.374672",
      "message_sent": true,
      "start_time": "2025-07-16T03:46:58.215038",
      "timestamp": "2025-07-16T03:46:58.374672",
      "worker_executed": true,
      "workers_notified": true
    },
    "invoice_number": "51109338",
    "line_items_count": 7,
    "output": "Generating summary for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_amount\nProcessing summary generated\nStatus: completed\nInvoice: 51109338\n__OUTPUTS__ {\"processing_status\": \"completed\", \"invoice_number\": \"51109338\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"amount\": 6204.19, \"po_number\": null, \"line_items_count\": 7, \"sap_document\": \"51502037\", \"processing_time\": \"5 minutes\", \"automation_level\": \"fully_automated\"}\n",
    "po_number": null,
    "processing_status": "completed",
    "processing_time": "5 minutes",
    "return_code": 0,
    "sap_document": "51502037",
    "status": "completed",
    "stderr": "",
    "task_id": "generate_summary",
    "vendor_name": "Andrews, Kirby and Valdez"
  },
  "ocr_processing": {
    "error": null,
    "execution_details": {
      "actual_result": {
        "error": null,
        "result": [
          {
            "annotations": null,
            "text": "Invoice no: 51109338\nDate of issue: 04/13/2013\n\nSeller:\nAndrews, Kirby and Valdez\n58861 Gonzalez Prairie\nLake Danieliefurt, IN 57228\n\nTax Id: 945-82-2137\nIBAN: GB75MCRL06841367619257\n\nClient:\nBecker Ltd\n8012 Stewart Summit Apt. 455\nNorth Douglas, AZ 95355\n\nTax Id: 942-80-0517\n\nITEMS\nNo. Description Qty UM Net price Net worth VAT [%] Gross worth\n1. CLEARANCE! Fast Dell Desktop\nComputer PC DUAL CORE\nWINDOWS 10 4/8/16GB RAM 3,00 each 209,00 627,00 10% 689,70\n2. HP T520 Thin Client Computer\nAMD GX-212JC 1.2GHz 4GB RAM\nTESTED !!READ BELOW!! 5,00 each 37,75 188,75 10% 207,63\n3. gaming pc desktop computer 1,00 each 400,00 400,00 10% 440,00\n4. 12-Core Gaming Computer\nDesktop PC Tower Affordable\nGAMING PC 8GB AMD Vega RGB 3,00 each 464,89 1 394,67 10% 1 534,14\n5. Custom Build Dell Optiplex 9020\nMT i5-4570 3.20GHz Desktop\nComputer PC 5,00 each 221,99 1 109,95 10% 1 220,95\n6. Dell Optiplex 990 MT Computer\nPC Quad Core i7 3.4GHz 16GB\n2TB HD Windows 10 Pro 4,00 each 269,95 1 079,80 10% 1 187,78\n7. Dell Core 2 Duo Desktop\nComputer | Windows XP Pro |\n4GB | 500GB 5,00 each 168,00 840,00 10% 924,00\n\nSUMMARY\nVAT [%] Net worth VAT Gross worth\n10% 5 640,17 564,02 6 204,19\nTotal $ 5 640,17 $ 564,02 $ 6 204,19",
            "type": "text"
          }
        ],
        "status": "success",
        "tool_name": "ocr_image_url"
      },
      "duration_seconds": 8.178518,
      "end_time": "2025-07-16T03:46:50.963780",
      "message_sent": true,
      "start_time": "2025-07-16T03:46:42.785262",
      "timestamp": "2025-07-16T03:46:50.963780",
      "worker_executed": true,
      "workers_notified": true
    },
    "output": "Task completed successfully",
    "result": [
      {
        "annotations": null,
        "text": "Invoice no: 51109338\nDate of issue: 04/13/2013\n\nSeller:\nAndrews, Kirby and Valdez\n58861 Gonzalez Prairie\nLake Danieliefurt, IN 57228\n\nTax Id: 945-82-2137\nIBAN: GB75MCRL06841367619257\n\nClient:\nBecker Ltd\n8012 Stewart Summit Apt. 455\nNorth Douglas, AZ 95355\n\nTax Id: 942-80-0517\n\nITEMS\nNo. Description Qty UM Net price Net worth VAT [%] Gross worth\n1. CLEARANCE! Fast Dell Desktop\nComputer PC DUAL CORE\nWINDOWS 10 4/8/16GB RAM 3,00 each 209,00 627,00 10% 689,70\n2. HP T520 Thin Client Computer\nAMD GX-212JC 1.2GHz 4GB RAM\nTESTED !!READ BELOW!! 5,00 each 37,75 188,75 10% 207,63\n3. gaming pc desktop computer 1,00 each 400,00 400,00 10% 440,00\n4. 12-Core Gaming Computer\nDesktop PC Tower Affordable\nGAMING PC 8GB AMD Vega RGB 3,00 each 464,89 1 394,67 10% 1 534,14\n5. Custom Build Dell Optiplex 9020\nMT i5-4570 3.20GHz Desktop\nComputer PC 5,00 each 221,99 1 109,95 10% 1 220,95\n6. Dell Optiplex 990 MT Computer\nPC Quad Core i7 3.4GHz 16GB\n2TB HD Windows 10 Pro 4,00 each 269,95 1 079,80 10% 1 187,78\n7. Dell Core 2 Duo Desktop\nComputer | Windows XP Pro |\n4GB | 500GB 5,00 each 168,00 840,00 10% 924,00\n\nSUMMARY\nVAT [%] Net worth VAT Gross worth\n10% 5 640,17 564,02 6 204,19\nTotal $ 5 640,17 $ 564,02 $ 6 204,19",
        "type": "text"
      }
    ],
    "return_code": 0,
    "status": "success",
    "stderr": "",
    "task_id": "ocr_processing",
    "tool_name": "ocr_image_url"
  },
  "post_to_sap": {
    "amount_posted": 6204.19,
    "document_type": "Invoice",
    "execution_details": {
      "actual_result": {
        "output": "Posting to SAP for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_amount\nSAP posting completed\nDocument number: 51203633\nAmount: UNRESOLVED_sap_result[\u0027amount_posted\u0027]\n__OUTPUTS__ {\"posting_status\": \"success\", \"sap_document_number\": \"51203633\", \"vendor_code\": \"V21014\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"invoice_number\": \"51109338\", \"amount_posted\": 6204.19, \"posting_date\": \"2024-07-15\", \"document_type\": \"Invoice\"}\n",
        "return_code": 0,
        "status": "completed",
        "stderr": ""
      },
      "duration_seconds": 0.164751,
      "end_time": "2025-07-16T03:46:58.175317",
      "message_sent": true,
      "start_time": "2025-07-16T03:46:58.010566",
      "timestamp": "2025-07-16T03:46:58.175317",
      "worker_executed": true,
      "workers_notified": true
    },
    "invoice_number": "51109338",
    "output": "Posting to SAP for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_amount\nSAP posting completed\nDocument number: 51203633\nAmount: UNRESOLVED_sap_result[\u0027amount_posted\u0027]\n__OUTPUTS__ {\"posting_status\": \"success\", \"sap_document_number\": \"51203633\", \"vendor_code\": \"V21014\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"invoice_number\": \"51109338\", \"amount_posted\": 6204.19, \"posting_date\": \"2024-07-15\", \"document_type\": \"Invoice\"}\n",
    "posting_date": "2024-07-15",
    "posting_status": "success",
    "return_code": 0,
    "sap_document_number": "51203633",
    "status": "completed",
    "stderr": "",
    "task_id": "post_to_sap",
    "vendor_code": "V21014",
    "vendor_name": "Andrews, Kirby and Valdez"
  },
  "status": "FAILED",
  "task_outputs": {
    "extract_invoice_data": {
      "agent_type": "assistant",
      "ai_response": "{\n  \"vendor_name\": \"Andrews, Kirby and Valdez\",\n  \"invoice_number\": \"51109338\",\n  \"date\": \"2013-04-13\",\n  \"po_number\": null,\n  \"amount\": 6204.19,\n  \"line_items\": [\n    {\n      \"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\",\n      \"quantity\": 3,\n      \"price\": 209.00,\n      \"total\": 627.00\n    },\n    {\n      \"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\",\n      \"quantity\": 5,\n      \"price\": 37.75,\n      \"total\": 188.75\n    },\n    {\n      \"description\": \"gaming pc desktop computer\",\n      \"quantity\": 1,\n      \"price\": 400.00,\n      \"total\": 400.00\n    },\n    {\n      \"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\",\n      \"quantity\": 3,\n      \"price\": 464.89,\n      \"total\": 1394.67\n    },\n    {\n      \"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\",\n      \"quantity\": 5,\n      \"price\": 221.99,\n      \"total\": 1109.95\n    },\n    {\n      \"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\",\n      \"quantity\": 4,\n      \"price\": 269.95,\n      \"total\": 1079.80\n    },\n    {\n      \"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\",\n      \"quantity\": 5,\n      \"price\": 168.00,\n      \"total\": 840.00\n    }\n  ]\n}",
      "execution_details": {
        "actual_result": {
          "agent_type": "assistant",
          "execution_details": {
            "agent_type": "assistant",
            "input_length": 1400,
            "model": "gpt-4o-mini",
            "output_length": 1366,
            "provider": "openai",
            "system_message": "Extract only these key fields from the OCR text. Return ONLY a JSON object:\n{\n  \"vendor_name\": \"extracted vendor name or null\",\n  \"invoice_number\": \"extracted invoice number or null\",\n  \"date\": \"YYYY-MM-DD format or null\",\n  \"po_number\": \"extracted PO number or null\", \n  \"amount\": \"numeric amount or null\",\n  \"line_items\": [\n    {\n      \"description\": \"item description\",\n      \"quantity\": \"numeric quantity\",\n      \"price\": \"numeric price\",\n      \"total\": \"numeric total\"\n    }\n  ]\n}\n"
          },
          "input_format": "json",
          "model_client_id": "invoice_extractor",
          "output": "{\n  \"vendor_name\": \"Andrews, Kirby and Valdez\",\n  \"invoice_number\": \"51109338\",\n  \"date\": \"2013-04-13\",\n  \"po_number\": null,\n  \"amount\": 6204.19,\n  \"line_items\": [\n    {\n      \"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\",\n      \"quantity\": 3,\n      \"price\": 209.00,\n      \"total\": 627.00\n    },\n    {\n      \"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\",\n      \"quantity\": 5,\n      \"price\": 37.75,\n      \"total\": 188.75\n    },\n    {\n      \"description\": \"gaming pc desktop computer\",\n      \"quantity\": 1,\n      \"price\": 400.00,\n      \"total\": 400.00\n    },\n    {\n      \"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\",\n      \"quantity\": 3,\n      \"price\": 464.89,\n      \"total\": 1394.67\n    },\n    {\n      \"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\",\n      \"quantity\": 5,\n      \"price\": 221.99,\n      \"total\": 1109.95\n    },\n    {\n      \"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\",\n      \"quantity\": 4,\n      \"price\": 269.95,\n      \"total\": 1079.80\n    },\n    {\n      \"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\",\n      \"quantity\": 5,\n      \"price\": 168.00,\n      \"total\": 840.00\n    }\n  ]\n}\n__OUTPUTS__ {\"ai_response\": \"{\\n  \\\"vendor_name\\\": \\\"Andrews, Kirby and Valdez\\\",\\n  \\\"invoice_number\\\": \\\"51109338\\\",\\n  \\\"date\\\": \\\"2013-04-13\\\",\\n  \\\"po_number\\\": null,\\n  \\\"amount\\\": 6204.19,\\n  \\\"line_items\\\": [\\n    {\\n      \\\"description\\\": \\\"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\\\",\\n      \\\"quantity\\\": 3,\\n      \\\"price\\\": 209.00,\\n      \\\"total\\\": 627.00\\n    },\\n    {\\n      \\\"description\\\": \\\"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 37.75,\\n      \\\"total\\\": 188.75\\n    },\\n    {\\n      \\\"description\\\": \\\"gaming pc desktop computer\\\",\\n      \\\"quantity\\\": 1,\\n      \\\"price\\\": 400.00,\\n      \\\"total\\\": 400.00\\n    },\\n    {\\n      \\\"description\\\": \\\"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\\\",\\n      \\\"quantity\\\": 3,\\n      \\\"price\\\": 464.89,\\n      \\\"total\\\": 1394.67\\n    },\\n    {\\n      \\\"description\\\": \\\"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 221.99,\\n      \\\"total\\\": 1109.95\\n    },\\n    {\\n      \\\"description\\\": \\\"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\\\",\\n      \\\"quantity\\\": 4,\\n      \\\"price\\\": 269.95,\\n      \\\"total\\\": 1079.80\\n    },\\n    {\\n      \\\"description\\\": \\\"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 168.00,\\n      \\\"total\\\": 840.00\\n    }\\n  ]\\n}\", \"model_client_id\": \"invoice_extractor\", \"agent_type\": \"assistant\", \"model\": \"gpt-4o-mini\", \"provider\": \"openai\", \"status\": \"completed\", \"token_usage\": {\"prompt_tokens\": 683, \"completion_tokens\": 451, \"total_tokens\": 1134, \"estimated_cost\": {\"amount\": 0.000373, \"currency\": \"USD\"}, \"model\": \"gpt-4o-mini\", \"provider\": \"openai\"}}",
          "output_format": "json",
          "return_code": 0,
          "status": "completed",
          "stderr": "",
          "token_usage": {
            "completion_tokens": 451,
            "estimated_cost": {
              "amount": 0.000373,
              "currency": "USD"
            },
            "model": "gpt-4o-mini",
            "prompt_tokens": 683,
            "provider": "openai",
            "total_tokens": 1134
          }
        },
        "duration_seconds": 6.824267,
        "end_time": "2025-07-16T03:46:57.809140",
        "message_sent": true,
        "start_time": "2025-07-16T03:46:50.984873",
        "timestamp": "2025-07-16T03:46:57.809140",
        "worker_executed": true,
        "workers_notified": true
      },
      "model": "gpt-4o-mini",
      "model_client_id": "invoice_extractor",
      "output": "{\n  \"vendor_name\": \"Andrews, Kirby and Valdez\",\n  \"invoice_number\": \"51109338\",\n  \"date\": \"2013-04-13\",\n  \"po_number\": null,\n  \"amount\": 6204.19,\n  \"line_items\": [\n    {\n      \"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\",\n      \"quantity\": 3,\n      \"price\": 209.00,\n      \"total\": 627.00\n    },\n    {\n      \"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\",\n      \"quantity\": 5,\n      \"price\": 37.75,\n      \"total\": 188.75\n    },\n    {\n      \"description\": \"gaming pc desktop computer\",\n      \"quantity\": 1,\n      \"price\": 400.00,\n      \"total\": 400.00\n    },\n    {\n      \"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\",\n      \"quantity\": 3,\n      \"price\": 464.89,\n      \"total\": 1394.67\n    },\n    {\n      \"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\",\n      \"quantity\": 5,\n      \"price\": 221.99,\n      \"total\": 1109.95\n    },\n    {\n      \"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\",\n      \"quantity\": 4,\n      \"price\": 269.95,\n      \"total\": 1079.80\n    },\n    {\n      \"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\",\n      \"quantity\": 5,\n      \"price\": 168.00,\n      \"total\": 840.00\n    }\n  ]\n}\n__OUTPUTS__ {\"ai_response\": \"{\\n  \\\"vendor_name\\\": \\\"Andrews, Kirby and Valdez\\\",\\n  \\\"invoice_number\\\": \\\"51109338\\\",\\n  \\\"date\\\": \\\"2013-04-13\\\",\\n  \\\"po_number\\\": null,\\n  \\\"amount\\\": 6204.19,\\n  \\\"line_items\\\": [\\n    {\\n      \\\"description\\\": \\\"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\\\",\\n      \\\"quantity\\\": 3,\\n      \\\"price\\\": 209.00,\\n      \\\"total\\\": 627.00\\n    },\\n    {\\n      \\\"description\\\": \\\"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 37.75,\\n      \\\"total\\\": 188.75\\n    },\\n    {\\n      \\\"description\\\": \\\"gaming pc desktop computer\\\",\\n      \\\"quantity\\\": 1,\\n      \\\"price\\\": 400.00,\\n      \\\"total\\\": 400.00\\n    },\\n    {\\n      \\\"description\\\": \\\"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\\\",\\n      \\\"quantity\\\": 3,\\n      \\\"price\\\": 464.89,\\n      \\\"total\\\": 1394.67\\n    },\\n    {\\n      \\\"description\\\": \\\"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 221.99,\\n      \\\"total\\\": 1109.95\\n    },\\n    {\\n      \\\"description\\\": \\\"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\\\",\\n      \\\"quantity\\\": 4,\\n      \\\"price\\\": 269.95,\\n      \\\"total\\\": 1079.80\\n    },\\n    {\\n      \\\"description\\\": \\\"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\\\",\\n      \\\"quantity\\\": 5,\\n      \\\"price\\\": 168.00,\\n      \\\"total\\\": 840.00\\n    }\\n  ]\\n}\", \"model_client_id\": \"invoice_extractor\", \"agent_type\": \"assistant\", \"model\": \"gpt-4o-mini\", \"provider\": \"openai\", \"status\": \"completed\", \"token_usage\": {\"prompt_tokens\": 683, \"completion_tokens\": 451, \"total_tokens\": 1134, \"estimated_cost\": {\"amount\": 0.000373, \"currency\": \"USD\"}, \"model\": \"gpt-4o-mini\", \"provider\": \"openai\"}}",
      "provider": "openai",
      "return_code": 0,
      "status": "completed",
      "stderr": "",
      "task_id": "extract_invoice_data",
      "token_usage": {
        "completion_tokens": 451,
        "estimated_cost": {
          "amount": 0.000373,
          "currency": "USD"
        },
        "model": "gpt-4o-mini",
        "prompt_tokens": 683,
        "provider": "openai",
        "total_tokens": 1134
      }
    },
    "generate_summary": {
      "amount": 6204.19,
      "automation_level": "fully_automated",
      "execution_details": {
        "actual_result": {
          "output": "Generating summary for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_amount\nProcessing summary generated\nStatus: completed\nInvoice: 51109338\n__OUTPUTS__ {\"processing_status\": \"completed\", \"invoice_number\": \"51109338\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"amount\": 6204.19, \"po_number\": null, \"line_items_count\": 7, \"sap_document\": \"51502037\", \"processing_time\": \"5 minutes\", \"automation_level\": \"fully_automated\"}\n",
          "return_code": 0,
          "status": "completed",
          "stderr": ""
        },
        "duration_seconds": 0.159634,
        "end_time": "2025-07-16T03:46:58.374672",
        "message_sent": true,
        "start_time": "2025-07-16T03:46:58.215038",
        "timestamp": "2025-07-16T03:46:58.374672",
        "worker_executed": true,
        "workers_notified": true
      },
      "invoice_number": "51109338",
      "line_items_count": 7,
      "output": "Generating summary for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_amount\nProcessing summary generated\nStatus: completed\nInvoice: 51109338\n__OUTPUTS__ {\"processing_status\": \"completed\", \"invoice_number\": \"51109338\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"amount\": 6204.19, \"po_number\": null, \"line_items_count\": 7, \"sap_document\": \"51502037\", \"processing_time\": \"5 minutes\", \"automation_level\": \"fully_automated\"}\n",
      "po_number": null,
      "processing_status": "completed",
      "processing_time": "5 minutes",
      "return_code": 0,
      "sap_document": "51502037",
      "status": "completed",
      "stderr": "",
      "task_id": "generate_summary",
      "vendor_name": "Andrews, Kirby and Valdez"
    },
    "ocr_processing": {
      "error": null,
      "execution_details": {
        "actual_result": {
          "error": null,
          "result": [
            {
              "annotations": null,
              "text": "Invoice no: 51109338\nDate of issue: 04/13/2013\n\nSeller:\nAndrews, Kirby and Valdez\n58861 Gonzalez Prairie\nLake Danieliefurt, IN 57228\n\nTax Id: 945-82-2137\nIBAN: GB75MCRL06841367619257\n\nClient:\nBecker Ltd\n8012 Stewart Summit Apt. 455\nNorth Douglas, AZ 95355\n\nTax Id: 942-80-0517\n\nITEMS\nNo. Description Qty UM Net price Net worth VAT [%] Gross worth\n1. CLEARANCE! Fast Dell Desktop\nComputer PC DUAL CORE\nWINDOWS 10 4/8/16GB RAM 3,00 each 209,00 627,00 10% 689,70\n2. HP T520 Thin Client Computer\nAMD GX-212JC 1.2GHz 4GB RAM\nTESTED !!READ BELOW!! 5,00 each 37,75 188,75 10% 207,63\n3. gaming pc desktop computer 1,00 each 400,00 400,00 10% 440,00\n4. 12-Core Gaming Computer\nDesktop PC Tower Affordable\nGAMING PC 8GB AMD Vega RGB 3,00 each 464,89 1 394,67 10% 1 534,14\n5. Custom Build Dell Optiplex 9020\nMT i5-4570 3.20GHz Desktop\nComputer PC 5,00 each 221,99 1 109,95 10% 1 220,95\n6. Dell Optiplex 990 MT Computer\nPC Quad Core i7 3.4GHz 16GB\n2TB HD Windows 10 Pro 4,00 each 269,95 1 079,80 10% 1 187,78\n7. Dell Core 2 Duo Desktop\nComputer | Windows XP Pro |\n4GB | 500GB 5,00 each 168,00 840,00 10% 924,00\n\nSUMMARY\nVAT [%] Net worth VAT Gross worth\n10% 5 640,17 564,02 6 204,19\nTotal $ 5 640,17 $ 564,02 $ 6 204,19",
              "type": "text"
            }
          ],
          "status": "success",
          "tool_name": "ocr_image_url"
        },
        "duration_seconds": 8.178518,
        "end_time": "2025-07-16T03:46:50.963780",
        "message_sent": true,
        "start_time": "2025-07-16T03:46:42.785262",
        "timestamp": "2025-07-16T03:46:50.963780",
        "worker_executed": true,
        "workers_notified": true
      },
      "output": "Task completed successfully",
      "result": [
        {
          "annotations": null,
          "text": "Invoice no: 51109338\nDate of issue: 04/13/2013\n\nSeller:\nAndrews, Kirby and Valdez\n58861 Gonzalez Prairie\nLake Danieliefurt, IN 57228\n\nTax Id: 945-82-2137\nIBAN: GB75MCRL06841367619257\n\nClient:\nBecker Ltd\n8012 Stewart Summit Apt. 455\nNorth Douglas, AZ 95355\n\nTax Id: 942-80-0517\n\nITEMS\nNo. Description Qty UM Net price Net worth VAT [%] Gross worth\n1. CLEARANCE! Fast Dell Desktop\nComputer PC DUAL CORE\nWINDOWS 10 4/8/16GB RAM 3,00 each 209,00 627,00 10% 689,70\n2. HP T520 Thin Client Computer\nAMD GX-212JC 1.2GHz 4GB RAM\nTESTED !!READ BELOW!! 5,00 each 37,75 188,75 10% 207,63\n3. gaming pc desktop computer 1,00 each 400,00 400,00 10% 440,00\n4. 12-Core Gaming Computer\nDesktop PC Tower Affordable\nGAMING PC 8GB AMD Vega RGB 3,00 each 464,89 1 394,67 10% 1 534,14\n5. Custom Build Dell Optiplex 9020\nMT i5-4570 3.20GHz Desktop\nComputer PC 5,00 each 221,99 1 109,95 10% 1 220,95\n6. Dell Optiplex 990 MT Computer\nPC Quad Core i7 3.4GHz 16GB\n2TB HD Windows 10 Pro 4,00 each 269,95 1 079,80 10% 1 187,78\n7. Dell Core 2 Duo Desktop\nComputer | Windows XP Pro |\n4GB | 500GB 5,00 each 168,00 840,00 10% 924,00\n\nSUMMARY\nVAT [%] Net worth VAT Gross worth\n10% 5 640,17 564,02 6 204,19\nTotal $ 5 640,17 $ 564,02 $ 6 204,19",
          "type": "text"
        }
      ],
      "return_code": 0,
      "status": "success",
      "stderr": "",
      "task_id": "ocr_processing",
      "tool_name": "ocr_image_url"
    },
    "post_to_sap": {
      "amount_posted": 6204.19,
      "document_type": "Invoice",
      "execution_details": {
        "actual_result": {
          "output": "Posting to SAP for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_amount\nSAP posting completed\nDocument number: 51203633\nAmount: UNRESOLVED_sap_result[\u0027amount_posted\u0027]\n__OUTPUTS__ {\"posting_status\": \"success\", \"sap_document_number\": \"51203633\", \"vendor_code\": \"V21014\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"invoice_number\": \"51109338\", \"amount_posted\": 6204.19, \"posting_date\": \"2024-07-15\", \"document_type\": \"Invoice\"}\n",
          "return_code": 0,
          "status": "completed",
          "stderr": ""
        },
        "duration_seconds": 0.164751,
        "end_time": "2025-07-16T03:46:58.175317",
        "message_sent": true,
        "start_time": "2025-07-16T03:46:58.010566",
        "timestamp": "2025-07-16T03:46:58.175317",
        "worker_executed": true,
        "workers_notified": true
      },
      "invoice_number": "51109338",
      "output": "Posting to SAP for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_amount\nSAP posting completed\nDocument number: 51203633\nAmount: UNRESOLVED_sap_result[\u0027amount_posted\u0027]\n__OUTPUTS__ {\"posting_status\": \"success\", \"sap_document_number\": \"51203633\", \"vendor_code\": \"V21014\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"invoice_number\": \"51109338\", \"amount_posted\": 6204.19, \"posting_date\": \"2024-07-15\", \"document_type\": \"Invoice\"}\n",
      "posting_date": "2024-07-15",
      "posting_status": "success",
      "return_code": 0,
      "sap_document_number": "51203633",
      "status": "completed",
      "stderr": "",
      "task_id": "post_to_sap",
      "vendor_code": "V21014",
      "vendor_name": "Andrews, Kirby and Valdez"
    },
    "upload_to_supabase": {
      "bucket_name": "ubspublic",
      "csv_structure": {
        "column_count": 22,
        "columns": [
          "processing_timestamp",
          "workflow_id",
          "workflow_version",
          "invoice_number",
          "vendor_name",
          "invoice_date",
          "po_number",
          "invoice_amount",
          "line_items_count",
          "sap_posting_status",
          "sap_document_number",
          "vendor_code",
          "amount_posted",
          "sap_posting_date",
          "document_type",
          "overall_processing_status",
          "processing_time",
          "automation_level",
          "image_url",
          "notification_email",
          "processed_by",
          "processing_node"
        ],
        "row_count": 1
      },
      "data_summary": {
        "amount": 6204.19,
        "invoice_number": "51109338",
        "processing_status": "completed",
        "sap_document": "51203633",
        "vendor_name": "Andrews, Kirby and Valdez"
      },
      "execution_details": {
        "actual_result": {
          "output": "Successfully parsed data from previous nodes\nGenerated CSV file: invoice_processing_51109338_20250716_034659.csv\nCSV content size: 716 characters\nData rows: 1\nFile uploaded successfully to Supabase\nUpload completed successfully\nPublic URL: https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?\nRecords uploaded: 1\n__OUTPUTS__ {\"upload_status\": \"success\", \"bucket_name\": \"ubspublic\", \"filename\": \"invoice_processing_51109338_20250716_034659.csv\", \"file_size_bytes\": 716, \"public_url\": \"https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?\", \"upload_timestamp\": \"2025-07-16T03:47:00.538313\", \"records_uploaded\": 1, \"data_summary\": {\"invoice_number\": \"51109338\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"amount\": 6204.19, \"sap_document\": \"51203633\", \"processing_status\": \"completed\"}, \"csv_structure\": {\"columns\": [\"processing_timestamp\", \"workflow_id\", \"workflow_version\", \"invoice_number\", \"vendor_name\", \"invoice_date\", \"po_number\", \"invoice_amount\", \"line_items_count\", \"sap_posting_status\", \"sap_document_number\", \"vendor_code\", \"amount_posted\", \"sap_posting_date\", \"document_type\", \"overall_processing_status\", \"processing_time\", \"automation_level\", \"image_url\", \"notification_email\", \"processed_by\", \"processing_node\"], \"column_count\": 22, \"row_count\": 1}}\n",
          "return_code": 0,
          "status": "completed",
          "stderr": ""
        },
        "duration_seconds": 2.388393,
        "end_time": "2025-07-16T03:47:00.817163",
        "message_sent": true,
        "start_time": "2025-07-16T03:46:58.428770",
        "timestamp": "2025-07-16T03:47:00.817163",
        "worker_executed": true,
        "workers_notified": true
      },
      "file_size_bytes": 716,
      "filename": "invoice_processing_51109338_20250716_034659.csv",
      "output": "Successfully parsed data from previous nodes\nGenerated CSV file: invoice_processing_51109338_20250716_034659.csv\nCSV content size: 716 characters\nData rows: 1\nFile uploaded successfully to Supabase\nUpload completed successfully\nPublic URL: https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?\nRecords uploaded: 1\n__OUTPUTS__ {\"upload_status\": \"success\", \"bucket_name\": \"ubspublic\", \"filename\": \"invoice_processing_51109338_20250716_034659.csv\", \"file_size_bytes\": 716, \"public_url\": \"https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?\", \"upload_timestamp\": \"2025-07-16T03:47:00.538313\", \"records_uploaded\": 1, \"data_summary\": {\"invoice_number\": \"51109338\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"amount\": 6204.19, \"sap_document\": \"51203633\", \"processing_status\": \"completed\"}, \"csv_structure\": {\"columns\": [\"processing_timestamp\", \"workflow_id\", \"workflow_version\", \"invoice_number\", \"vendor_name\", \"invoice_date\", \"po_number\", \"invoice_amount\", \"line_items_count\", \"sap_posting_status\", \"sap_document_number\", \"vendor_code\", \"amount_posted\", \"sap_posting_date\", \"document_type\", \"overall_processing_status\", \"processing_time\", \"automation_level\", \"image_url\", \"notification_email\", \"processed_by\", \"processing_node\"], \"column_count\": 22, \"row_count\": 1}}\n",
      "public_url": "https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?",
      "records_uploaded": 1,
      "return_code": 0,
      "status": "completed",
      "stderr": "",
      "task_id": "upload_to_supabase",
      "upload_status": "success",
      "upload_timestamp": "2025-07-16T03:47:00.538313"
    },
    "validate_data": {
      "amount": 6204.19,
      "date": "2013-04-13",
      "execution_details": {
        "actual_result": {
          "output": "Using extracted data from AI response\nVendor: Andrews, Kirby and Valdez\nInvoice: 51109338\nAmount: 6204.19\nValidation completed for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_validation_result[\u0027amount\u0027]\n__OUTPUTS__ {\"vendor_name\": \"Andrews, Kirby and Valdez\", \"invoice_number\": \"51109338\", \"date\": \"2013-04-13\", \"po_number\": null, \"amount\": 6204.19, \"line_items\": [{\"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\", \"quantity\": 3, \"price\": 209.0, \"total\": 627.0}, {\"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\", \"quantity\": 5, \"price\": 37.75, \"total\": 188.75}, {\"description\": \"gaming pc desktop computer\", \"quantity\": 1, \"price\": 400.0, \"total\": 400.0}, {\"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\", \"quantity\": 3, \"price\": 464.89, \"total\": 1394.67}, {\"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\", \"quantity\": 5, \"price\": 221.99, \"total\": 1109.95}, {\"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\", \"quantity\": 4, \"price\": 269.95, \"total\": 1079.8}, {\"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\", \"quantity\": 5, \"price\": 168.0, \"total\": 840.0}], \"validation_status\": \"passed\", \"total_items\": 7}\n",
          "return_code": 0,
          "status": "completed",
          "stderr": ""
        },
        "duration_seconds": 0.157955,
        "end_time": "2025-07-16T03:46:57.988214",
        "message_sent": true,
        "start_time": "2025-07-16T03:46:57.830259",
        "timestamp": "2025-07-16T03:46:57.988214",
        "worker_executed": true,
        "workers_notified": true
      },
      "invoice_number": "51109338",
      "line_items": [
        {
          "description": "CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM",
          "price": 209.0,
          "quantity": 3,
          "total": 627.0
        },
        {
          "description": "HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!",
          "price": 37.75,
          "quantity": 5,
          "total": 188.75
        },
        {
          "description": "gaming pc desktop computer",
          "price": 400.0,
          "quantity": 1,
          "total": 400.0
        },
        {
          "description": "12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB",
          "price": 464.89,
          "quantity": 3,
          "total": 1394.67
        },
        {
          "description": "Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC",
          "price": 221.99,
          "quantity": 5,
          "total": 1109.95
        },
        {
          "description": "Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro",
          "price": 269.95,
          "quantity": 4,
          "total": 1079.8
        },
        {
          "description": "Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB",
          "price": 168.0,
          "quantity": 5,
          "total": 840.0
        }
      ],
      "output": "Using extracted data from AI response\nVendor: Andrews, Kirby and Valdez\nInvoice: 51109338\nAmount: 6204.19\nValidation completed for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_validation_result[\u0027amount\u0027]\n__OUTPUTS__ {\"vendor_name\": \"Andrews, Kirby and Valdez\", \"invoice_number\": \"51109338\", \"date\": \"2013-04-13\", \"po_number\": null, \"amount\": 6204.19, \"line_items\": [{\"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\", \"quantity\": 3, \"price\": 209.0, \"total\": 627.0}, {\"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\", \"quantity\": 5, \"price\": 37.75, \"total\": 188.75}, {\"description\": \"gaming pc desktop computer\", \"quantity\": 1, \"price\": 400.0, \"total\": 400.0}, {\"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\", \"quantity\": 3, \"price\": 464.89, \"total\": 1394.67}, {\"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\", \"quantity\": 5, \"price\": 221.99, \"total\": 1109.95}, {\"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\", \"quantity\": 4, \"price\": 269.95, \"total\": 1079.8}, {\"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\", \"quantity\": 5, \"price\": 168.0, \"total\": 840.0}], \"validation_status\": \"passed\", \"total_items\": 7}\n",
      "po_number": null,
      "return_code": 0,
      "status": "completed",
      "stderr": "",
      "task_id": "validate_data",
      "total_items": 7,
      "validation_status": "passed",
      "vendor_name": "Andrews, Kirby and Valdez"
    }
  },
  "upload_to_supabase": {
    "bucket_name": "ubspublic",
    "csv_structure": {
      "column_count": 22,
      "columns": [
        "processing_timestamp",
        "workflow_id",
        "workflow_version",
        "invoice_number",
        "vendor_name",
        "invoice_date",
        "po_number",
        "invoice_amount",
        "line_items_count",
        "sap_posting_status",
        "sap_document_number",
        "vendor_code",
        "amount_posted",
        "sap_posting_date",
        "document_type",
        "overall_processing_status",
        "processing_time",
        "automation_level",
        "image_url",
        "notification_email",
        "processed_by",
        "processing_node"
      ],
      "row_count": 1
    },
    "data_summary": {
      "amount": 6204.19,
      "invoice_number": "51109338",
      "processing_status": "completed",
      "sap_document": "51203633",
      "vendor_name": "Andrews, Kirby and Valdez"
    },
    "execution_details": {
      "actual_result": {
        "output": "Successfully parsed data from previous nodes\nGenerated CSV file: invoice_processing_51109338_20250716_034659.csv\nCSV content size: 716 characters\nData rows: 1\nFile uploaded successfully to Supabase\nUpload completed successfully\nPublic URL: https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?\nRecords uploaded: 1\n__OUTPUTS__ {\"upload_status\": \"success\", \"bucket_name\": \"ubspublic\", \"filename\": \"invoice_processing_51109338_20250716_034659.csv\", \"file_size_bytes\": 716, \"public_url\": \"https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?\", \"upload_timestamp\": \"2025-07-16T03:47:00.538313\", \"records_uploaded\": 1, \"data_summary\": {\"invoice_number\": \"51109338\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"amount\": 6204.19, \"sap_document\": \"51203633\", \"processing_status\": \"completed\"}, \"csv_structure\": {\"columns\": [\"processing_timestamp\", \"workflow_id\", \"workflow_version\", \"invoice_number\", \"vendor_name\", \"invoice_date\", \"po_number\", \"invoice_amount\", \"line_items_count\", \"sap_posting_status\", \"sap_document_number\", \"vendor_code\", \"amount_posted\", \"sap_posting_date\", \"document_type\", \"overall_processing_status\", \"processing_time\", \"automation_level\", \"image_url\", \"notification_email\", \"processed_by\", \"processing_node\"], \"column_count\": 22, \"row_count\": 1}}\n",
        "return_code": 0,
        "status": "completed",
        "stderr": ""
      },
      "duration_seconds": 2.388393,
      "end_time": "2025-07-16T03:47:00.817163",
      "message_sent": true,
      "start_time": "2025-07-16T03:46:58.428770",
      "timestamp": "2025-07-16T03:47:00.817163",
      "worker_executed": true,
      "workers_notified": true
    },
    "file_size_bytes": 716,
    "filename": "invoice_processing_51109338_20250716_034659.csv",
    "output": "Successfully parsed data from previous nodes\nGenerated CSV file: invoice_processing_51109338_20250716_034659.csv\nCSV content size: 716 characters\nData rows: 1\nFile uploaded successfully to Supabase\nUpload completed successfully\nPublic URL: https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?\nRecords uploaded: 1\n__OUTPUTS__ {\"upload_status\": \"success\", \"bucket_name\": \"ubspublic\", \"filename\": \"invoice_processing_51109338_20250716_034659.csv\", \"file_size_bytes\": 716, \"public_url\": \"https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?\", \"upload_timestamp\": \"2025-07-16T03:47:00.538313\", \"records_uploaded\": 1, \"data_summary\": {\"invoice_number\": \"51109338\", \"vendor_name\": \"Andrews, Kirby and Valdez\", \"amount\": 6204.19, \"sap_document\": \"51203633\", \"processing_status\": \"completed\"}, \"csv_structure\": {\"columns\": [\"processing_timestamp\", \"workflow_id\", \"workflow_version\", \"invoice_number\", \"vendor_name\", \"invoice_date\", \"po_number\", \"invoice_amount\", \"line_items_count\", \"sap_posting_status\", \"sap_document_number\", \"vendor_code\", \"amount_posted\", \"sap_posting_date\", \"document_type\", \"overall_processing_status\", \"processing_time\", \"automation_level\", \"image_url\", \"notification_email\", \"processed_by\", \"processing_node\"], \"column_count\": 22, \"row_count\": 1}}\n",
    "public_url": "https://mbauzgvitqvxceqanzjw.supabase.co/storage/v1/object/public/ubspublic/invoice_processing_51109338_20250716_034659.csv?",
    "records_uploaded": 1,
    "return_code": 0,
    "status": "completed",
    "stderr": "",
    "task_id": "upload_to_supabase",
    "upload_status": "success",
    "upload_timestamp": "2025-07-16T03:47:00.538313"
  },
  "validate_data": {
    "amount": 6204.19,
    "date": "2013-04-13",
    "execution_details": {
      "actual_result": {
        "output": "Using extracted data from AI response\nVendor: Andrews, Kirby and Valdez\nInvoice: 51109338\nAmount: 6204.19\nValidation completed for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_validation_result[\u0027amount\u0027]\n__OUTPUTS__ {\"vendor_name\": \"Andrews, Kirby and Valdez\", \"invoice_number\": \"51109338\", \"date\": \"2013-04-13\", \"po_number\": null, \"amount\": 6204.19, \"line_items\": [{\"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\", \"quantity\": 3, \"price\": 209.0, \"total\": 627.0}, {\"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\", \"quantity\": 5, \"price\": 37.75, \"total\": 188.75}, {\"description\": \"gaming pc desktop computer\", \"quantity\": 1, \"price\": 400.0, \"total\": 400.0}, {\"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\", \"quantity\": 3, \"price\": 464.89, \"total\": 1394.67}, {\"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\", \"quantity\": 5, \"price\": 221.99, \"total\": 1109.95}, {\"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\", \"quantity\": 4, \"price\": 269.95, \"total\": 1079.8}, {\"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\", \"quantity\": 5, \"price\": 168.0, \"total\": 840.0}], \"validation_status\": \"passed\", \"total_items\": 7}\n",
        "return_code": 0,
        "status": "completed",
        "stderr": ""
      },
      "duration_seconds": 0.157955,
      "end_time": "2025-07-16T03:46:57.988214",
      "message_sent": true,
      "start_time": "2025-07-16T03:46:57.830259",
      "timestamp": "2025-07-16T03:46:57.988214",
      "worker_executed": true,
      "workers_notified": true
    },
    "invoice_number": "51109338",
    "line_items": [
      {
        "description": "CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM",
        "price": 209.0,
        "quantity": 3,
        "total": 627.0
      },
      {
        "description": "HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!",
        "price": 37.75,
        "quantity": 5,
        "total": 188.75
      },
      {
        "description": "gaming pc desktop computer",
        "price": 400.0,
        "quantity": 1,
        "total": 400.0
      },
      {
        "description": "12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB",
        "price": 464.89,
        "quantity": 3,
        "total": 1394.67
      },
      {
        "description": "Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC",
        "price": 221.99,
        "quantity": 5,
        "total": 1109.95
      },
      {
        "description": "Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro",
        "price": 269.95,
        "quantity": 4,
        "total": 1079.8
      },
      {
        "description": "Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB",
        "price": 168.0,
        "quantity": 5,
        "total": 840.0
      }
    ],
    "output": "Using extracted data from AI response\nVendor: Andrews, Kirby and Valdez\nInvoice: 51109338\nAmount: 6204.19\nValidation completed for invoice: 51109338\nVendor: Andrews, Kirby and Valdez\nAmount: UNRESOLVED_validation_result[\u0027amount\u0027]\n__OUTPUTS__ {\"vendor_name\": \"Andrews, Kirby and Valdez\", \"invoice_number\": \"51109338\", \"date\": \"2013-04-13\", \"po_number\": null, \"amount\": 6204.19, \"line_items\": [{\"description\": \"CLEARANCE! Fast Dell Desktop Computer PC DUAL CORE WINDOWS 10 4/8/16GB RAM\", \"quantity\": 3, \"price\": 209.0, \"total\": 627.0}, {\"description\": \"HP T520 Thin Client Computer AMD GX-212JC 1.2GHz 4GB RAM TESTED !!READ BELOW!!\", \"quantity\": 5, \"price\": 37.75, \"total\": 188.75}, {\"description\": \"gaming pc desktop computer\", \"quantity\": 1, \"price\": 400.0, \"total\": 400.0}, {\"description\": \"12-Core Gaming Computer Desktop PC Tower Affordable GAMING PC 8GB AMD Vega RGB\", \"quantity\": 3, \"price\": 464.89, \"total\": 1394.67}, {\"description\": \"Custom Build Dell Optiplex 9020 MT i5-4570 3.20GHz Desktop Computer PC\", \"quantity\": 5, \"price\": 221.99, \"total\": 1109.95}, {\"description\": \"Dell Optiplex 990 MT Computer PC Quad Core i7 3.4GHz 16GB 2TB HD Windows 10 Pro\", \"quantity\": 4, \"price\": 269.95, \"total\": 1079.8}, {\"description\": \"Dell Core 2 Duo Desktop Computer | Windows XP Pro | 4GB | 500GB\", \"quantity\": 5, \"price\": 168.0, \"total\": 840.0}], \"validation_status\": \"passed\", \"total_items\": 7}\n",
    "po_number": null,
    "return_code": 0,
    "status": "completed",
    "stderr": "",
    "task_id": "validate_data",
    "total_items": 7,
    "validation_status": "passed",
    "vendor_name": "Andrews, Kirby and Valdez"
  }
}

Task Executions

ocr_processing

COMPLETED

Started: 2025-07-16 03:46:41

Duration: Calculating...

extract_invoice_data

COMPLETED

Started: 2025-07-16 03:46:41

Duration: Calculating...

validate_data

COMPLETED

Started: 2025-07-16 03:46:41

Duration: Calculating...

post_to_sap

COMPLETED

Started: 2025-07-16 03:46:41

Duration: Calculating...

generate_summary

COMPLETED

Started: 2025-07-16 03:46:41

Duration: Calculating...

upload_to_supabase

COMPLETED

Started: 2025-07-16 03:46:41

Duration: Calculating...

Generated Files

Loading generated files...

Execution Logs

Auto-refresh

Loading execution logs...

Execution Details COMPLETED

Execution Information

Quick Actions

Execution Inputs

Execution Outputs

Workflow Execution Summary

Task Results & Logs

Task Executions

ocr_processing

Task Output

extract_invoice_data

Task Output

validate_data

Task Output

post_to_sap

Task Output

generate_summary

Task Output

upload_to_supabase

Task Output

Generated Files

Execution Logs