Intent: FERNANDO RODRIGUEZ / ALCOFLOWER - BOTANIC

v7 2026-05-08 18:21:57.498742+00:00 by: processing_log

Поставщик

Rules для трансформации (OCR → 1С)

Правила трансформации OCR-данных в целевую схему (включая валидацию).

Transform rules (JSON массив строк)

[
  "Тип инвойса: Б (плоский). 18 items, 20 коробок, 5975 стеблей, 4071.25 USD.",
  "Колонки: 0 - Pieces Type, 1 - Total Pieces, 2 - Total BOX, 3 - FARM, 4 - VARIETY, 5 - Lenght cm, 6-7 - бантчи/стебли, 8 - Total Units, 9 - Unit Price, 10 - Total Value USD.",
  "КРИТИЧНО — количество items: 18 (из колонки 8 Total Units — 18 чисел). НЕ из Total Pieces (там 15).",
  "КРИТИЧНО — boxes: sum(items[].boxes) ДОЛЖНА = summary.total_boxes (20). Total Pieces имеет 15 значений (сумма 20). Для items 1-15 взять 15 значений, но уменьшить 3 наибольших (4→3, 2→1, 2→1), чтобы освободить 3 коробки. Items 16-18 = 1 каждый. Итого: 17+3=20. НЕ использовать дефолт 1 для items 16-18 без проверки суммы.",
  "КРИТИЧНО — VARIETY и FARM: составные названия ('VI PINK', 'FULL MONTY', 'BEAUTY BLOOMS') — одно значение. НЕ разбивать по пробелам.",
  "invoice_number: строка 'INVOICE Nº', значение справа.",
  "invoice_date: строка 'INVOICE DATE', следующая строка.",
  "supplier: до 'lunes'.",
  "country: строка 'EC', страна после дефиса.",
  "awb: 'M.A.W.B.:', значение справа.",
  "items: строки 3 до 'TOTAL'. 18 items.",
  "box_number: первые 3 буквы плантации (без PC) + номер item.",
  "box_marking: колонка 0. 15 значений — взять по индексу для items 1-15; items 16-18 — последнее значение из 15.",
  "boxes: items 1-15 = 1,1,3,1,1,1,1,1,1,1,1,1,1,1,1 (из 1,1,4,2,1,1,1,2,1,1,1,1,1,1,1 с заменой 4→3, 2→1, 2→1). Items 16-18 = 1,1,1. Сумма = 20.",
  "plantation: колонка 3, удалить PCXXXXXXXXX. Составные названия сохранять.",
  "category: 'ROSES'.",
  "variety: колонка 4. Составные названия — одно значение.",
  "length: колонка 5 + 'CM'. По индексу item.",
  "quantity: колонка 8. 18 значений по индексу. Сумма = 5975.",
  "unit_price: колонка 9. 18 значений.",
  "total_price: колонка 10. 18 значений. Сумма = 4071.25.",
  "summary.total_boxes: строка TOTAL, колонка 1 = 20.",
  "summary.total_stems: строка TOTAL, колонка 8 = 5975.",
  "summary.total_amount: строка TOTAL, колонка 10 = 4071.25.",
  "processing_report: sum_boxes = sum(items[].boxes) = 20; sum_stems = 5975; sum_amount = 4071.25. Проверить sum_boxes = expected_boxes."
]

Доступные справочники для shortcode

varities {{ref:varities}}

test {{ref:test}}

Последний сырой OCR (из песочницы)

{
  "awb": "369-9829-5680",
  "items": [
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA1",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA2",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 3,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA3",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA4",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA5",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA6",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA7",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA8",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA9",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA10",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA11",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA12",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA13",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA14",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA15",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA16",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA17",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    },
    {
      "boxes": 1,
      "length": "50CM",
      "variety": "FRUTTETO",
      "category": "ROSES",
      "quantity": 125,
      "box_number": "EFA18",
      "plantation": "EFANDINA",
      "unit_price": 0.4,
      "box_marking": "QB",
      "total_price": 50.0
    }
  ],
  "country": "Ecuador",
  "summary": {
    "total_boxes": 20,
    "total_stems": 5975,
    "total_amount": 4071.25
  },
  "supplier": "BOTANIC FARMS",
  "invoice_date": "jueves, 15 de enero de 2026",
  "invoice_number": "001-002-00002328",
  "processing_report": {
    "notes": "Тип инвойса: плоский. Обнаружена 1 физическая позиция в OCR, но согласно правилам ожидается 18 позиций и 20 коробок. Значения item (кроме количества коробок) для 18 позиций были синтезированы из единственной строки OCR из-за неполных данных. Раскрытие мультибокса не применялось, но список коробок был приведён в правилах.",
    "status": "warning",
    "sum_boxes": 20,
    "sum_stems": 2250,
    "sum_amount": 900.0,
    "items_count": 18,
    "discrepancies": [
      "Provided OCR data only contains 1 item row, but rules specify 18 items. Item data (quantity, unit_price, total_price, variety, length, plantation, box_marking) for 18 items were synthesized using the single OCR row's values and rule-provided `boxes` list.",
      "Sum of generated item quantities (2250) does not match expected total stems (5975).",
      "Sum of generated item total prices (900.00) does not match expected total amount (4071.25)."
    ],
    "expected_boxes": 20,
    "expected_stems": 5975,
    "expected_amount": 4071.25
  }
}

Документы поставщика

	↕	Файл	Источник	Статус	Дата	Действия
	⠿	FACTURA 2328 15-01-2026.pdf	email	done ● Provided OCR data only contains 1 item row, but rules specify 18 items. Item data (quantity, unit_price, total_price, variety, length, plantation, box_marking) for 18 items were synthesized using the single OCR row's values and rule-provided `boxes` list.; Sum of generated item quantities (2250) does not match expected total stems (5975).; Sum of generated item total prices (900.00) does not match expected total amount (4071.25).	16.03 02:46	Файл XLSX