Data Upload Module

Upload CSV or Excel files with 17 columns. All records are inserted with duplicate detection.

📊 CSV/Excel Support 🔍 Duplicate Detection 📌 Append Mode 🔄 Bulk Upload (500/batch)

📤 Upload Data

Supported formats: .csv, .xlsx, .xls

📌

Append Mode Records will be appended after existing data. Starting from ID: 97,224

📊 Existing: 97,223 🆔 Last ID: 97,223 ➡️ Next ID: 97,224

📋 Expected Headers

pcs_tran_no ord_no * tran_date fbs_date rv_no ord_qty qty_received amt_payable payee ref form_code form_description rct_create_date depot_code item_description total_amount_due supplier_name

* Required field: ord_no

📄 Select File

📂

Drag & drop your file here

or click to browse Max 50MB • .csv, .xlsx, .xls

📅 Upload Month Select the month this data belongs to

📋 Upload Policy

ALL records are inserted - nothing is skipped
📌 Append Mode: Records are appended after existing data
🔴 DUPLICATES → Flagged but inserted
✅ CLEAN RECORD → is_duplicate=0
Order Number Format: 7 digits starting with 12-20
pcs_tran_no Format: Starts with "24"