SJ/JEI_Import_Documents-App
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
JEI_Import_Documents-App/data/review/ocr/JEI SA PROFORMA 151778.txt

268 lines
9.5 KiB
Text
Raw Permalink Normal View History

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 04:12:30 +00:00
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
Ns
www.jeiuk.com TTT TTT TIT iri
VAT Reg No: 227257212 .
__EORINo: _GB227257212000 Built for Industry
K2023742851 SOUTH AFRICA (Pty) LTD Invoice No 151778
T/A JEI SOUTH AFRICA Invoice Date 11/04/2025
47 STATION STREET OBERHOLZER
CARLETONVILLE, 2499 SOUTH AFRICA Sales Order No
VAT Reg No: 4450314382 Customer Order No | TCT & END +
Shipping Term: Account Ref JEISA000 j
Quantity Stock Code Description Unit Price Net Amt
2.00 JEITCS12 TURBO TOUGH, 12MM X 40MM TCT (6MM PILOT) 12.75 25.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEITCS14 TURBO TOUGH, 14MM X 40MM TCT (6MM PILOT) 12.75 63.75
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEITCS16 TURBO TOUGH, 16MM X 40MM TCT (6MM PILOT) 12.90 64.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
20.00 JEITCS18 TURBO TOUGH, 18MM X 40MM TCT (8MM PILOT) 13.05 261.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEITCS20 TURBO TOUGH, 20MM X 40MM TCT (8MM PILOT) 13.20 66.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
20.00 JEITCS22 TURBO TOUGH, 22MM X 40MM TCT (8MM PILOT) 13.50 270.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEITCS24 TURBO TOUGH, 24MM X 40MM TCT (8MM PILOT) 13.50 67.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEITCS26 TURBO TOUGH, 26MM X 40MM TCT (8MM PILOT) 14.55 72.75
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
2.00 JEITCS28 TURBO TOUGH, 28MM X 40MM TCT (8MM PILOT) 14.55 29.10
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
2.00 JEITCS30 TURBO TOUGH, 30MM X 40MM TCT (8MM PILOT) 14.55 29.10
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
2.00 JEITCS32 TURBO TOUGH, 32MM X 40MM TCT (8MM PILOT) 15.45 30.90
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
1 Pallet, 223kg, 120x100x60cm
Customs Code: CU25426972
=== PAGE BREAK ===
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
Ns
www.jeiuk.com TTT TTT TIT iri
VAT Reg No: 227257212 .
__EORINo: __GB227257212000 Built for Industry
K2023742851 SOUTH AFRICA (Pty) LTD Invoice No 151778
T/A JEI SOUTH AFRICA Invoice Date 11/04/2025
47 STATION STREET OBERHOLZER
CARLETONVILLE, 2499 SOUTH AFRICA Sales Order No
VAT Reg No: 4450314382 Customer Order No TCT & END +
Shipping Term: Account Ref JEISA000 j
Quantity Stock Code Description Unit Price Net Amt
2.00 JEITCL12 TURBO TOUGH, 12MM X 55MM TCT (6MM PILOT) 14.25 28.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
10.00 JEITCL14 TURBO TOUGH, 14MM X 55MM TCT (6MM PILOT) 15.00 150.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEITCL16 TURBO TOUGH, 16MM X 55MM TCT (6MM PILOT) 15.00 75.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
20.00 JEITCL18 TURBO TOUGH, 18MM X 55MM TCT (8MM PILOT) 15.00 300.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEITCL20 TURBO TOUGH, 20MM X 55MM TCT (8MM PILOT) 15.00 75.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
10.00 JEITCL22 TURBO TOUGH, 22MM X 55MM TCT (8MM PILOT) 15.75 157.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
2.00 JEITCL24 TURBO TOUGH, 24MM X 55MM TCT (8MM PILOT) 15.75 31.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
2.00 JEITCL26 TURBO TOUGH, 26MM X 55MM TCT (8MM PILOT) 19.50 39.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
2.00 JEITCL28 TURBO TOUGH, 28MM X 55MM TCT (8MM PILOT) 19.50 39.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
2.00 JEITCL30 TURBO TOUGH, 30MM X 55MM TCT (8MM PILOT) 19.50 39.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
20.00 JEIPILOT1/TCTS PILOT TO SUIT 12/17MM TCT SHORT 1.31 26.20
COMMODITY CODE: 82078090 COUNTRY OF ORIGIN:CN
1 Pallet, 223kg, 120x100x60cm
=== PAGE BREAK ===
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
Ns
Built for Industry
__EORINo: _GB227257212000
K2023742851 SOUTH AFRICA (Pty) LTD Invoice No 151778
T/A JEI SOUTH AFRICA Invoice Date 11/04/2025
47 STATION STREET OBERHOLZER CARLETONVILLE,
2499 SOUTH AFRICA Sales Order No
VAT Reg No: 4450314382 Customer Order No | TCT & END +
Shipping Term: Account Ref JEISA000 j
Quantity Stock Code Description Unit Price Net Amt
20.00 JEIPILOT1/8MM PILOT PIN 40MM DEPTH (8MM DIA) 1.80 36.00
COMMODITY CODE: 82078090 COUNTRY OF ORIGIN:CN
20.00 JEIPILOT2 PILOT PIN 2" 1.31 26.20
COMMODITY CODE: 82078090 COUNTRY OF ORIGIN:CN
20.00 JEIPILOT2/8MM PILOT PIN 2" DEPTH (8MM DIA) 2.25 45.00
COMMODITY CODE: 82078090 COUNTRY OF ORIGIN:CN
10.00 JEIETCS12 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 12MM X 1" 25.00 250.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
15.00 JEIETCS14 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 14MM X 1" 25.00 375.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
15.00 JEIETCS16 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 16MM X 1" 25.83 387.45
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
30.00 JEIETCS18 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 18MM X 1" 26.67 800.10
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
10.00 JEIETCS20 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 20MM X 1" 27.50 275.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
30.00 JEIETCS22 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 22MM X 1" 28.33 849.90
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
10.00 JEIETCS24 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 24MM X 1" 28.33 283.30
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
10.00 JEIETCS26 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 26MM X 1" 30.00 300.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
1 Pallet, 223kg, 120x100x60cm
=== PAGE BREAK ===
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
Ns
www.jeiuk.com TIE T TTI)
VAT Reg No: 227257212 .
; EORI No: GB227257212000 Built for Industry
K2023742851 SOUTH AFRICA (Pty) LTD Invoice No 151778
T/A JEI SOUTH AFRICA Invoice Date 11/04/2025
47 STATION STREET OBERHOLZER CARLETONVILLE,
2499 SOUTH AFRICA Sales Order No
VAT Reg No: 4450314382 Customer Order No | TCT & END +
Shipping Term: Account Ref JEISA000 j
Quantity Stock Code Description Unit Price Net Amt
10.00 JEIETCS28 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 28MM X 1" 30.00 300.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
5.00 JEIETCS30 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 30MM X 1" 30.00 150.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
5.00 JEIETCS32 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 32MM X 1" 32.50 162.50
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
10.00 JEIETCL12 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 12MM X 2" 27.78 277.80
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
15.00 JEIETCL14 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 14MM X 2" 27.78 416.70
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
2.00 JEIETCL16 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 16MM X 2" 28.70 57.40
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
15.00 JEIETCL18 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 18MM X 2" 29.63 444.45
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
10.00 JEIETCL20 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 20MM X 2" 30.56 305.60
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
30.00 JEIETCL22 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 22MM X 2" 31.48 944.40
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
10.00 JEIETCL24 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 24MM X 2" 31.48 314.80
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
10.00 JEIETCL26 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 26MM X 2" 33.33 333.30
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
1 Pallet, 223kg, 120x100x60cm
=== PAGE BREAK ===
JEI DRILLING & CUTTING SOLUTIONS LTD INVOICE
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY
BURNLEY
LANCASHIRE J
BB12 6LT
Tel : 01706 229490
Email : sales@jeisolutions.co.uk re) U ions
www.jeiuk.com TIE T TTI)
VAT Reg No: 227257212 .
; EORI No: GB227257212000 Built for Industry
K2023742851 SOUTH AFRICA (Pty) LTD Invoice No 151778
T/A JEI SOUTH AFRICA Invoice Date 11/04/2025
47 STATION STREET OBERHOLZER
CARLETONVILLE, 2499 SOUTH AFRICA Sales Order No
VAT Reg No: 4450314382 Customer Order No TCT & END +
Shipping Term: Account Ref JEISA000 j
Quantity Stock Code Description Unit Price Net Amt
10.00 JEIETCL28 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 28MM X 2" 33.33 333.30
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
5.00 JEIETCL30 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 30MM X 2" 33.33 166.65
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
5.00 JEIETCL32 TURBO ENDURANCE+ SUPER TOUGH TCT CUTTER, 32MM X 2" 36.11 180.55
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
5.00 JEITCSK-50 TURBO-TOUGH COUNTERSINK 50MM, 90DEG (14-50MM) 101.25 506.25
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEIETCSK-50 TURBO ENDURANCE+ SUPER TOUGH COUNTERSINK 14-50MM150.00 750.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
2.00 JEIETCSK-60 ENDURANCE PLUS TCT COUNTERSINK - 60MM (14- 60MM) 162.50 325.00
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:GB
1 Pallet, 223kg, 120x100x60cm
Deliver To : Total Net Amount 11,537.45
SOUTH AFRICA (PTY) LTD
T/A JEI SOUTH AFRICA
47 STATION STREET
OBERHOLZER
Total VAT Amount —
CARLETONVILLE, 2499 \
SOUTH AFRICA pA Invoice Total 12,592.45
Payment Terms : PAID IN FULL
Page 5
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: 11/04/2025; Place: Burnley Signed: Adina Pollard, General Manager
Reference in a new issue Copy permalink