0 ORDER BY pending_amount DESC"; $result = $conn->query($sql); $suppliers = []; $total_pending = 0; while ($row = $result->fetch_assoc()) { $suppliers[] = $row; $total_pending += $row['pending_amount']; } } catch (Exception $e) { $error = "Database error: " . $e->getMessage(); $suppliers = []; $total_pending = 0; } $page_title = 'Pending Payments'; require_once __DIR__ . '/../includes/header.php'; ?>

💰 Pending Payments

Total Pending

₹

Across all suppliers

Suppliers with Pending

Need payment settlement

Suppliers with Pending Amounts

Supplier Name	Phone	Total Supply	Total Paid	Pending Amount	Actions
		₹	₹	₹	💵 Settle 📜 History
Grand Total Pending:				₹

✅

All payments settled!

No pending payments at this time

ℹ️ Payment Management

Total Supply: Sum of all supply records for the supplier
Total Paid: Sum of all payment settlements made to the supplier
Pending Amount: Total Supply minus Total Paid
Settle Payment: Record a new payment to reduce pending amount
View History: See all past payment transactions