Color King IMS Portal
Centralized Cloud Inventory & Real-time Branch Sync
⚡ Sales Log Entry (Outflow)
Location: {{ user.assigned_location }}{{ selectedSku.sku_code }}
{{ selectedSku.product_description || 'Central Master SKU' }}
Add items on the left to review.
📊 Daily Sales History
Query POS transactions from Google Sheet and export formal PDF reports.
| # | DATE / TIME | LOCATION | SKU CODE | DESCRIPTION | QTY SOLD | OPERATOR | REMARKS |
|---|---|---|---|---|---|---|---|
| {{ idx + 1 }} | {{ txn.timestamp }} | {{ txn.location }} | {{ txn.sku_code }} | {{ getSkuDescription(txn.sku_code) }} | -{{ txn.quantity }} | {{ txn.operator }} | {{ txn.remarks || '-' }} |
| No transactions found. | |||||||
📋 Warehouse Stock Take Sheet Generator
Generate printable physical inventory count sheets or export XLS/CSV for store and warehouse audits.
| # | SKU CODE | PRODUCT DESCRIPTION | SYSTEM BOOK QTY | PHYSICAL COUNT | VARIANCE |
|---|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku_code }} | {{ item.product_description }} | {{ item.system_qty }} pcs | __________ | __________ |
| No SKUs match the current criteria. | |||||
💼 Accountant Stock Card & Audit Ledger
Track all movements (Sales, Transfers, Consignments, Returns, Adjustments) for reconciliation with SQL Accounting.
| DATE / TIME | TRANSACTION ID | TYPE | ROUTE (FROM ➔ TO) | SKU CODE | DESCRIPTION | QTY | OPERATOR | AUDIT REMARKS |
|---|---|---|---|---|---|---|---|---|
| {{ row.timestamp }} | {{ row.trans_id }} | {{ row.type }} | {{ row.from_location }} ➔ {{ row.to_location }} | {{ row.sku_code }} | {{ getSkuDescription(row.sku_code) }} | {{ getMovementSign(row) }}{{ row.quantity }} | {{ row.operator }} | {{ row.remarks || '-' }} |
| No ledger movements found for the selected query. | ||||||||
📥 Factory Restock, Stock Adjustment & SKU Registration
Manage incoming goods, adjust stock discrepancies, or pre-register new products prior to arrival.
| SKU CODE | DESCRIPTION | QUANTITY DELTA | ACTION |
|---|---|---|---|
| {{ item.sku }} | {{ item.desc }} | {{ item.qty > 0 ? '+' : '' }}{{ item.qty }} pcs | |
| No items added to the list yet. | |||
| NEW SKU CODE | PRODUCT DESCRIPTION | INITIAL STATUS | ACTION |
|---|---|---|---|
| {{ item.sku }} | {{ item.desc }} | All Warehouses = 0 | |
| No new SKUs added for registration yet. | |||
✨ Create Internal Stock Transfer Request
Initiate an official inventory transfer order. Source warehouse will review and dispatch.
{{ selectedTransferSku.sku_code }}
{{ selectedTransferSku.product_description }}
| # | SKU CODE | DESCRIPTION | SOURCE ({{ newTransfer.fromLocation }}) | REQUEST QTY | ACTION |
|---|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku }} | {{ item.desc }} | {{ item.sourceStock }} pcs | {{ item.qty }} pcs | |
| No items added to this transfer request yet. | |||||
Requested by {{ order.operator_request }} on {{ order.timestamp }} | Route: {{ order.from_location }} ➔ {{ order.to_location }}
Note: {{ order.general_remarks }}
| SKU CODE | DESCRIPTION | REQUESTED | DISPATCH QTY | MODIFICATION REMARKS (IF CHANGED) |
|---|---|---|---|---|
| {{ itm.sku_code }} | {{ getSkuDescription(itm.sku_code) }} | {{ itm.requested_qty }} |
Dispatched by {{ order.operator_dispatch }} | Route: {{ order.from_location }} ➔ {{ order.to_location }}
Note: {{ order.general_remarks }}
| SKU CODE | DESCRIPTION | DISPATCHED QTY | DISPATCH NOTE | CONFIRMED RECEIVED |
|---|---|---|---|---|
| {{ itm.sku_code }} | {{ getSkuDescription(itm.sku_code) }} | {{ itm.dispatched_qty }} pcs | {{ itm.dispatch_remarks || '-' }} |
Completed Transfer History
Showing recent verified delivery orders across branches.
📝 Live Stream & eCommerce Batch Entry
Key in individual order items sequentially. The system will automatically aggregate identical SKUs into a consolidated picking list.
Created by {{ b.operator_email }} on {{ b.timestamp }} | Unique SKUs: {{ b.picking_list.length }}
| CHECK | SKU CODE | PRODUCT DESCRIPTION | AGGREGATED QTY |
|---|---|---|---|
| {{ item.sku }} | {{ getSkuDescription(item.sku) }} | {{ item.total_qty }} pcs |
Completed Fulfillment Batches
Batches packed, finalized, and deducted from warehouse stock.
🏢 Corporate & Partner Outflow Entry
Record B2B wholesale dispatches or partner gift redemptions. Stock will be directly deducted upon submission.
| # | SKU CODE | DESCRIPTION | QTY TO DEDUCT | ACTION |
|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku }} | {{ item.desc }} | {{ item.qty }} pcs | |
| No items staged for outflow. Search and add SKU above. | ||||
Corporate & Partner Outflow History
Showing historical B2B wholesale dispatches and partner gift redemptions.
Consigned Inventory: {{ selectedConsigneeId === 'ALL' ? 'Nationwide Summary' : getPartnerName(selectedConsigneeId) }}
Filter across chains (e.g. type 'AEON' or 'Parkson') to view aggregate brand holdings.
| # | SKU CODE | PRODUCT DESCRIPTION | OUTLET BREAKDOWN | CONSIGNED BALANCE |
|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku }} | {{ getSkuDescription(item.sku) }} | {{ getPartnerName(pid) }}: {{ qty }} | {{ item.display_qty }} pcs |
| No matching consignment inventory found. | ||||
| Loading consignment inventory from cloud... |
Consignment Stock Movement Audit Log
Real-time audit log of all dispatches, sale settlements, returns, and inventory adjustments.
| DATE / TIME | PARTNER / OUTLET | SKU CODE | ACTION TYPE | QTY | REF NO. | OPERATOR | REMARKS |
|---|---|---|---|---|---|---|---|
| {{ m.timestamp }} | {{ getPartnerName(m.partner_id) }} | {{ m.sku }} | {{ m.action_type }} | {{ ['DISPATCH', 'ADJUSTMENT'].includes(m.action_type) && m.qty > 0 ? '+' : '' }}{{ m.qty }} | {{ m.ref_no || '-' }} | {{ m.operator }} | {{ m.remarks || '-' }} |
| No consignment movement records found. | |||||||
✨ Create Consignment Requisition
Initiate a consignment delivery order. System will generate a continuous CREQ number and notify warehouse PIC.
| # | SKU CODE | DESCRIPTION | REQUEST QTY | ACTION |
|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku }} | {{ item.desc }} | {{ item.qty }} pcs | |
| No items staged for request. Search SKU above. | ||||
Requested by {{ order.requested_by }} on {{ order.timestamp }} | Route: {{ order.from_location }} ➔ {{ getPartnerName(order.partner_id) }}
Note: {{ order.remarks }}
| SKU CODE | DESCRIPTION | REQUESTED | ACTUAL DISPATCH | REASON / DISPATCH NOTE (IF MODIFIED) |
|---|---|---|---|---|
| {{ itm.sku }} | {{ getSkuDescription(itm.sku) }} | {{ itm.requested_qty }} pcs |
Dispatched Consignment Records
Historical delivery orders already approved and deducted from warehouse.
💰 Sales Settlement / Claim (Report Sold)
Record items reported sold by partner. Deducts CONSIGN inventory and logs directly into Sales Log.
| # | SKU CODE | DESCRIPTION | SOLD QTY | ACTION |
|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku }} | {{ getSkuDescription(item.sku) }} | {{ item.qty }} pcs | |
| No sold items added for settlement. | ||||
↩️ Consignment Return to Local Warehouse
Return unsold or damaged goods from partner custody back into company warehouse stock.
| # | SKU CODE | DESCRIPTION | RETURN QTY | ACTION |
|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku }} | {{ getSkuDescription(item.sku) }} | {{ item.qty }} pcs | |
| No items staged for return. | ||||
Consignment Opening Balance & Stock Adjustment
Initialize physical stock already stationed at departmental stores, or reconcile stock discrepancies. Positive values increase stock; negative values decrease stock.
| # | SKU CODE | DESCRIPTION | ADJUSTMENT DELTA | ACTION |
|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku }} | {{ item.desc }} | {{ item.qty > 0 ? '+' : '' }}{{ item.qty }} pcs | |
| No adjustments staged. Search SKU and enter initial opening quantity above. | ||||
Stock Balance Matrix
Centralized warehouse inventory balance across all branches and virtual pools.
| # | SKU CODE | PRODUCT DESCRIPTION | PERMAS | MOLEK | SS2 | SA | B2C | B2B | CONSIGN | PERMAS (B) | SA (B) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {{ (currentPage - 1) * pageSize + idx + 1 }} | {{ row.sku_code }} INACTIVE | {{ row.product_description || '-' }} | {{ row.permas || 0 }} | {{ row.molek || 0 }} | {{ row.ss2 || 0 }} | {{ row.sa || 0 }} | {{ row.b2c || 0 }} | {{ row.b2b || 0 }} | {{ row.consign || 0 }} | {{ row.permas_b || 0 }} | {{ row.sa_b || 0 }} |
| No matching SKU found. | |||||||||||
✨ Create Sample & PR Outflow Requisition
Request promotional samples, KOL review products, media gifts or internal test units.
| # | SKU CODE | DESCRIPTION | REQUEST QTY | ACTION |
|---|---|---|---|---|
| {{ idx + 1 }} | {{ item.sku }} | {{ item.desc }} | {{ item.qty }} pcs | |
| No items staged for sample request. Search SKU above. | ||||
Requested by {{ order.requested_by }} on {{ order.timestamp }} | Recipient: {{ order.recipient_name }} (From: {{ order.from_location }})
Note: {{ order.purpose_remarks }}
| SKU CODE | DESCRIPTION | REQUESTED | ACTUAL ISSUED | MODIFICATION NOTE (IF CHANGED) |
|---|---|---|---|---|
| {{ itm.sku }} | {{ getSkuDescription(itm.sku) }} | {{ itm.requested_qty }} pcs |
Issued From: {{ order.from_location }} | Recipient: {{ order.recipient_name }} | Due Date: {{ order.expected_return_date || 'No Date Set' }}
Note: {{ order.purpose_remarks }}
↩️ Verify & Receive Returned Sample
Order: {{ activeReturnOrder.request_id }} | Recipient: {{ activeReturnOrder.recipient_name }}
Dispatched Sample Records
Historical samples already approved, deducted from stock, and issued to recipients.