Eng Seng
Eng Seng Industrial Resources Sdn Bhd
Powered by Supabase
ES
ENG SENG INDUSTRIAL RESOURCES SDN BHDENG SENG
OpsHub v5.3 ·
AI
API
Drive
💬
🔔
⚙️
Year:
Sales · YTD
RM *****
Tap to reveal
▾ details
Profit · YTD
RM *****
Tap to reveal
▾ details
Receivables
RM *****
Tap to reveal
▾ details
Quotations Delivered
RM *****
Tap to reveal
▾ details
Detail
0
Drive Total
0
0
0
Detail
📄
Inbox — Drop or tap to upload
PDF · Image · Excel · CSV — AI auto-classifies
+
📁 Drive: 0
⚡ Auto: 0
⏳ Processing: 0
Process all →
Review Queue
0
Loading...
📚 Documents
PDF reading room — view source documents with structured summaries (read-only)
📋 POs
📄 Quotations
🔍
Item Search
📋
Purchase Orders 0
📄 Quotations 0
📋 Client POs 0
🚚 Delivery Orders 0
📱 WhatsApp 0
🔗 Tracking 0
Quotations
Create and manage customer quotations
ENG SENG INDUSTRIAL RESOURCES SDN BHD
202401047327 (1593173-P) · No 4, Lorong 1, 42600 Jenjarom, Selangor
[email protected]
QUOTATION

Bill To
Attention
Valid Until
# Description Qty Unit Price Disc% Amount (RM)
Total Amount
RM 0.00
Prepared by:
Authorised Signature: ___________________
ENG SENG INDUSTRIAL RESOURCES SDN BHD
📤
Upload QT from SQL
📤
Drop QT PDF(s) here or click to browse
PDF or image · single or batch · AI extracts QT number, items, totals
⚠️
QT Review Queue 0
QT Unrecognized Queue 0
🔀
QT Duplicate Review 0
📂
Saved Quotations
No quotations yet.
QT No
Subtotal
RM 0.00
Discount
RM 0.00
Total
RM 0.00
📊 Data Box [F2]
📋
Upload Client PO
📋
Drop PO(s) here or click to browse
PDF or image · single or batch
⚠️
PO Review Queue 0
PO Unrecognized Queue 0
🔀
PO Duplicate Review 0
🔍
📋
Purchase Orders 0
No POs yet. Upload a PO above.
✍️
Upload Signed CDO — AI ticks the DO on the Invoice checklist + files the proof PDF
✍️
Drop signed CDO(s) here
PDF or image · matches by DO number against invoice checklists · auto-ticks & files proof
📌
Either path completes the same checklist: tick manually on the Invoice tab after a physical check, OR drop the signed PDF here and AI ticks it for you. Requires the matching Client Invoice to be uploaded first (so the DO number is recorded).
📋
Recently Filed CDOs 0 — ticked entries from invoice DO checklists, most recent first
🚚
Delivery Orders 0
No DOs yet.
🔗 Document Tracking
Track relationships between Quotations, Purchase Orders, and Invoices
📋 QT → PO 0
📦 PO → INV 0
⚠️ No Invoice 0
📱 WhatsApp 0
🔍 Item Lookup
🧾 Invoices 0
💵 Receipts 0
📝 CN / DN 0
💡
Upload Invoice PDF from SQL → AI reads → Tick DOs → AR Tracking. For each DO, either tick after a physical check, or upload the signed CDO PDF in the DO tab to file the proof.
🧾
Upload Invoice PDF from SQL
🧾
Drop Invoice PDF(s) from SQL
Single or batch · AI reads invoice number, date, client, total, and DO numbers
⚠️
INV Review Queue 0
INV Unrecognized Queue 0
🧾
0
Total Invoices
RM 0.00
0
Pending Verify
DOs not fully ticked
🔴
0
Overdue
Past due date
0
Paid
RM 0.00
📋
Invoice List 0
No invoices yet. Upload an invoice PDF above to get started.
Receipts (Customer Payments)
Receipt Vouchers — money received from customers
💵
Receipt List 0
No receipts yet. Use the Receive button on an invoice to record payment.
Customer Credit / Debit Notes
Adjustments to customer invoices — CN reduces, DN increases what they owe
📝
Customer CN/DN List 0
No customer credit/debit notes yet.
📊 Reports
📤 SQL Export
💳 GL & Accounts
📓 Journal Vouchers 0
📊 Reports & Cross-Check
All reports pull from live data — no setup needed
All Reports
📄 Sales
🏢 Procurement
💰 Finance
📤
SQL Export — Separate CSV Files
Loading…
GL accounts 440-001 to 440-006 created. 310-001 deleted. All director loan accounts active.
💳 Payment Accounts
📊 GL Purchase Mapping
💳
Payment Accounts
Account NameCodeTypeClosingStatus
PBB BANK 6821
Company Operating
310-000Company31st✓ Active
DIR. LOAN - RHB CC 5268440-001Dir Loan✓ Active
DIR. LOAN - RHB CC 2463440-002Dir Loan✓ Active
DIR. LOAN - RHB CC 6937440-003Dir Loan✓ Active
DIR. LOAN - CIMB CC 2953440-004Dir Loan19th✓ Active
DIR. LOAN - PBB 9313440-005Dir Loan17th✓ Active
CASH (Physical)440-006CashAdd in SQL
📊
GL Purchase Mapping
What You BuyGL AccountCode
Stock to resellPURCHASE610-000
Taobao / Shopee (resale)PURCHASE610-000
Taobao / Shopee (own use)CONSUMABLE903-000
Office suppliesCONSUMABLE903-000
Petrol / dieselPETROL905-000
Toll / parkingTOLL & PARKING916-000
Food / refreshmentsREFRESHMENT922-000

