⚙️
OpsHub
Eng Seng Engineering
Powered by Supabase
ES
Operations Hub
ENG SENG INDUSTRIAL RESOURCES · V4.1
● Offline 57 Suppliers
🔔
Year Filter:
📄
0
Quotations
0 open
🚚
0
Delivery Orders
0 pending invoice
🛒
0
Purchases
RM 0.00 total
⚠️
0
Flags
need attention
📄
Quotations Pending PO
No pending quotations.
💳
Statement Closing This Month
⚠️
Flags & Alerts
No flags.
📊
Monthly Summary
📋
Summary of the Day
Quotations
Create and manage customer quotations
ENG SENG INDUSTRIAL RESOURCES SDN BHD
202401047327 (1593173-P) · No 4, Lorong 1, 42600 Jenjarom, Selangor
engseng.industrial@gmail.com
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 PDF quotation from SQL Accounting
Drop PDF or click
📂
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 here or click to browse
PDF or image of client Purchase Order
🔍
📋
Purchase Orders 0
No POs yet. Upload a PO above.
🚚
Delivery Orders 0
No DOs yet.
💡
Upload Invoice PDF from SQL → AI reads → Tick DOs → AR Tracking. No file uploads for DOs — tick the checklist after physically checking the signed paper.
🧾
Upload Invoice PDF from SQL
🧾
Drop Invoice PDF from SQL
AI reads invoice number, date, client, total, and DO numbers
🧾
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.
📊 Reports & Cross-Check
All reports pull from live data — no setup needed
🛒
Platform & Payment
📦
Entry Mode
#DescriptionQtyUnit PriceAmount
Total
RM 0.00
🤖
AI Invoice Scanner
Upload any supplier invoice — Claude extracts data, renames file to SI_YYMMDD_Supplier_InvNo, classifies GL, generates SQL .txt
📄
Drop invoices here or click to browse
Single or batch — Taobao · Shopee · Any supplier · PDF or image
⚠️
Review Queue 0
Low confidence scans — review and approve or delete.
Unrecognized Queue 0
Files Claude could not parse — no usable data extracted.
🧾
Saved Invoices 0
All invoices saved to the SQL Export store. Edit or delete individual records here.
📦
Supplier Delivery Orders (Term Suppliers) 0
📦
Drop supplier DO here
PDF or image · 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
⚙️
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.
📦
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.
🏢
Supplier Master
57 suppliers
NameSQL CodeShortCategoryBRNTINActions
👥
Clients & Payment Terms
No clients yet.
GL accounts 440-001 to 440-006 created. 310-001 deleted. All director loan accounts active.
💳
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
📤
SQL Export — Separate CSV Files
Loading…
🏦
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
📥 Import Platform Order
📂
Drop Excel / CSV / PDF / Image here or click to browse
Supported: .xlsx .xls .csv .pdf .jpg .jpeg .png .webp
📋 Saved Platform Orders
No saved platform orders yet.
💳
Payment Accounts
NameCodeTypeClosing DayActions
📊
GL Categories
Hint (Keyword)CodeLabelActions
👥
Client Payment Terms
No clients yet.
🏭
KYB-UMW Discount Rule
🔑
API Key
Get your key from console.anthropic.com → API Keys → Create Key. Stored in your browser only.
🤖
AI Model Selector
Affects all invoice, PO, and batch scanning. AI Chat (Task 12) always uses 🧠 Deep.
📡
Make.com Webhook

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

💬
AI Chat — Ask about your data
~RM 0.03
✏️
Add Entry
📒
Log Entries
No entries yet.

🔔 Notifications

×
No new notifications.