MRP-PO-GRN-Inventory Tracking

MRP ID Material Description PO Details GRN Status Inventory Update Actions
MRP-001 Stainless Steel Sheets
Req Qty: 500
PO-2301-001
Qty: 300 | Vendor: SteelCo
Order Date: 2023-11-01 | Delivery: 2023-11-10
Completed
Received: 300 | GRN: GRN-2301-001
GRN Date: 2023-11-09
Current Stock: 300
Last Updated: 2023-11-09
Location: WH-A12
PO-2301-002
Qty: 200 | Vendor: MetalWorld
Order Date: 2023-11-05 | Delivery: 2023-11-15
Partial (150/200)
Received: 150 | GRN: GRN-2301-002
GRN Date: 2023-11-14
Current Stock: 450
Last Updated: 2023-11-14
Shortage: 50
MRP-002 Industrial Bearings
Req Qty: 1000
PO-2301-003
Qty: 1000 | Vendor: BearingPro
Order Date: 2023-11-10 | Delivery: 2023-11-20
Pending
Received: 0 | GRN: -
Current Stock: 200
Last Updated: 2023-11-12
Deficit: 800
MRP-003 Electrical Components
Req Qty: 200
PO-2301-004
Qty: 200 | Vendor: ElectroTech
Order Date: 2023-11-08 | Delivery: 2023-11-18
Completed
Received: 200 | GRN: GRN-2301-003
GRN Date: 2023-11-17
Current Stock: 200
Last Updated: 2023-11-17
Location: WH-B05
Legend:

Pending Partial Completed ▼ Discrepancy

MRP = Material Requirements Planning | PO = Purchase Order | GRN = Goods Received Note