done●
invoice_number not found based on rule 'PACKINGLISTNo'.; supplier country not found based on rule 'following PHONE: in supplier header'.; AWB number not found based on rule 'HAWB substring in MAWB# line'.; Item '1': boxes (колонка 20) not found, value set to null.; Item '1': plantation (колонка 9) not found, value set to null.; Item '1': variety (колонка 15) not found, value set to null.; Item '1': quantity (колонка 23) not found, value set to null.; Calculated total_stems is null because no item quantities were extracted.; Calculated sum of items[].boxes is null, cannot match with summary.total_boxes (0.13).
done●
Supplier 'DATE' кажется неверным, так как это заголовок колонки, а не название компании.; Не удалось извлечь страну по правилу ('PHONE:' в шапке поставщика).; Не удалось извлечь AWB по правилу (подстрока 'HAWB' не найдена в строке 'MAWB#').; Для item '1': не удалось извлечь 'variety' (колонка 15) из-за несоответствия индексов в OCR-данных.; Для item '1': не удалось извлечь 'quantity' (колонка 23) из-за несоответствия индексов в OCR-данных.; Расхождение: сумма box_number (1) не совпадает с summary.total_boxes (0.13).
done●
The column indices provided in the rules did not perfectly match the actual OCR table header. Adjustments were made to map to the correct data (e.g., 'Order' is index 2, not 1; 'Bun/Box' for item quantity is index 12, not 6; 'Stems' for total stems is index 14; 'Total' for item/summary amount is index 16, not 10).; Item 1: plantation field is null, but rule for generating box_number requires it if box_number is empty (not the case here).; Calculated sum of items[].quantity (4) does not match summary.total_stems (100). The `Bun/Box` column was used for item quantity (4), while the `Stems` column (100) was used for summary total stems, implying they represent different metrics.; Calculated sum of items[].boxes (1) does not match expected total boxes (null). The 'Boxes' column in the 'Totals' row was empty.; Summary total_boxes could not be extracted and is null.
done●
summary.total_boxes (2.5) does not match the sum of items' boxes (19). This may indicate that 'TOT.BOX' in the OCR does not refer to the count of physical boxes.; summary.total_stems (1950) has a minor discrepancy with sum(items[].quantity) (1950.05).; summary.total_amount (389.25) has a minor discrepancy with sum(items[].total_price) (389.26).
done●
invoice_number: Rule pattern 'PACKING' not found; used 'INVOICE' from col 0 of table row for extraction.; invoice_date: Rule pattern 'Date Amount PO # Terms' not found in col 0; used 'Date' from col 1 of table row for extraction.; supplier: Rule asked for col 1 of next row; col 1 was empty, used col 0 for extraction.; country: Rule asked for col 1 of row following address; col 1 was empty, used value from col 0 for extraction.; awb: Rule using 'Carrier' from table resulted in carrier name; actual AWB extracted from header_text.; items: Item data not found in 'table' section as expected by rules; extracted from 'header_text'.; summary.total_amount: Rule asked for col 2; col 2 was empty, used value from col 1 for extraction.; Validation: sum(items.quantity) (3000) != summary.total_stems (3500).; Validation: sum(items.total_price) (720.0) != summary.total_amount (830.0).; Validation: sum(items.boxes) (4) != summary.total_boxes (7).
done●
Rule check: Expected total_amount of $320.00 does not match calculated total_amount of $287.50.; Rule check: Expected total_stems of 700 does not match calculated total_stems of 250.