📓 Journal Vouchers

ℹ️
Journal Vouchers record double-entry adjustments: depreciation, payroll posting, opening balances, reclassifications. Every JV must balance — total debits = total credits.
🔍
Filter
🧾 Supplier Invoices 0
📦 Supplier DOs 0
💰 Payments 0
📝 CN / DN 0
📋 Stmt Recon 0
🧾
Upload Supplier Invoice
📄
Drop invoices here or click to browse
Single or batch · PDF or image · AI extracts data automatically
📑
Multi-Doc Review 0
⚠️
Review Queue 0
Unrecognized Queue 0
🧾
Saved Invoices 0
From To Sort
⚠️
SDO Review Queue 0
SDO Unrecognized Queue 0
📦
Supplier Delivery Orders (Term Suppliers) 0
📦
Drop supplier DO(s) here
PDF or image · single or batch · Term suppliers only
📁
Drive Folder Guide
EngSeng/05_SUPPLIER_INVOICES/
  ├── INBOX/   ← you upload here
  ├── PROCESSED/ ← renamed + SQL done
  └── ERROR/   ← unreadable / new supplier

EngSeng/09_SQL_IMPORT/
  ├── PENDING/  ← waiting to import into SQL
  └── DONE/    ← imported OK
💰
Upload Payment Receipt
💰
Drop payment receipt(s) or click to upload
Single or batch · Bank slips, payment vouchers, cheque images, CC receipts
📋
Payment Vouchers 0
Supplier Credit / Debit Notes
Adjustments to supplier invoices — CN reduces, DN increases what we owe
📝
Supplier CN/DN List 0
No supplier credit/debit notes yet.
Supplier Reconciliation
Daily AP review per supplier · ledger view always available · upload supplier statement to verify
🔍
Filter
📒
Our Records (AP Ledger)
📄
Supplier Statements 0
📋
Upload Supplier Statement
📋
Drop supplier statement here or click to browse
PDF or image · AI reads every line and matches against your SI records
📦 Inventory 0
⚙️ Machines 0
📋 Stock Master 0
📦
Items Master
All items collected from saved quotations and supplier invoices. Grouped by similarity. Each item gets a unique code.
0 items
No items yet. Save a quotation or process an invoice to start building the list.
⚙️
Machine List
💡
Upload your Excel machine list (.xlsx/.xls). Columns: Production Line (merged), Section (4W/2W), M/c No, M/c Name. Merged cells are forward-filled automatically.
⚙️
Drop Excel machine list or click to upload
.xlsx / .xls / .csv — columns: Production Line, Section, M/c No, M/c Name
0 machines
No machines loaded yet. Upload your list above.
📋
Stock Master
⚠️
Pending Matches 0
🏢
Supplier Master
57 suppliers
NameSQL CodeShortCategoryGL AccountBRNTINActions
👥
Client Master
0 clients
No clients yet. Clients are auto-learned from quotations, POs, and invoices, or you can add them manually.
🏦
Bank Statement Reconciliation
🏦
Drop bank statement here or click to browse
Excel / CSV (CIMB, Public Bank, RHB) or PDF
📋
Saved Reconciliations
No saved reconciliations yet.
⚠️
Unpaid Supplier Invoices — Cross-Check 0
🛒 Platform 0
🇨🇳 Taobao 0
✏️ New Entry
🛒 Platform Invoices
Shopee, Lazada, TikTok and Taobao invoices are uploaded via the Supplier Invoice tab. The system auto-detects the platform (from keywords on the invoice) and saves with SI_YYMMDD_Platform_OrderNo_Total naming. Taobao item entry is done in the Taobao tab.
No platform invoices yet.
🇨🇳
Taobao Invoices
Upload Taobao official invoices via the Supplier Invoice tab — they are auto-detected and saved with the platform exchange rate calculated immediately. Use this tab to enter line items in RMB (auto-converted to RM) or to skip item entry.
Period:
No Taobao invoices for this period.
🛒
Platform & Payment
📦
Entry Mode
#DescriptionQtyUnit PriceAmount
Total
RM 0.00

🧾 Expenses Operating spend (petrol, telco, parking, utilities, subscriptions)

