CK
COLOR KING IMS
🔒

Color King IMS Portal

Centralized Cloud Inventory & Real-time Branch Sync

⚠️ {{ authError }}

⚡ Sales Log Entry (Outflow)

Location: {{ user.assigned_location }}
ACTIVE SKU

{{ selectedSku.sku_code }}

{{ selectedSku.product_description || 'Central Master SKU' }}

Live Stock in {{ user.assigned_location }} {{ getStockForCurrentLocation(selectedSku) }} pcs
{{ item.sku }} {{ item.remarks }}
{{ item.desc || item.time }}
-{{ item.qty }} pcs
No sales in queue.
Add items on the left to review.
Total: {{ todaySubmittedList.length }} txns Qty: {{ todayTotalQuantity }} pcs
{{ item.sku }} {{ item.time }}
{{ item.desc || item.remarks || '-' }}
✓ {{ item.qty }} pcs
No submissions yet today.

📊 Daily Sales History

Query POS transactions from Google Sheet and export formal PDF reports.

Total Sales Quantity {{ reportTotalQty }} pcs
Total Transactions {{ reportTransactions.length }} lines
Active Branches {{ reportUniqueLocationsCount }}
Unique SKUs Sold {{ reportUniqueSkusCount }}
Showing {{ reportTransactions.length }} records
# 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.

Stock Take Preview: {{ stockTakeLocation }} ({{ stockTakeList.length }} SKUs) Total Book Units: {{ stockTakeTotalUnits }} pcs
# 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.

Filtered Records {{ ledgerList.length }} txns
Total Units Inflow (+) +{{ ledgerTotalInflow }} pcs
Total Units Outflow (-) -{{ ledgerTotalOutflow }} pcs
Net Stock Delta {{ ledgerNetDelta > 0 ? '+' : '' }}{{ ledgerNetDelta }} pcs
Audit Journal Entries Querying Central Sheet...
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.

Not Applicable (Catalog Only)
Selected: {{ selectedRestockSku.sku_code }} - {{ selectedRestockSku.product_description }}
Main ({{ restockForm.targetLocation }}): {{ selectedRestockSku[restockForm.targetLocation.toLowerCase()] || 0 }} pcs ➔ Grade B: {{ selectedRestockSku[(restockForm.targetLocation + '_b').toLowerCase()] || 0 }} pcs Current {{ restockForm.targetLocation }}: {{ selectedRestockSku[restockForm.targetLocation.toLowerCase()] || 0 }} pcs
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.

Source Warehouse Dispatch PIC: {{ targetRoutingContact.pic_name }} ({{ targetRoutingContact.location_name }}) 📱 {{ targetRoutingContact.whatsapp_number }}
Auto WhatsApp Ready
SELECTED SKU

{{ selectedTransferSku.sku_code }}

{{ selectedTransferSku.product_description }}

Source ({{ newTransfer.fromLocation }}) Stock {{ selectedTransferSku[newTransfer.fromLocation.toLowerCase()] || 0 }} pcs
Destination ({{ newTransfer.toLocation }}) Stock {{ selectedTransferSku[newTransfer.toLocation.toLowerCase()] || 0 }} pcs
# 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.
Total SKUs: {{ newTransfer.items.length }} | Total Qty: {{ totalStagedTransferQty }} pcs
{{ order.transfer_id }} ACTION REQUIRED: DISPATCH

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 }}
No pending incoming transfer requests for your location.
{{ order.transfer_id }} IN-TRANSIT

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 || '-' }}
No orders currently in-transit to your location.

Completed Transfer History

Showing recent verified delivery orders across branches.

{{ order.transfer_id }} {{ order.timestamp }} ✓ {{ order.status }}
{{ order.from_location }} ➔ {{ order.to_location }}
Requested: {{ order.operator_request }} | Dispatched: {{ order.operator_dispatch }} | Received: {{ order.operator_receive }}
{{ itm.sku_code }} ({{ getSkuDescription(itm.sku_code) }}) Received: {{ itm.received_qty }} pcs
No completed transfer records found.
Page {{ completedPage }} of {{ completedTotalPages }} (Total {{ filteredCompletedOrders.length }} orders)

