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

Automator · Job 2ea5fa1d19e8

test123.webp

Advantage rejected the order write: [HY000] native=7200 [iAnywhere Solutions][Advantage SQL][ASA] Error 7200: AQE Error: State = 01004; NativeError = 2102; [iAnywhere Solutions][Advantage SQL Engine]Data truncated, column: DESCRIP -- Location of error in the SQL statement is: 188

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
item_code
item_code
item_code

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.

Advantage rejected the order write: [HY000] native=7200 [iAnywhere Solutions][Advantage SQL][ASA] Error 7200: AQE Error: State = 01004; NativeError = 2102; [iAnywhere Solutions][Advantage SQL Engine]Data truncated, column: DESCRIP -- Location of error in the SQL statement is: 188

  1. 2026-09-26T23:06:37 · received test123.webp
  2. 2026-09-26T23:06:37 · extract.start test123.webp (62594 bytes)
  3. 2026-09-26T23:06:38 · image 1 webp frame(s), 61798 bytes (from 62594)
  4. 2026-09-26T23:06:43 · vision.response { "sender_name": "Jose Mojica", "sender_company": "1 Hotel Brooklyn Bridge", "sender_email": "jose.mojica@1hotels.com", "sender_phone": "(347) 684-7556", "account_number": "", "ship_to": "1 Hotel Brooklyn Bridge, 60 Furman St, Brooklyn NY 11201, Brooklyn, NY, 11201, US, Attn: Jose Mojica", "requested_date": "09/06/2026", "custpo": "500470490-R6", "note": "No Notes", "line_items": [ { "raw_description": "Bagel Lg Cinnamon Raisin, Sliced", "item": "PB8004S", "quantity": 0.5, "unit": "DZ", "price": "10.6900" }, { "raw_description": "Bagel Lg Everything, Sliced", "item": "PB8005S", "quantity": 1.0, "unit": "DZ", "price": "10.7000" }, { "raw_description": "Bagel Lg Plain, Sliced", "item": "PB8001S", "quantity": 1.0, "unit": "DZ", "price": "10.7000" } ] }
  5. 2026-09-26T23:06:43 · parse 3 inventory row(s) from claude-sonnet-5
  6. 2026-09-26T23:06:43 · parse.line 1. qty=0.5 DZ item=PB8004S | Bagel Lg Cinnamon Raisin, Sliced @ 10.69
  7. 2026-09-26T23:06:43 · parse.line 2. qty=1.0 DZ item=PB8005S | Bagel Lg Everything, Sliced @ 10.7
  8. 2026-09-26T23:06:43 · parse.line 3. qty=1.0 DZ item=PB8001S | Bagel Lg Plain, Sliced @ 10.7
  9. 2026-09-26T23:06:43 · extract 3 line(s), account 1 Hotel Brooklyn Bridge
  10. 2026-09-26T23:06:45 · item 1. PB8004S PB BGL LG C/R SL qty=0.5 via item_code score=1.0
  11. 2026-09-26T23:06:45 · item 2. PB8005S PB BGL LG EV SL qty=1.0 via item_code score=1.0
  12. 2026-09-26T23:06:45 · item 3. PB8001S PB BGL LG PL SL qty=1.0 via item_code score=1.0
  13. 2026-09-26T23:06:45 · draft 3 line(s); filled account, customer_name, ship_name, address0, city, state, zip, phone
  14. 2026-09-26T23:07:26 · draft.save 3 line(s)
  15. 2026-09-26T23:07:26 · approve 3 line(s), account 99999
  16. 2026-09-26T23:07:26 · write.attempt Sending to Advantage (TEST ACCOUNT 99999): 3 line(s), total $26.74: PB8004S qty=0.5 @ $10.69 = $5.34; PB8005S qty=1 @ $10.70 = $10.70; PB8001S qty=1 @ $10.70 = $10.70
  17. 2026-09-26T23:07:40 · write Advantage rejected the order write: [HY000] native=7200 [iAnywhere Solutions][Advantage SQL][ASA] Error 7200: AQE Error: State = 01004; NativeError = 2102; [iAnywhere Solutions][Advantage SQL Engine]Data truncated, column: DESCRIP -- Location of error in the SQL statement is: 188 | attempted: 3 line(s), total $26.74: PB8004S qty=0.5 @ $10.69 = $5.34; PB8005S qty=1 @ $10.70 = $10.70; PB8001S qty=1 @ $10.70 = $10.70

