IV02

Allocation Management

which pieces fill which order line

allocation, reservation and pick_task exist in the schema and hold 0 rows: the workbook has no allocation sheet, its Sales.Source_Inventory_ID was proved not to be a real link (2,575 of 2,600 rows name a lot of a different material, 232 of 240 lots oversold) and was archived rather than written as an allocation, and every order was imported already dispatched, so no open demand exists to allocate against.
Total Allocations
—
allocation holds 0 rows
Allocation Rate
—
allocated over ordered: 0 of 2,600 dispatched orders carry an allocation
Open Demand
—
no order stands before dispatch (order_status confirmed, picking, packing, ready: 0)
Allocated Qty
—
allocation.qty_kg sums to nothing
Allocation Exceptions
—
allocation.rule = override and pick_task.status = blocked: 0 rows
Avg Allocation Lead Time
—
no ORDER_CONFIRMED to ALLOCATED interval on the ledger (ALLOCATED events: 0)
Allocation List
Allocation No.Order No.CustomerMaterialQty AllocatedWarehouseAllocation DateStatus
no allocation row exists; the schema gives an allocation no human code (a UUID and the order line), and Pending / Cancelled / Partially Allocated are not schema words
What the database does hold
allocation rows…
reservation rows…
pick_task rows…
items allocated…
items reserved…
orders not yet dispatched…
ALLOCATED events…
Allocation Trend
allocated tonnes per month
Nothing to show yet
no ALLOCATED event on the ledger.
Allocation by Category
per form
Nothing to show yet
nothing allocated.
Allocation by Warehouse
Nothing to show yet
nothing allocated; the three warehouses hold 285 lots, none in status allocated.
Recent Activities
Nothing to show yet
no ALLOCATED, DEALLOCATED or PICKED event on the ledger.