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/1.Invoice_29.05.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

281 lines
6.4 KiB
Text
Raw Permalink Blame History

JEI DRILLING & CUTTING SOLUTIONS LTD
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY
BURNLEY Viypyihhy
LANCASHIRE =
eee Solutions
Tel : 01706 229490
Email : sales@jeisolutions.co.uk TIT TTITI Ti iirrriiiiiiiig
www.jeiuk.com +
VAT Reg No: 227257212 Built for Industry
EORINo: GB227257212000 INVOICE Page 1
K2023742851 SOUTH AFRICA (PTY) LTD Invoice No 161453
T/A JE] SOUTH AFRICA .
47 STATION STREET Invoice Date 14/04/2026
OBERHOLZER
CARLETONVILLE, 2499 Sales Order No 156861
SOUTH AFRICA Customer Order No PO-20260409-001
Account Ref JEISA000
. er Unit DiscAmt Net VAT
{quantity Stock Code Description Price % Amt 20% ]
1.00 DRILL-HM50T/2 DRILLING MACHINE 220V, HM50T (TAPPING) 844.00 0.00 844.00 0.00
1.00 SERIAL SERIAL # 3105 0.00 0.00 0.00 0.00
Deliver To : Total Net Amount 844.00 |
SHIPLEY GLOBAL EVENTS (PTY)
678 MIRROR CARD STREET Carriage Net 280.00
GARSFONTEIN
PRETORIA Total 20% VAT 0.00
SOUTH AFRICA
0042 Invoice Total 1,124.00
Payment Terms : 30 Days
Company Bank Details:
Bank name: Barclays Bank
Bank Address: 72-78 James Street, Burnley, Lancashire, BB11 1NH
Currency: Sterling
Sort Code: 20-15-70
Account: 63517993
BIC: BUKBGB22
IBAN: GB74BUKB2015706351 7993
=== PAGE BREAK ===
JEI DRILLING & CUTTING SOLUTIONS LTD INVOICE
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY
BURNLEY
LANCASHIRE
BB12 6LT
01706 229490
: sales@jeisolutions.co.uk
Tel :
Email
www.jeiuk.com
VAT Reg No: 227257212
EORI No:
GB227257212000
Solutions
Built for Industry
K2023742851 SOUTH AFRICA (PTY) LTD
T/A JEL SOUTH AFRICA
47 STATION STREET
OBERHOLZER
CARLETONVILLE, 2499
SOUTH AFRICA
VAT Reg No: 4450314382
Invoice No 161454
Invoice Date 14/04/2026
Sales Order No 156826
Customer Order No
PO-20260409-002
Incoterm: DAP - Delivered at Place [2020] Account Ref JEISAOOO J
Quantity Stock Code Description Unit Price Net Amt
5.00 JEITCS28 TURBO TOUGH, 28MM X 40MM TCT (8MM PILOT) 16.17 80.85
COMMODITY CODE: 82075090
COUNTRY OF ORIGIN: CN
5.00 JEITCS30 TURBO TOUGH, 30MM X 40MM TCT (8MM PILOT) 16.17 80.85
COMMODITY CODE: 82075090
COUNTRY OF ORIGIN: CN
5.00 JEITCS32 TURBO TOUGH, 32MM X 40MM TCT (8MM PILOT) 17.17 85.85
COMMODITY CODE: 82075090
COUNTRY OF ORIGIN: CN
5.00 JEITCL28 TURBO TOUGH, 28MM X 55MM TCT (8MM PILOT) 21.67 108.35
COMMODITY CODE: 82075090
COUNTRY OF ORIGIN: CN
5.00 JEITCL24 TURBO TOUGH, 24MM X 55MM TCT (8MM PILOT) 17.50 87.50
COMMODITY CODE: —_ 82075090
COUNTRY OF ORIGIN: CN
5.00 JEITCL26 TURBO TOUGH, 26MM X 55MM TCT (8MM PILOT) 21.67 108.35
COMMODITY CODE: 82075090
COUNTRY OF ORIGIN: CN
Deliver To : Total Net Amount £ 551.75
SHIPLEY GLOBAL EVENTS (PTY)
678 MIRROR CARD STREET
GARSFONTEIN
PRETORIA
SOUTH AFRICA
0042
Payment Terms : 30 Days
1 BOX 20KG 50X40X26CM 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: Rebecca Mahrous, Export Administrator 14/04/2026
Carriage Net
Total VAT Amount
Invoice Total 551.75
Page 1
=== PAGE BREAK ===
JEI DRILLING & CUTTING SOLUTIONS LTD INVOICE
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY
BURNLEY
LANCASHIRE L/, y
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 161611
T/A JE] SOUTH AFRICA .
47 STATION STREET Invoice Date 21/04/2026
OBERHOLZER
CARLETONVILLE, 2499 Sales Order No 156862
SOUTH AFRICA Customer Order No _| PO-20260416-003
VAT Reg No: 4450314382
Shipping Term: DAP - Delivered at Place [2020] Account Ref JEISAO00 J
Quantity Stock Code Description Unit Price Net Amt
8.00 JEITCS12 TURBO TOUGH, 12MM X 40MM TCT (6MM PILOT) 14.17 113.36
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
8.00 JEITCS14 TURBO TOUGH, 14MM X 40MM TCT (6MM PILOT) 14.17 113.36
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
6.00 JEITCS16 TURBO TOUGH, 16MM X 40MM TCT (6MM PILOT) 14.33 85.98
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
22.00 JEIPILOT1/TCS6MMPILOT PIN 40MM DEPTH, 6MM X 90MM 3.14 69.08
COMMODITY CODE: 82078090 COUNTRY OF ORIGIN:CN
3.00 JEITCS20 TURBO TOUGH, 20MM X 40MM TCT (8MM PILOT) 14.67 44.01
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
3.00 JEIPILOT1/8MM PILOT PIN 40MM DEPTH, 8MM x 90MM 4.08 12.24
COMMODITY CODE: 82078090 COUNTRY OF ORIGIN:CN
5.00 JEITCL28 TURBO TOUGH, 28MM X 55MM TCT (8MM PILOT) 21.67 108.35
COMMODITY CODE: 82075090 COUNTRY OF ORIGIN:CN
5.00 JEIPILOT2/8MM PILOT PIN 55MM DEPTH, 8MM X 102MM 5.10 25.50
COMMODITY CODE: 82078090 COUNTRY OF ORIGIN:CN
Customs Code: CU25426972
1 Box, 4.30kg, 36x26x16cm
Dated: 21.04.26
Deliver To : Total Net Amount |£ 571.88
GEORGE SHIPLEY
678 MIRROR CARP STREET
GARSFONTEIN
PRETORIA
Carriage Net
Total VAT Amount
GT 0042 \
SOUTH AFRICA pA Invoice Total 663.88
Page 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"
Place: Burnley Signed: Adina Pollard, General Manager
=== PAGE BREAK ===
JEI DRILLING & CUTTING SOLUTIONS LTD
UNIT 21 EMPIRE BUSINESS PARK
ENTERPRISE WAY
BURNLEY Viappyhhhs
LANCASHIRE =
peer Solutions
Tel : 01706 229490
Email : sales@jeisolutions.co.uk TIT TTITI Ti iirrriiiiiiiig
www.jeiuk.com .
VAT Reg No: 227257212 Built for Industry
EORI No: GB227257212000 INVOICE Page 1
K2023742851 SOUTH AFRICA (PTY) LTD Invoice No 161852
T/A JE] SOUTH AFRICA .
47 STATION STREET Invoice Date 29/04/2026
OBERHOLZER
CARLETONVILLE, 2499 Sales Order No 157430
SOUTH AFRICA Customer Order No PO-20260429-001
Account Ref JEISA000
. er Unit DiscAmt Net VAT
{quantity Stock Code Description Price % Amt 20% ]
30.00 JEICS18 TURBO STEEL, M2-AL CUTTER, 18MM X 1" 3.69 0.00 110.70 0.00
30.00 PILOT1 PILOT PIN 1" DEPTH 2.50 0.00 75.00 0.00
30.00 JEICL18 TURBO STEEL, M2-AL CUTTER, 18MM X 2" 5.79 0.00 173.70 0.00
30.00 PILOT2 PILOT PIN 2" 3.00 0.00 90.00 0.00
10.00 JM201.03.11 CARBON BRUSH EACH, MINIBEAST 5.42 0.00 54.20 0.00
Deliver To : Total Net Amount 503.60 |
GEORGE SHIPLEY
678 MIRROR CARP STREET Carriage Net 115.00
GARSFONTEIN
PRETORIA Total 20% VAT 0.00
GT 0042 .
SOUTH AFRICA Invoice Total 618.60
Payment Terms : 30 Days
Company Bank Details:
Bank name: Barclays Bank
Bank Address: 72-78 James Street, Burnley, Lancashire, BB11 1NH
Currency: Sterling
Sort Code: 20-15-70
Account: 63517993
BIC: BUKBGB22
IBAN: GB74BUKB2015706351 7993
Reference in a new issue View git blame Copy permalink