Last write attempt

3 line(s), total $26.74: PB8004S qty=0.5 @ $10.69 = $5.34; PB8005S qty=1 @ $10.70 = $10.70; PB8001S qty=1 @ $10.70 = $10.70

Advantage response (why the write was rejected)

{
  "daydata": {
    "ok": false
  },
  "sysdata": {
    "ok": false,
    "results": [
      {
        "affected": -1,
        "index": 0,
        "kind": "dml",
        "ok": true
      },
      {
        "affected": 1,
        "index": 1,
        "kind": "dml",
        "ok": true
      },
      {
        "error": "[HY000] native=7200 [iAnywhere Solutions][Advantage SQL][ASA] Error 7200:  AQE Error:  State = 01004;   NativeError = 2102;  [iAnywhere Solutions][Advantage SQL Engine]Data truncated, column: DESCRIP -- Location of error in the SQL statement is: 188",
        "index": 2,
        "ok": false,
        "sql": "INSERT INTO INVOITEM (TYPE, INVOICE, ITEM, DESCRIP, QUANT, IOCOMQTY, PRICE, DISC, DATE_, UNIT, COST, ACCT, ACCTSUB, ROUTE, BAKING, QTYORD, DPRICE, APRICE) VALUES (\u0027I\u0027, 503839, \u0027PB8004S\u0027, \u0027Bagel Lg Cinnamon Raisin,\u0027, 0.5, 0.5, 10.69, 0, {d \u00272026-09-26\u0027}, \u0027DZ\u0027, 0.49, \u002799999\u0027, \u0027\u0027, \u00270000\u0027, \u0027AM1\u0027, 0.5, 10.69, 10.69)"
      }
    ],
    "returncode": 5,
    "stderr": "X connection to :99 broken (explicit kill or server shutdown).\n",
    "write": true
  }
}

Last write SQL sent to Advantage

