AICE Operations System V3.7

工作台

Quick Actions

Fixed by workspace

Workspace Activity

Time	Action	Target	Remark

Pending Factory Approval

0

Current Stock (Boxes)

0

Pending Shipment

0

Unverified Payments

0

Confirmed Workflow

Items Requiring Attention

Recent Business Activity

Time	Module	Action	Target	User	Workspace	Remark

All figures are automatically calculated from confirmed receipts, approved shipments, stores and freezers.

Market Details

Item	Value	Source Logic

Inventory base unit is pcs. Sales orders are entered by box; all price master data is entered per piece.

Add Product

Product Code

Product Name

Product List

Code	Name	Category	Units/Box	Purchase / pcs	Default Outbound / pcs	Standard Retail / pcs	Active

Add Outbound Price System

There is exactly one default outbound price. Additional price systems are optional and are selected only when needed.

System Code

System Name

Remark

Price Systems

Code	Name	Type	Bound Stores	Status

Price changes are still submitted through the management price-change workflow and approved by Owner before becoming effective.

Factory is only a source label: Medan, Jakarta or Surabaya. No factory master data is maintained.

New Factory Order

Source Factory

Order Date

Created By

Remark

Search Product

Search by product name or code; Everything-style matching is supported.

Order Quantity (boxes)

Product Code	Product	Purchase / pcs	Boxes	Estimated Amount

Estimated Total: Rp 0

Factory Orders

Order No.	Factory	Date	Items	Estimated Total	Received	Status	Payment	Action

Enter actual quantities and confirm in one action. Confirmed quantities immediately increase stock. One order may be received many times.

Confirm Goods Receipt

Factory Order

Receipt Date

Truck / Delivery

Receiver

Remark

Receipt History

Receipt No.	Order No.	Date	Truck	Actual Received	Receiver

Cold Storage Capacity

10,000

boxes

Current Stock

0

equivalent boxes

Utilization

0%

Current Inventory

Code	Product	Stock pcs	Box Display	Status

Inventory Transactions

Time	Product	Change pcs	Balance pcs	Type	Reference	Remark

Inventory Adjustment

Product

Change pcs (+/-)

Reason

Return to Factory

Factory

Product

Quantity pcs

Reason

Each store can be bound to one default price system. The binding may be changed later and only affects future orders.

Add Store

Store Name

Owner

Store Type

Area

Phone

Address

Salesperson

Default Price System

Bind / Change Store Price System

Store

Price System

Remark

Store List

Name	Owner	Store Type	Area	Address	Phone	Salesperson	Price System	Freezers

Create reusable price systems, set an approved per-box price for each product, bind a default system to stores, and select the applicable system on every sales order.

Price Systems

Code	Name	Remark	Status	Bound Stores

New Price Change Request

Price System

Category Filter

Requested By

Remark

Price Requests

Request No.	Price System	Products	Status	Action

Search by freezer code or store name. Results update immediately using Everything-style matching.

New Inspection

Space = AND · | = OR · ! = exclude · quotes = exact phrase

Inspection Result

Salesperson

Cleaned?

Create Order?

Problem Follow-up?

Remark

搜索冰柜编码或商店名称，系统自动带出商店、默认价格体系和当天日期。

库存预占规则订单正式提交后立即预占仓库库存；业务员撤回或仓库驳回时释放，仓库确认销售出库时转为实际扣减。当前本地试用版可模拟同一浏览器多标签页同步；正式多人实时锁定需要云端服务器事务。

New Sales Order

Space = AND · | = OR · ! = exclude · quotes = exact phrase

Order Date

Salesperson

Price System

The store binding is selected automatically. Changing it here applies only to this order.

选择产品

支持 Everything 搜索逻辑：空格=同时包含 · | =任一匹配 · ! / - =排除 · 引号=精确短语

Boxes

Remark

Product	Boxes	Outbound / pcs	Subtotal

Salesperson submits a new store request. Area is not entered here. Asset management reviews and creates the official store record.

Add Store

Store Name

Owner

Phone

Backup Contact (Optional)

