Featherstone Bakers13 Automator Purchase Order Automation
  1. Upload
  2. Extract
  3. Review
  4. Write

Automator · Job 3a0a0e2303a9

222.webp

Advantage write failed: test order total must be between 0 and 50.00

Failed

Invoice header

Account, customer, Bakers item #, quantity, unit, and price are required to write into Bakers. Everything else stays hidden until you ask for it.

Line items

Only the Bakers item # is shown or written — the purchaser's own PO item numbers live in their database, not ours.

Description Bakers item # Qty Unit Price Cost Match
description
manual_review

Writes always post to B13-Test's TEST ACCOUNT 99999, regardless of the matched customer above.

Back to jobs
Debug log

Every extract step, parsed inventory row, write attempt, and the raw vision/Advantage responses stay here.

test order total must be between 0 and 50.00

  1. 2026-09-29T14:04:37 · received 222.webp
  2. 2026-09-29T14:04:38 · extract.start 222.webp (91948 bytes)
  3. 2026-09-29T14:04:38 · image 1 webp frame(s), 89336 bytes (from 91948)
  4. 2026-09-29T14:04:42 · vision.response { "sender_name": "Arnold Ben Saad", "sender_company": "Mandarin Oriental New York", "sender_email": "", "sender_phone": "212-805-8841", "account_number": "A10065027", "ship_to": "Shipping & Receiving, Mandarin Oriental New York, 80 Columbus Circle @ 60th Street, New York NY 10023", "requested_date": "2026-05-23", "custpo": "150823", "note": "", "line_items": [ { "raw_description": "Canape Brioche Sliced", "item": "106399", "quantity": 6.0, "unit": "EACH", "price": "14.20" }, { "raw_description": "Canape Whole Wheat Sliced", "item": "106398", "quantity": 6.0, "unit": "EACH", "price": "6.82" } ] }
  5. 2026-09-29T14:04:42 · parse 2 inventory row(s) from claude-sonnet-5
  6. 2026-09-29T14:04:42 · parse.line 1. qty=6.0 EA item=106399 | Canape Brioche Sliced @ 14.2
  7. 2026-09-29T14:04:42 · parse.line 2. qty=6.0 EA item=106398 | Canape Whole Wheat Sliced @ 6.82
  8. 2026-09-29T14:04:42 · extract 2 line(s), account A10065027
  9. 2026-09-29T14:04:44 · item 1. A11655S AP CANAPE BRIO SL qty=6.0 via description score=0.829
  10. 2026-09-29T14:04:44 · item 2. unmatched Canape Whole Wheat Sliced (item_unresolved); candidates A10719S 0.847, AS01114S 0.846, SS2002 0.792
  11. 2026-09-29T14:04:44 · draft 2 line(s); filled account, customer_name, ship_name, address0, city, state, zip, phone
  12. 2026-09-29T14:04:45 · directory A1006502 via directory_name (MANDARIN ORIENTAL HOTEL)
  13. 2026-09-29T14:06:39 · draft.save 2 line(s)
  14. 2026-09-29T14:06:49 · draft.save 2 line(s)
  15. 2026-09-29T14:06:49 · approve 2 line(s), account 99999
  16. 2026-09-29T14:06:49 · write.attempt Sending to Advantage (TEST ACCOUNT 99999): 2 line(s), total $126.12: A11655S qty=6 @ $14.20 = $85.20; A11655S qty=6 @ $6.82 = $40.92
  17. 2026-09-29T14:06:50 · write Advantage write failed: test order total must be between 0 and 50.00 | attempted: 2 line(s), total $126.12: A11655S qty=6 @ $14.20 = $85.20; A11655S qty=6 @ $6.82 = $40.92
Traceback (most recent call last):
  File "/home/dragon/ar-write-sandbox/webapp/intake.py", line 1362, in write_job
    result = create_test_order(
        items,
    ...<3 lines>...
        exec_fn=exec_fn,
    )
  File "/home/dragon/ar-write-sandbox/webapp/orders.py", line 317, in create_test_order
    clean = _normalize_lines(lines)
  File "/home/dragon/ar-write-sandbox/webapp/orders.py", line 162, in _normalize_lines
    raise ValueError(f"test order total must be between 0 and {MAX_TOTAL:.2f}")
ValueError: test order total must be between 0 and 50.00

Last write attempt

2 line(s), total $126.12: A11655S qty=6 @ $14.20 = $85.20; A11655S qty=6 @ $6.82 = $40.92

Vision API response

claude-sonnet-5 · stop

{
  "sender_name": "Arnold Ben Saad",
  "sender_company": "Mandarin Oriental New York",
  "sender_email": "",
  "sender_phone": "212-805-8841",
  "account_number": "A10065027",
  "ship_to": "Shipping & Receiving, Mandarin Oriental New York, 80 Columbus Circle @ 60th Street, New York NY 10023",
  "requested_date": "2026-05-23",
  "custpo": "150823",
  "note": "",
  "line_items": [
    {
      "raw_description": "Canape Brioche Sliced",
      "item": "106399",
      "quantity": 6.0,
      "unit": "EACH",
      "price": "14.20"
    },
    {
      "raw_description": "Canape Whole Wheat Sliced",
      "item": "106398",
      "quantity": 6.0,
      "unit": "EACH",
      "price": "6.82"
    }
  ]
}