BEGIN TRANSACTION
INSERT INTO INVOICES (SO, INVOICE, TYPE, DATE_, PERC_, NET, ACCT, ACCTSUB, CUSTPO, SUBTOTAL, INVTOTAL, TOTAL, TAXTOT, PRINT_, ROUTE, SEQ, BAKING, INVONAME, INVOADR0, INVOADR, INVOCITY, INVOST, INVOZIP, SHIPNAME, CONFIRMED, DUE, COST, POST, POSTDATE, POSTTIME, POSTUSER, LASTUSER, LASTDATE, LASTTIME, CREAUSER, CREADATE, CREATIME, SALESMAN, CATEGORY, DISCOUNT, FREIGHT, OTHER_, NOTE, UPDTLOG, AUCHPOST) VALUES (0, 503839, 'I', {d '2026-09-26'}, '', 0, '99999', '', 'EMAIL-ORD', 26.74, 0, 26.74, 0, True, '0000', 0, 'AM1', '11111 TEST ACCOUNT', '94 demarest mill rd', '', 'nanuet', 'NY', '10954-', '11111 TEST ACCOUNT', True, 0, 1.23, True, {d '2026-09-26'}, '23:07:37', 'B13WEB', 'B13WEB', {d '2026-09-26'}, '23:07:37', 'B13WEB', {d '2026-09-26'}, '23:07:37', '', '', 0, 0, 0, 'Email order intake', '09/26/2026 (23:07) by B13WEB: Created from email order (#   503839).
09/26/2026 (23:07) by B13WEB: Confirmed.
09/26/2026 (23:07) by B13WEB: Posted.', True)
INSERT INTO INVOITEM (TYPE, INVOICE, ITEM, DESCRIP, QUANT, IOCOMQTY, PRICE, DISC, DATE_, UNIT, COST, ACCT, ACCTSUB, ROUTE, BAKING, QTYORD, DPRICE, APRICE) VALUES ('I', 503839, 'PB8004S', 'Bagel Lg Cinnamon Raisin,', 0.5, 0.5, 10.69, 0, {d '2026-09-26'}, 'DZ', 0.49, '99999', '', '0000', 'AM1', 0.5, 10.69, 10.69)
INSERT INTO INVOITEM (TYPE, INVOICE, ITEM, DESCRIP, QUANT, IOCOMQTY, PRICE, DISC, DATE_, UNIT, COST, ACCT, ACCTSUB, ROUTE, BAKING, QTYORD, DPRICE, APRICE) VALUES ('I', 503839, 'PB8005S', 'Bagel Lg Everything, Slic', 1, 1, 10.70, 0, {d '2026-09-26'}, 'DZ', 0.49, '99999', '', '0000', 'AM1', 1, 10.70, 10.70)
INSERT INTO INVOITEM (TYPE, INVOICE, ITEM, DESCRIP, QUANT, IOCOMQTY, PRICE, DISC, DATE_, UNIT, COST, ACCT, ACCTSUB, ROUTE, BAKING, QTYORD, DPRICE, APRICE) VALUES ('I', 503839, 'PB8001S', 'Bagel Lg Plain, Sliced', 1, 1, 10.70, 0, {d '2026-09-26'}, 'DZ', 0.49, '99999', '', '0000', 'AM1', 1, 10.70, 10.70)
INSERT INTO CSAR (ACCT, ACCTSUB, ARNUM, INVNO, DATE_, DESCRIP, DEBIT, CREDIT, DUEDATE, PAID, REFERENCE, SUBTOTAL, TYPE, ARDATE, PERC_, NET, DUE, ROUTE, DRIVER, COST, SALESMAN, LASTUSER) VALUES ('99999', '', 205298, 503839, {d '2026-09-26'}, 'Email order', 26.74, 0, {d '2026-09-26'}, 'N', 'EMAIL-ORD', 26.74, 'I', {d '2026-09-26'}, '', 0, 0, '0000', '00000', 1.23, '', 'B13WEB')
UPDATE CSCUST SET DEBIT = DEBIT + 26.74 WHERE ACCT = '99999' AND (ACCTSUB = '' OR ACCTSUB IS NULL)
UPDATE CSINDEX SET INVOICE = 503839, NEXTAR = 205299, LASTPOST = {d '2026-09-26'}, LSTPOST2 = {d '2026-09-26'}
INSERT INTO ARLOGS (ACCT, ACCTSUB, DATE_, TIME_, USER_, UPDATE_) VALUES ('99999', '', {d '2026-09-26'}, '23:07', 'B13WEB', 'Email order invoice 503839 posted $26.74.')
COMMIT
SELECT ACCT, INVOICE, TOTAL, POST, POSTUSER FROM INVOICES WHERE INVOICE = 503839
SELECT ACCT, ARNUM, INVNO, DEBIT, PAID FROM CSAR WHERE ARNUM = 205298
BEGIN TRANSACTION
INSERT INTO WK392026HDR (SO, INVOICE, TYPE, DATE_, PERC_, NET, ACCT, ACCTSUB, CUSTPO, SUBTOTAL, INVTOTAL, TOTAL, TAXTOT, PRINT_, ROUTE, SEQ, BAKING, INVONAME, INVOADR0, INVOADR, INVOCITY, INVOST, INVOZIP, SHIPNAME, CONFIRMED, DUE, COST, POST, POSTDATE, POSTTIME, POSTUSER, LASTUSER, LASTDATE, LASTTIME, CREAUSER, CREADATE, CREATIME, SALESMAN, CATEGORY, DISCOUNT, FREIGHT, OTHER_, NOTE, UPDTLOG, AUCHPOST) VALUES (0, 503839, 'I', {d '2026-09-26'}, '', 0, '99999', '', 'EMAIL-ORD', 26.74, 0, 26.74, 0, True, '0000', 0, 'AM1', '11111 TEST ACCOUNT', '94 demarest mill rd', '', 'nanuet', 'NY', '10954-', '11111 TEST ACCOUNT', True, 0, 1.23, True, {d '2026-09-26'}, '23:07:37', 'B13WEB', 'B13WEB', {d '2026-09-26'}, '23:07:37', 'B13WEB', {d '2026-09-26'}, '23:07:37', '', '', 0, 0, 0, 'Email order intake', '09/26/2026 (23:07) by B13WEB: Created from email order (#   503839).
09/26/2026 (23:07) by B13WEB: Confirmed.
09/26/2026 (23:07) by B13WEB: Posted.', True)
INSERT INTO WK392026ITM (TYPE, INVOICE, ITEM, DESCRIP, QUANT, IOCOMQTY, PRICE, DISC, DATE_, UNIT, COST, ACCT, ACCTSUB, ROUTE, BAKING, QTYORD, DPRICE, APRICE) VALUES ('I', 503839, 'PB8004S', 'Bagel Lg Cinnamon Raisin,', 0.5, 0.5, 10.69, 0, {d '2026-09-26'}, 'DZ', 0.49, '99999', '', '0000', 'AM1', 0.5, 10.69, 10.69)
INSERT INTO WK392026ITM (TYPE, INVOICE, ITEM, DESCRIP, QUANT, IOCOMQTY, PRICE, DISC, DATE_, UNIT, COST, ACCT, ACCTSUB, ROUTE, BAKING, QTYORD, DPRICE, APRICE) VALUES ('I', 503839, 'PB8005S', 'Bagel Lg Everything, Slic', 1, 1, 10.70, 0, {d '2026-09-26'}, 'DZ', 0.49, '99999', '', '0000', 'AM1', 1, 10.70, 10.70)
INSERT INTO WK392026ITM (TYPE, INVOICE, ITEM, DESCRIP, QUANT, IOCOMQTY, PRICE, DISC, DATE_, UNIT, COST, ACCT, ACCTSUB, ROUTE, BAKING, QTYORD, DPRICE, APRICE) VALUES ('I', 503839, 'PB8001S', 'Bagel Lg Plain, Sliced', 1, 1, 10.70, 0, {d '2026-09-26'}, 'DZ', 0.49, '99999', '', '0000', 'AM1', 1, 10.70, 10.70)
COMMIT
SELECT ACCT, INVOICE, TOTAL, POST FROM WK392026HDR WHERE INVOICE = 503839

Vision API response

claude-sonnet-5 · stop

{
  "sender_name": "Jose Mojica",
  "sender_company": "1 Hotel Brooklyn Bridge",
  "sender_email": "jose.mojica@1hotels.com",
  "sender_phone": "(347) 684-7556",
  "account_number": "",
  "ship_to": "1 Hotel Brooklyn Bridge, 60 Furman St, Brooklyn NY 11201, Brooklyn, NY, 11201, US, Attn: Jose Mojica",
  "requested_date": "09/06/2026",
  "custpo": "500470490-R6",
  "note": "No Notes",
  "line_items": [
    {
      "raw_description": "Bagel Lg Cinnamon Raisin, Sliced",
      "item": "PB8004S",
      "quantity": 0.5,
      "unit": "DZ",
      "price": "10.6900"
    },
    {
      "raw_description": "Bagel Lg Everything, Sliced",
      "item": "PB8005S",
      "quantity": 1.0,
      "unit": "DZ",
      "price": "10.7000"
    },
    {
      "raw_description": "Bagel Lg Plain, Sliced",
      "item": "PB8001S",
      "quantity": 1.0,
      "unit": "DZ",
      "price": "10.7000"
    }
  ]
}