Address

Salesperson

Default Price System

Remark

Select a store, edit its basic information and submit an approval request. The official store record changes only after asset management approval.

Store Information Change

Space = AND · | = OR · ! = exclude · quotes = exact phrase

Store Name

Owner

Phone

Backup Contact

Address

Salesperson

Default Price System

Change Reason / Remark

Store List

Space = AND · | = OR · ! = exclude · quotes = exact phrase

Name	Owner	Address	Phone	Backup Contact	Freezer	Price System	Action

Pending orders may be edited or withdrawn by their creator before warehouse approval. Confirmed outbound records cannot be overwritten.

Order Records

Space = AND · | = OR · ! = exclude · quotes = exact phrase

Order No.	Customer	Date	Items	Total IDR	Status	Action

All drivers may view all tasks. One order can be claimed by only one driver. Management may reassign it.

Delivery Tasks

Task No.	Order No.	Customer	Amount	Driver	Status	Action

Complete Delivery & Record Collection

Task

Delivered

Displayed

Collected?

Actual Amount

Method

Collection Time

Paper Invoice No.

Remark

Finance verifies every order against the paper invoice. Uncollected deliveries may be submitted and followed up later.

Payment Verification

Order No.	Customer	Order Amount	Collection	Actual Amount	Method	Invoice	Status	Action

Add Freezer Model

Brand

Model

Capacity / Specification

Remark

Freezer Models

Brand	Model	Capacity	Remark

冰柜信息总表

序号	资产编码	品牌	规格型号	冰柜类别	门店类型	门店名称	投放人	店主名称	联系电话	投放地址	区域	首次投放日期	上次移动时间	投放备注	上次巡检时间	本月内巡检次数	本月巡检状态	业务员	上次维修日期	冰柜状态	位置状态	质量状态	新旧状态	提醒

冰柜总览：这里只做资产概览、异常提醒、巡检提醒和操作动态；市场/在库明细分别进入对应浏览页面，避免重复。

冰柜总资产

0

市场冰柜

0

在库冰柜

0

好冰柜

0

坏冰柜

0

待检修

0

待报废

0

待老板审批

0

本月投放

0

本月拉回

0

本月转投

0

本月替换

0

异常冰柜

资产编码	位置	质量	门店

长期未巡检 / 本月未巡检

资产编码	门店	上次巡检时间	本月巡检状态

购买 / 报废审批

编号	日期	类型	明细	申请人	状态	操作

市场冰柜浏览：日常页面只显示资产编码、门店名称、上次移动时间、上次巡检时间。默认最多预览 10 台，点击“查看更多”后每页显示 20 台。

市场冰柜浏览

空格 = AND · | = OR · ! = 排除 · 引号 = 精确短语

资产编码	门店名称	上次移动时间	上次巡检时间

拉回冰柜：从市场商店拉回仓库。选择店铺或冰柜编码，并填写拉回后的质量状态。

拉回冰柜

日期

拉回店铺名称

冰柜编码（可搜索）

冰柜型号

冰柜属性

新旧状态

拉回后质量状态

经手人

原因 / 备注

拉回冰柜记录

日期	商店	冰柜编码	型号	属性	质量	新旧	经手人	备注	状态	操作

投放冰柜：从在库好冰柜投放到商店，并绑定商店信息。不存在的商店可随本次投放建立。

投放冰柜

日期

业务员 / 投放人

商店名称

店主名称

区域

商店地址

联系方式

冰柜编码（在库好冰柜）

冰柜型号

冰柜属性

新旧状态

备注

投放冰柜记录

日期	商店	冰柜编码	型号	区域	投放人	备注	状态	操作

冰柜转投：冰柜从一个商店直接转到另一个商店，不经过仓库。同区域转投可直接执行；跨区域转投提交执行经理审批。

转投冰柜

转投日期

原商店

新商店（可新建）

业务员 / 经手人

冰柜编码

目标区域

原因 / 备注

冰柜转投记录

日期	原商店	新商店	冰柜编码	区域	经手人	备注	状态	操作

