Shortage & Reconciliation Dashboard

Purchase Orders (Reconciliation Pending)

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 Stored in remark_comment column

Sync Live to Invoice (copy Live → Invoice) OR Invoice → Live

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

Data Sources: Shipment Status from slot_status | PO Level Remark from remark_comment | Amz Live column is editable - Click to modify | Actual Diff = Billed Qty - (Live Qty + Short Sent)

Amazon Live Portal

Purchase Orders (Reconciliation Pending)

Bulk Download

Debug Info