🧾
Upload Receipt
🧾
Drop receipts here or click to browse
Single or batch · PDF or image · AI detects vendor + amount + GL category
📋
Saved Expenses
From To
Manual Entry For receipts you've already filed elsewhere, or to override an AI scan
✈️
Trips Group foreign-currency expenses (China sourcing trips, etc.)
⚙️ General
💰 Finance
🤖 AI
🔗 Integrations
🖥️ System
🧹 Scrub
🏢
Company Name
🎨
Theme
Select a colour scheme. Changes apply instantly to the entire system.
🏆
High-End Gold
DEFAULT
🌹
Dark Rose
#F58F7C · #F2C4CE
💜
Pollux
#844FC1 · LIGHT
💙
Skydash
#4B49AC · LIGHT
💳
Payment Accounts
NameCodeTypeClosing DayActions
📊
GL Categories
Hint (Keyword)CodeLabelActions
👥
Client Payment Terms
No clients yet.
🏭
KYB-UMW Discount Rule
🔒
Period Lock

Lock accounting periods after bank reconciliation. Prevents accidental backdating.

Nothing before this date can be saved. Set after FY tax return filed.
Closed Months
No months closed yet.
💱
FX Rates (Monthly)

Monthly currency-to-MYR rates. Used to snapshot amountMYR on foreign-currency SIs at save time. Taobao records carry their own per-doc rate and don't need entries here.

🔑
API Key
Get your key from console.anthropic.com → API Keys → Create Key. Stored in your browser only.
🤖
AI Configuration
📄 Document scanning
Document OCR Extract Est.
Gemini — RM 0.02 Sonnet — RM 0.10 Haiku — RM 0.01
🔄 Gap-fill (rescan)
💬 AI chat
📡
Make.com Webhook

Paste your Make.com webhook URL. The 📡 Sync button in the header triggers Drive processing on demand.

📂
Google Drive Integration

Connect Google Drive to auto-upload processed files with AI-generated filenames into your EngSeng folder structure.

Not connected
Folder mapping:
Supplier Invoices → EngSeng/05_SUPPLIER_INVOICES/PROCESSED/
POs Received → EngSeng/03_PO_RECEIVED/
Quotations → EngSeng/01_QUOTATIONS/
Supplier DOs → EngSeng/04_SUPPLIER_DOS/
Bank Statements → EngSeng/07_BANK_STATEMENTS/
Receipts/PVs → EngSeng/06_RECEIPTS_PAYMENTS/
🩺
Diagnostics & Recovery

System health checks and recovery tools. Use the QT recovery tools when POs are flagged with the "items have no QT ref" warning.

📁 Drive Health Check

Compare Google Drive folders vs local records. Finds orphan files, dead links, and duplicates.

🧹 Expense file normalization (Phase E4)

After running Casual Scrub or pre-E4 cross-store moves, Drive files may be in the wrong folder or use the legacy filename pattern. Run these to bring them in line with §5.15.

🏷️ QT Grouping Recovery

Fix POs flagged with the "items have no QT ref" warning. Try the quick fix first — it's free and instant. Use the full rescan only when the quick fix can't resolve everything.

Quick fix (free, instant)

Auto-fills missing per-item QT refs from each PO's existing extraction data (machine_numbers ranges + single-QT inheritance). Won't fix POs with multiple QTs and no section structure.

Full rescan (uses Gemini API, ~30s per PO)

Re-OCRs each flagged PDF and re-extracts everything using the current prompt. Most thorough — fixes nearly all flagged POs. Manual edits to header/items will be overwritten; delivery and invoice state is preserved.

📦
Batch Control

Control how many files are processed per batch and cooldown between batches. Prevents API rate limits during large uploads. Applies to all uploaders — QT, PO, Invoice, Supplier DO, PV/Receipt, Universal Uploader, and Drive Inbox.

Example: 10 files/batch + 5 min cooldown = drop 60 files → 6 batches, ~35 min total. Drive token refreshes automatically between batches.
🔔
Push Notifications

Get browser notifications for new invoices, overdue items, and flags — even when OpsHub is in the background.

Checking...
💾
Data Backup

Download a full backup of all OpsHub data as a JSON file. Also uploads to Google Drive archive if connected.

💬
AI Assistant
Use the 💬 button in the header to open the AI chat panel.
On mobile, use Google Chat (coming Phase 4).
✏️
Add Entry
📒
Log Entries
No entries yet.
Connect Google Drive to view folder counts.

⚠️ Mismatch Review (0)

Documents whose AI classification disagrees with the upload tab in a way that flips Eng Seng's role (buyer ↔ seller). Within-side reclassifications (e.g. supplier_invoice ↔ payment_receipt) auto-save and don't appear here. Review and Confirm or Reject each one below.

FileUploadedTabAI SaysPreviewAction

👥 HR & Payroll

🔔 Notifications

×
No new notifications.
💬 AI Assistant
📚 Librarian
×
📚
Librarian Mode
Can see everything, touch nothing.
Ask about invoices, quotations, suppliers, reports — or drop files to process.