冰柜替换：坏冰柜回仓库，好冰柜投放到同一商店，两项资产变化作为同一笔操作处理。

替换冰柜

替换日期

商店名称

区域

经手人

坏冰柜编码

新冰柜编码（在库好冰柜）

新冰柜型号

新冰柜属性

原因 / 备注

冰柜替换记录

日期	商店	坏冰柜	新冰柜	区域	经手人	备注	状态	操作

在库冰柜：这里只显示仓库内冰柜。投放只能选择好冰柜；报废只允许异常、待检修、待报废或旧冰柜。

在库总数

0

好冰柜

0

坏冰柜

0

待检修 / 待报废

0

在库冰柜浏览

空格 = AND · | = OR · ! = 排除 · 引号 = 精确短语

冰柜编码	型号	属性	质量	新旧	入库日期	来源	备注

购买冰柜入库：用于新增购买冰柜资产，默认进入仓库，质量为好、新旧状态为新；提交后由执行经理审批。

购买冰柜入库

入库日期

默认地址

数量

冰柜型号

冰柜属性

质量状态

新旧状态

经手人

冰柜编码

原因 / 备注

购买冰柜入库记录

日期	冰柜编码	型号	属性	经手人	备注	状态	操作

报废冰柜出库：只处理在库异常柜、待检修柜、待报废柜或旧柜；正常“新 + 好”冰柜不能报废。

报废冰柜出库

日期

冰柜编码（可报废在库冰柜）

冰柜型号

冰柜属性

新旧状态

质量状态

经手人

原因 / 备注

冰柜报废记录

日期	冰柜编码	型号	属性	新旧	质量	经手人	备注	状态	操作

Inspection records keep the salesperson result, cleaning status, follow-up flag, remark and linked order.

Inspection Records

Space = AND · | = OR · ! = exclude · quotes = exact phrase

Time	Store	Freezer	Salesperson	Cleaned	Problem Follow-up	Remark	Order

Submit Store / Freezer Information Change

Target Type

Target Name / Code

Requested By

Requested Changes

Change Requests

Request No.	Type	Target	Detail	Status	Action

Other inbound is submitted by Warehouse and changes inventory only after Executive Manager approval.

Other Inbound

Product

Reason Type

Unit

Quantity

Reason

Other Inbound Requests

No.	Time	Product	Quantity	Reason	Status	Action

Other outbound is submitted by Warehouse and changes inventory only after Executive Manager approval.

Other Outbound

Product

Reason Type

Unit

Quantity

Reason

Other Outbound Requests

No.	Time	Product	Quantity	Reason	Status	Action

Warehouse Activity Records

All confirmed inventory movements are listed here. Search follows Everything-style rules.

Space = AND · | = OR · ! = exclude · quotes = exact phrase

Time	User	Type	Document	Product Code	Product	Boxes Eq.	Change pcs	Before pcs	After pcs	Remark

Add Employee

Employee Code

Employee Name

Position

Phone

Status

Remark

Employee List

Code	Name	Position	Phone	Status	Remark

Owner may correct or reverse finalized data, but the original record is never silently overwritten. Every correction creates a new linked record and operation log.

Inventory Transaction Reversal

Inventory Transaction

Reason

Payment Correction

Payment Record

Collected?

Actual Amount

Method

Reason

Correction & Reversal History

Time	Type	Target	Detail	User	Reason

Local trial account management. The online version will verify all permissions again in the server API.

Create User Account

Username

Display Name

Temporary Password

Status

Workspaces / Roles

User Accounts

Username	Display Name	Roles	Status	Action

Detailed permission enforcement is intentionally postponed. The data structure is reserved now so future online development does not require a business-table redesign.

Planned Roles

Confirmed Future Rules

Operation Logs

Time	Module	Action	Target	User	Workspace	Remark

General Settings

Cold Storage Capacity (boxes)

Payment Methods (comma separated)

Currency

Schema Version

Future Online Architecture

网页 / Windows / Android → HTTPS 443 → Node.js API → MySQL
服务器 MySQL = 唯一正式数据源
离线客户端 = 缓存 + 草稿 + 待同步队列
库存 / 收款 / 冰柜等关键操作必须在线并由服务器事务校验