📝 Live Stream & eCommerce Batch Entry

Key in individual order items sequentially. The system will automatically aggregate identical SKUs into a consolidated picking list.

ACTIVE SKU
{{ selectedEcomSku.sku_code }}
{{ selectedEcomSku.product_description || 'Central Master SKU' }}
Live Stock in {{ ecomForm.from_loc }} {{ selectedEcomSku[ecomForm.from_loc.toLowerCase()] || 0 }} pcs
Raw Entries Log ({{ ecomForm.items.length }} entries)
#{{ idx + 1 }} {{ item.sku }} {{ item.desc }}
{{ item.qty }} pcs
No entries added yet.
Aggregated Picking Preview ({{ stagedPickingSummary.length }} Unique SKUs) Total: {{ totalStagedEcomQty }} pcs
{{ sumItem.sku }} {{ getSkuDescription(sumItem.sku) }}
{{ sumItem.total_qty }} pcs
Aggregated picking list will appear here automatically.
{{ b.batch_id }} PICKING IN PROGRESS [{{ b.from_location }}] {{ b.batch_tag }}

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
No active batches picking right now.

Completed Fulfillment Batches

Batches packed, finalized, and deducted from warehouse stock.

{{ b.batch_id }} ✓ PACKED & DEDUCTED [{{ b.from_location }}] {{ b.batch_tag }}
Completed at: {{ b.completed_at }}
{{ itm.sku }} ({{ getSkuDescription(itm.sku) }}) {{ itm.total_qty }} pcs
No completed batches found.

🏢 Corporate & Partner Outflow Entry

Record B2B wholesale dispatches or partner gift redemptions. Stock will be directly deducted upon submission.

SELECTED SKU
{{ selectedCorpSku.sku_code }}
{{ selectedCorpSku.product_description || 'Central Master SKU' }}
Live Stock in {{ corpForm.from_loc }} {{ selectedCorpSku[corpForm.from_loc.toLowerCase()] || 0 }} pcs
# 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.
Total SKUs: {{ corpForm.items.length }} | Total Qty: {{ totalStagedCorpQty }} pcs

Corporate & Partner Outflow History

Showing historical B2B wholesale dispatches and partner gift redemptions.

{{ o.order_id }} {{ o.outflow_type === 'B2B' ? '🏢 B2B' : '🎁 REDEMPTION' }} [{{ o.from_location }}] ➔ {{ o.target_entity }} Ref: {{ o.ref_no }}
{{ o.timestamp }}
Operator: {{ o.operator_email }} Note: {{ o.remarks }}
{{ itm.sku }} ({{ getSkuDescription(itm.sku) }}) {{ itm.qty }} pcs
No matching corporate outflow records found.

Consigned Inventory: {{ selectedConsigneeId === 'ALL' ? 'Nationwide Summary' : getPartnerName(selectedConsigneeId) }}

Filter across chains (e.g. type 'AEON' or 'Parkson') to view aggregate brand holdings.

Total Units: {{ totalConsignedFilteredUnits }} pcs
# 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.

{{ selectedConsignSku.sku_code }} - {{ selectedConsignSku.product_description }}
{{ consignReqForm.from_loc }} Stock: {{ selectedConsignSku[consignReqForm.from_loc.toLowerCase()] || 0 }} pcs
# SKU CODE DESCRIPTION REQUEST QTY ACTION
{{ idx + 1 }} {{ item.sku }} {{ item.desc }} {{ item.qty }} pcs
No items staged for request. Search SKU above.
Total SKUs: {{ consignReqForm.items.length }} | Total Qty: {{ totalStagedConsignReqQty }} pcs
{{ order.request_id }} ACTION REQUIRED: DISPATCH

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
No pending consignment dispatch requests to review.

Dispatched Consignment Records

Historical delivery orders already approved and deducted from warehouse.

