JEI_Import_Documents-App/data/review/ocr/JEI Drilling Invoices.txt
Mavis 006a324081 feat: OCR scanned PDFs and capture all 11 missing stock codes
- Installed Tesseract OCR via winget
- Added scripts/ocr_invoices.py to OCR all PDFs via PyMuPDF
- Updated extract_invoices.py to fall back to OCR text for scanned pages
- Fixed stock-code regex to match "qty + code" pairs only (avoids spurious
  matches like bare TCT in invoice headers)
- Added merge step to combine multi-page proformas into single invoice records
- All 11 previously-missing codes now in PB:
  JEITCS12, JEITCS18, JEITCS22, JEITCL22, JEITCL92,
  JEICS17, JEICS19, JEICS27, JEICS30, JEICS34, JEICS14-P1
- Only JEITCS50 remains unlisted (genuinely never ordered)

PB now: 19 invoices, 158 stock codes, 281 line items
2026-09-18 06:12:30 +02:00

303 lines
6.4 KiB
Text

JEI DRILLING & CUTTING SOLUTIONS LTD INVOICE
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY
BURNLEY
LANCASHIRE
BB12 6LT
Tel : 01706 229490
Email : sales@jeisolutions.co.uk
www.jeiuk.com
VAT Reg No: 227257212
EORI No: GB227257212000
K2023742851 SOUTH AFRICA (PTY) LTD
Invoice No 154923
T/A JEI SOUTH AFRICA | |
47 STATION STREET Invoice Date 12/08/2025 |
OBERHOLZER
CARLETONVILLE, 2499 Sales Order No 149943
SOUTH AFRICA Customer Order No | Email 28.07.25
VAT Reg No: 4450314382 L :
Shipping Term: [ Account Ref JEISA000 al
Solutions
Built for Industry
—
Quantity Stock Code Description
Unit Price Net Amt Ey
27.00 JEIETCL16
TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 16MM X 2" 28.05 757.35
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
20.00 JEIETCL18 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 18MM X 2" 28.05 561.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
2.00 JEITCL50 TURBO TOUGH, 50MM X 55MM TCT (8MM PILOT) 44.55 89.10
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
Customs Code: CU25426972
1 Box, 5.63kg, 40x26x15cm
Dated: 12/08/2025
Deliver To :
SHIPLEY GLOBAL EVENTS (PTY)
678 MIRROR CARD STREET
GARSFONTEIN
PRETORIA
SOUTH AFRICA \
0042 -
Payment Terms : PAID IN FULL
Total Net Amount 1,407.45
Carriage Net
Total VAT Amount
Invoice Total £ 1,509.45
Page 1
Clearly marked to addressee. The exporter of the products covered by this document (EORI No:
GB227257212000) declares that except where otherwise indicated, the products are of GB preferential
origin" Date: 12/08/2025; Place: Burnley Signed: Adina Pollard, General Manager
=== PAGE BREAK ===
JEI DRILLING & CUTTING SOLUTIONS LTD INVOICE
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY
BURNLEY =
BB12 6LT 2
Tel : 01706 229490
Email : sales@jeisolutions.co.uk oO U 1 oO n Ss
www. jeiuk.com TTT III
VAT Reg No: 227257212 ai
EORINo: _GB227257212000 Built for Indust
K2023742851 SOUTH AFRICA (PTY) LTD
T/A JEI SOUTH AFRICA
47 STATION STREET
OBERHOLZER
fimo SS
CARLETONVILLE, 2499
SOUTH AFRICA
VAT Reg No: 4450314382
Shipping Term:
Quantity Stock Code Description Unit Price Net Amt
1.00 JEITCL92 TURBO TOUGH, 92MM X 55MM TCT (32MM SHANK) 116.67 116.67
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
30.00 JEIPILOT2/8MM PILOT PIN 2" DEPTH (8MM DIA) 2.50 75.00
COMMODITY CODE: 82078090 COUNTRY OF ORIGIN:CN
4.00 JEIRCSE30 TURBO RAIL TCT CUTTER "ENDURANCE PLUS", 30MM 48.29 193.16
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
1 Box, 12.77kg, 39x38x24cm
Customs Code: CU25426972
Dated: 09.09.25
w
Deliver To : Total Net Amount =| £ 384.83
SHIPLEY GLOBAL EVENTS (PTY)
678 MIRROR CARD STREET Carriage Net £ 80.00
GARSFONTEIN
PRETORIA Total VAT Amount £ 0.00
SOUTH AFRICA \
0042 pA [ Invoice Total £ 464.83
Payment Terms : 30 Days Ns:
Clearly marked to addressee. The exporter of the products covered by this document (EORI No:
GB227257212000) declares that except where otherwise indicated, the products are of GB preferential
origin" Date: 09/09/2025; Place: Burnley Signed: Adina Pollard, General Manager
=== PAGE BREAK ===
JEI DRILLING & CUTTING SOLUTIONS LTD INVOICE
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY /
BURNLEY )/
BB1i2 6LT ; :
Tel : 01706 229490 7
Email : sales@jeisolutions.co.uk @) Ul ions
2 ca PTITiILitiitiif titi iii
VAT Reg No: =
EORINo: _GB227257212000 Built for Indust
K2023742851 SOUTH AFRICA (PTY) LTD Invoice No 155743
T/A JEI SOUTH AFRICA A
47 STATION STREET Invoice Date 11/09/2025
OBERHOLZER
CARLETONVILLE, 2499 | Sales Order No 151137 a
SOUTH AFRICA Customer Order No Email Gary
VAT Reg No: 4450314382
Shipping Term: | Account Ref JEISA000 :
“2 ~\
Quantity Stock Code Description Unit Price Net Amt
ee demas =)
12.00 JEIHS-SET6 1" DEPTH TCT HOLESAW SET (6 PIECE) 16,18,19,20,22 & 25MM65.83 789.96
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEIHS-26 TCT HOLESAW, 26MM (1" DEPTH) 13.88 69.40
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEIHS-32 TCT HOLESAW, 32MM (1" DEPTH) 16.67 83.35
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEIHS-40 TCT HOLESAW, 40MM (1" DEPTH) 27.83 139.15
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEIHS-50 TCT HOLESAW, 50MM (1" DEPTH) 32.50 162.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
Box 1, 14.29kg, 41x41x42cm
Box 2, 4.64kg, 36x27x21cm
Customs Code: CU25426972
Dated: 11.09.25 =
Deliver To : Total Net Amount
SHIPLEY GLOBAL EVENTS (PTY)
678 MIRROR CARD STREET Carriage Net
GARSFONTEIN
PRETORIA Total VAT Amount 0.00
SOUTH AFRICA r\
0042 pA [ invoice Total £ 1,454.36
Payment Terms : 30 Days rons!
Clearly marked to addressee. The exporter of the products covered by this document (EORI No:
GB227257212000) declares that except where otherwise indicated, the products are of GB preferential
origin" Place: Burnley Signed: Adina Pollard, General Manager
=== PAGE BREAK ===
JEI DRILLING & CUTTING SOLUTIONS LTD INVOICE
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY
BURNLEY
LANCASHIRE
BB12 6LT
Tel : 01706 229490 he
Email : sales@jeisolutions.co.uk @) Ul ions
www.jeiuk.com PITT TIT T TI tii)
VAT Reg No: 227257212 Built for Indust
EORI No: GB227257212000
156092
K2023742851 SOUTH AFRICA (PTY) LTD
T/A JEI SOUTH AFRICA
47 STATION STREET
OBERHOLZER
Invoice No
Invoice Date 25/09/2025
Sales Order No 151221
CARLETONVILLE, 2499
SOUTH AFRICA
VAT Reg No: 4450314382
Shipping Term: DAP - Delivered at Place [2020]
Customer Order No Email 12.09.25
Account Ref JEISA000
| Quantity Stock Code Description Unit Price Net Amt }
2.00 JEISDT-SET3 STEP DRILL SET, TURBO GOLD SPIRAL FLT 49.98 99.96
COMMODITY CODE: 82075060 COUNTRY OF ORIGIN:CN
2.00 JEITBR-SETS 19MM SHANK REAMER SET 14,18,22,26,32 + SOCKETS 270.00 540.00
COMMODITY CODE: 82079091 COUNTRY OF ORIGIN:CN
5.00 JEICSK-30 TURBO-STEEL COUNTERSINK, 30MM, 90DEG (4-30MM) 27.50 137.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
3.00 JEIETCSK-50 TURBO ENDURANCE+ SUPER TOUGH COUNTERSINK 14-50MM150.00 450.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
Box 1, 8.94kg, 40x27x26cm
Customs Code: CU25426972
Dated: 25.09.25
Deliver To : Total Net Amount 1,227.46
SHIPLEY GLOBAL EVENTS (PTY)
678 MIRROR CARD STREET Carriage Net
GARSFONTEIN
PRETORIA Total VAT Amount
SOUTH AFRICA FN
0042 pA Invoice Total £ 1,332.46
1
Payment Terms : 30 Days =
Clearly marked to addressee. The exporter of the products covered by this document (EORI No:
GB227257212000) declares that except where otherwise indicated, the products are of GB preferential
origin" Date: 25/09/2025; Place: Burnley Signed: Adina Pollard, General Manager