OWNER ONLY · MASTER DATA

Excel Batch Import

Download the prescribed Excel template, fill it, choose the file and import in one action. Every import is snapshotted and logged.

1Download template2Fill Excel3One-click import

The file is validated first. If any required row is invalid, nothing is written. No second confirmation dialog is shown after validation.

P

Products

Required: Product Code, Product Name, Units Per Box

Choose Excel File

No file imported yet.

S

Stores + Freezers

Required: Store Name, Freezer Brand, Freezer IDN. The freezer is created automatically and bound to the store.

Choose Excel File

No file imported yet.

F

Freezers

Only Freezer Brand and Freezer IDN are required. Store, model and dates are optional.

Choose Excel File

No file imported yet.

E

Employees

Required: Employee Code, Employee Name

Choose Excel File

No file imported yet.

¥

Price Systems & Prices

Required: Price System Code, System Name, Product Code, Outbound Price Per pcs

Choose Excel File

No file imported yet.

Batch Import History

Search uses the same Everything-style rules as other system searches.

Space = AND · | = OR · ! = exclude · quotes = exact phrase

Time	Type	File	Rows	Created	Updated	User	Remark

This trial uses IndexedDB. Export backups to another device or cloud drive. Browser storage alone is not a complete backup.

Full Data Backup

Reset Trial Data

This clears only the current V3.7 trial database. It does not read or delete the old aice_basic_v2 LocalStorage data.

数据中心

经营数据

点击指标查看只读明细

市场与资产

管理与异常

选择上方指标查看明细

此处仅查看，不执行岗位业务操作；需要处理时请切换到对应工作台。

选择上方指标查看明细

审批中心

只集中当前管理工作台独有的审批；日常岗位操作仍需切换到对应工作台。

异常中心

集中查看库存、配送、财务和巡检异常，不在本页面执行岗位处理。

异常明细

类型	对象	状态	备注

经营报表

执行经理经营报表以业务数量和效率为主，不展示敏感财务金额。

本月业务概览

项目	数值	说明

配送管理

执行经理可在此进行配送任务指派、改派和收回；配送执行结果仍由配送员工作台完成。

配送任务管理

任务	商店	状态	配送员	操作

管理动态

只读展示最近公司的关键业务与管理动作。

时间	模块	操作	对象	用户	工作台	备注

AICE Operations Login

Choose a Workspace

工作台

Quick Actions

Workspace Activity

Confirmed Workflow

Items Requiring Attention

Recent Business Activity

Market Details

Add Product

Product List

Add Outbound Price System

Price Systems

New Factory Order

Factory Orders

Confirm Goods Receipt

Receipt History

Current Inventory

Inventory Transactions

Inventory Adjustment

Return to Factory

Add Store

Bind / Change Store Price System

Store List

Price Systems

New Price Change Request

Price Requests

New Inspection

Inspection Result

New Sales Order

Add Store

Store Information Change

Store List

Order Records

Delivery Tasks

Complete Delivery & Record Collection

Payment Verification

Add Freezer Model

Freezer Models

冰柜信息总表

最近冰柜动态

异常冰柜

长期未巡检 / 本月未巡检

购买 / 报废审批

市场冰柜浏览

拉回冰柜

拉回冰柜记录

投放冰柜

投放冰柜记录

转投冰柜

冰柜转投记录

替换冰柜

冰柜替换记录

在库冰柜浏览

购买冰柜入库

购买冰柜入库记录

报废冰柜出库

冰柜报废记录

Inspection Records

Submit Store / Freezer Information Change

Change Requests

Other Inbound

Other Inbound Requests

Other Outbound

Other Outbound Requests

Warehouse Activity Records

Add Employee

Employee List

Inventory Transaction Reversal

Payment Correction

Correction & Reversal History

Create User Account

User Accounts

Planned Roles

Confirmed Future Rules

Operation Logs

General Settings

Future Online Architecture

Excel Batch Import

Products