{{ order.request_id }} ✓ DISPATCHED {{ order.timestamp }}
{{ order.from_location }} ➔ {{ getPartnerName(order.partner_id) }}
Requested by: {{ order.requested_by }} | Approved by: {{ order.approved_by || 'N/A' }}
{{ itm.sku }} ({{ getSkuDescription(itm.sku) }}) Dispatched: {{ itm.dispatched_qty }} pcs
No dispatched records found.

💰 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.
Total SKUs: {{ consignSettleForm.items.length }} | Total Sold Qty: {{ totalStagedConsignSettleQty }} pcs

↩️ 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.
Total SKUs: {{ consignReturnForm.items.length }} | Total Return Qty: {{ totalStagedConsignReturnQty }} pcs
Restricted Admin Tool

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.

Selected Consignee {{ getPartnerName(selectedConsigneeId) || 'None' }}
ℹ️ All adjustments are logged into the central audit trail with your email and will automatically synchronize with the central CONSIGN inventory balance.
{{ selectedConsignAdjustSku.sku_code }} - {{ selectedConsignAdjustSku.product_description }}
Current Consigned Balance: {{ getPartnerCurrentSkuQty(selectedConsignAdjustSku.sku_code) }} pcs
# 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.
Staged SKUs: {{ consignAdjustForm.items.length }}

Stock Balance Matrix

Centralized warehouse inventory balance across all branches and virtual pools.

Found {{ filteredBalances.length }} items (filtered from {{ rawBalances.length }})
Per page:
# 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.
Page {{ currentPage }} of {{ totalPages }}
{{ currentPage }}

✨ Create Sample & PR Outflow Requisition

Request promotional samples, KOL review products, media gifts or internal test units.

{{ selectedSampleSku.sku_code }} - {{ selectedSampleSku.product_description }}
{{ sampleReqForm.from_loc }} Stock: {{ selectedSampleSku[sampleReqForm.from_loc.toLowerCase()] || 0 }} pcs
# SKU CODE DESCRIPTION REQUEST QTY ACTION
{{ idx + 1 }} {{ item.sku }} {{ item.desc }} {{ item.qty }} pcs
No items staged for sample request. Search SKU above.
Total SKUs: {{ sampleReqForm.items.length }} | Total Qty: {{ totalStagedSampleReqQty }} pcs
{{ order.request_id }} ACTION REQUIRED: APPROVE & ISSUE {{ order.sample_category }}

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
No pending sample requisitions to approve.
{{ order.request_id }} {{ order.status === 'PARTIAL_RETURN' ? '⚠️ PARTIAL RETURN' : '📌 ON LOAN' }} {{ order.sample_category }}

Issued From: {{ order.from_location }} | Recipient: {{ order.recipient_name }} | Due Date: {{ order.expected_return_date || 'No Date Set' }}

Note: {{ order.purpose_remarks }}

{{ itm.sku }} - {{ getSkuDescription(itm.sku) }}
Loaned: {{ itm.dispatched_qty }} Returned: {{ itm.returned_qty || 0 }} Outstanding: {{ Math.max(0, itm.dispatched_qty - (itm.returned_qty || 0)) }}
No active outstanding loans. All samples returned or gifted.

↩️ Verify & Receive Returned Sample

Order: {{ activeReturnOrder.request_id }} | Recipient: {{ activeReturnOrder.recipient_name }}

{{ itm.sku }}
Loaned: {{ itm.dispatched_qty }} | Prev Returned: {{ itm.prev_returned_qty }}
Receive: / {{ itm.remaining_qty }}

Dispatched Sample Records

Historical samples already approved, deducted from stock, and issued to recipients.

{{ order.request_id }} {{ order.status === 'DISPATCHED' ? '✓ DISPATCHED' : order.status }} {{ order.timestamp }}
{{ order.from_location }} ➔ {{ order.recipient_name }}
Category: {{ order.sample_category }} | Requested by: {{ order.requested_by }} | Approved by: {{ order.approved_by || 'N/A' }}
{{ itm.sku }} ({{ getSkuDescription(itm.sku) }}) Issued: {{ itm.dispatched_qty }} pcs
No dispatched sample records found.