done●
Item 3: box_number 'TOTAL' is not a standard box identifier.; Discrepancy in total stems: Sum of item quantities (350) does not match summary total stems (75).; Discrepancy in total boxes: Sum of item boxes (3) does not match summary total boxes (14).
done●
Item 3: box_number is empty, inherited from previous item.; Item 5: box_number is empty, inherited from previous item.; Summary total_stems could not be extracted directly from the TOTAL row as per rules.; Calculated total_boxes (9) does not match summary total_boxes (81).; Calculated total_stems (2125) does not match summary total_stems (null).
FACT EXPORTACION 0256781 TDA - OOO TRADE HOUSE AZALIA H 16_39_06.pdf
001001
19/03/2026
invoice
done●
Invoice type B (flat), 12 physical boxes detected. Severe issues with column mapping from rules to OCR table data resulted in null/zero values for quantity, unit_price, and total_price. Multi-box unfolding not applicable.
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.