Shortage & Reconciliation Dashboard

PO No	Appt Date	Brand	Shipment ID	Invoice No	Case Raised	Billed Qty	Live Qty	Short Sent	Actual Diff	Total Amt	Shipment Status	PO Level Remark	Actions

PO Qty

Appt Qty

Billed Qty

Live Qty

Raise Case?

PO Level Remark (存储在 remark_comment 列) This will be saved to remark_comment column

ASIN	FNSKU	Tally Name	NLC w/o Tax	GST %	PO Qty	Inv Qty	Inv Rate	Amz Live	Short Sent	Actual Diff	Total Amt	SKU REMARK

Data Sources: Shipment Status 来自 slot_status 列 | PO Level Remark 来自 remark_comment 列