"I want to create a dashboard where I can see all the invoices issued in a month, invoices issued for each client, receipts, outstanding payments, payment terms for each invoice and contact addresses where notifications can be sent if the due date has passed. I also want to see the breakdown of overdues by time period, e.g. less than 5 days, between 5 and 10 days, more than 10 days, etc."
Dependencies:
B
Total Outstanding Payments
Average Payment Terms
Total Invoices Issued
Orders Table
All status 2024| Date | Status | Customer | Product | Revenue | |
|---|---|---|---|---|---|
| 01 Nov 2023, 10:20 AM | Paid | Nike Sport 2 | $140,20 | ||
| 01 Nov 2023, 10:53 AM | Paid | Valvet T-Shirt | $42,00 | ||
| 01 Nov 2023, 11:13 AM | Refunded | Leather Wallet | $25,50 | ||
| 01 Nov 2023, 12:20 AM | Paid | Bracelet Onu-Lino | $190,40 | ||
| 01 Nov 2023, 1:40 PM | Cancel | Phone Case Pink x2 | $200,90 |