AR Aging — open invoice lines

Source: CRM invoicedetails.gr_balanceowe > 0 · ADR-0019 customer-facing → CRM canonical · Generated 2026-05-16 21:26 UTC
Generated 2026-05-16 21:26 UTC
Every open invoice line is a row. Click the invoice number to open the record in Dataverse. Period tabs filter by invoice due date. The 'No due date' bucket has invoices without billingenddate or duedate set — they need a PM action.
TodayMTDQTDYTDLast MonthLast QtrLast YrLast 12 MoAll
from to
Group by
41
open lines
$12,167.28
open balance
$12,167.28
bucket 0-30
41 rows
InvoiceSiteLeaseLineProductGLDueAgeBucketBalance
0-30 · 41 rows
Unit# 70 04/25/2026 - 05/01/2026Crosby HeightsWL-Unit-1080(no description)Pet Fee (Per Pet)—2026-05-0115d0-30$10.00
Perez SodaCrosby HeightsWL-Unit-1035(no description)Security Deposit (Return to Customer)—2026-05-0115d0-30$464.00
Unit #40 03/28/2026 - 05/01/2026Crosby HeightsWL-Unit-1032(no description)Rent -Weekly (Non Lake View)-$235—2026-05-0115d0-30$225.00
Unit #40 03/28/2026 - 05/01/2026Crosby HeightsWL-Unit-1032(no description)Weekly Rent 275—2026-05-0115d0-30$1,060.00
#179 - 04/23/26 - 05/01/26Willis LakesWL-Unit-1057(no description)Rent -Weekly (Non Lake View) $275—2026-05-0115d0-30$75.00
#185 - 04/27/26 - 05/04/26 [2/5weeks]Willis LakesWL-Unit-1123(no description)Rent -Weekly (Non Lake View) $275—2026-05-0313d0-30$235.00
Unit # 33 04/28/26 - 05/04/26Crosby HeightsWL-Unit-1043(no description)Weekly Rent 275—2026-05-0412d0-30$265.00
#193 - Deposit + Rent 04/01 - 05/06Willis LakesWL-Unit-1112(no description)Rent -Weekly (Non Lake View)-$235—2026-05-0511d0-30$1,175.00
#009 - 04/29/26 - 05/06/26Willis LakesWL-Unit-1076(no description)Late Fee—2026-05-0511d0-30$27.50
Unit # 336 04/30/2026 - 05/06/2026Crosby HeightsWL-Unit-1086(no description)Rent -Weekly (Non Lake View)-$235—2026-05-0610d0-30$235.00
Unit # 56 04/30/26 - 05/06/26Crosby HeightsWL-Unit-1054(no description)Weekly Rent 275—2026-05-0610d0-30$175.00
Unit # 11 04/30/2026 - 05/06/2026Crosby HeightsWL-Unit-1009(no description)Rent -Weekly (Non Lake View)-$235—2026-05-0610d0-30$225.00
Unit # 15 05/01/2026 - 05/07/2026Crosby HeightsWL-Unit-1003(no description)Weekly Rent 275—2026-05-079d0-30$265.00
#207 - Deposit + 05/01/26 - 05/08/26Willis LakesWL-Unit-1128(no description)Rent -Weekly (Non Lake View)-$235—2026-05-079d0-30$225.00
#151- 05/01/26 - 05/08/26Willis LakesWL-Unit-1050(no description)Rent -Weekly (Non Lake View) $275—2026-05-079d0-30$265.00
#155 - 04/24 - 05/08 [week 1/5, 2/5]Willis LakesWL-Unit-1078(no description)Rent -Weekly (Non Lake View)-$235—2026-05-079d0-30$450.00
#145 -05/01/26 - 05/08/26Willis LakesWL-Unit-1085(no description)Rent -Weekly (Non Lake View) $275—2026-05-079d0-30$275.00
#148 - 05/01/26 - 05/08/26Willis LakesWL-Unit-1099(no description)Rent -Weekly (Non Lake View) $275—2026-05-079d0-30$255.00
#117 - 05/01/26 - 05/08/26Willis LakesWL-Unit-1071(no description)Rent -Weekly (Non Lake View) $275—2026-05-079d0-30$260.00
#025 - 05/01/26 - 05/08/26 [2/5 weeeks]Willis LakesWL-Unit-1122(no description)Rent -Weekly (Non Lake View)-$235—2026-05-079d0-30$235.00
#132 - 05/01/26 - 05/08/26Willis LakesWL-Unit-1083(no description)Rent -Weekly (Non Lake View) $275—2026-05-079d0-30$275.00
Unit # 73 04/25/2026 - 05/08/2026Crosby HeightsWL-Unit-1069(no description)Rent -Weekly (Non Lake View)-$235—2026-05-088d0-30$460.00
Unit # 28 05/06/2026 - 05/11/2026Crosby HeightsWL-Unit-1022(no description)Late Fee—2026-05-115d0-30$24.00
Testing InvoiceCrosby HeightsWL-Unit-1060(no description)Rent Weekly $265—2026-05-115d0-30$250.00
#156 - 05/06/26 - 05/13/26Willis LakesWL-Unit-1098(no description)Rent -Weekly (Non Lake View) $275—2026-05-124d0-30$265.00
#156 - 05/06/26 - 05/13/26Willis LakesWL-Unit-1098(no description)Late Fee—2026-05-124d0-30$26.50
#160 - 04/28/26 - 05/12/26Willis LakesWL-Unit-1113(no description)Rent -Weekly (Non Lake View)-$235—2026-05-124d0-30$235.00
#160 - 04/28/26 - 05/12/26Willis LakesWL-Unit-1113(no description)Rent -Weekly (Non Lake View) $275—2026-05-124d0-30$275.00
#173 - 05/07/26 - 05/14/26Willis LakesWL-Unit-1022(no description)Rent -Weekly (Non Lake View) $275—2026-05-133d0-30$0.64
Key FobCrosby HeightsWL-Unit-1097(no description)Fob Deposit—2026-05-142d0-30$100.00
Unit # 65 05/08/2026 - 05/14/2026Crosby HeightsWL-Unit-1083(no description)Rent -Weekly (Non Lake View)-$235—2026-05-142d0-30$185.00
#337 05/08/2026 - 05/14/2026Crosby HeightsWL-Unit-1092(no description)$225 Rent -Weekly (Non Lake View)-Opening discount-First responder/teacher—2026-05-142d0-30$211.00
#21 - $500 Deposit $235 Rent 03/13 - 05/15/26Willis LakesWL-Unit-1094(no description)Rent -Weekly (Non Lake View)-$235—2026-05-142d0-30$1,125.00
#002 - 05/01/26 - 05/15/26Willis LakesWL-Unit-1003(no description)Rent -Weekly (Non Lake View)-$235—2026-05-142d0-30$450.00
#013 - 05/08/26 - 05/15/26Willis LakesWL-Unit-1012(no description)Rent -Weekly (Non Lake View) $275—2026-05-142d0-30$250.00
#025 - 05/08/26 - 05/15/26 [3/5 weeeks]Willis LakesWL-Unit-1122(no description)Rent -Weekly (Non Lake View)-$235—2026-05-142d0-30$112.50
#108 - 05/01/26 - 05/15/26Willis LakesWL-Unit-1086(no description)Rent -Weekly (Non Lake View) $275—2026-05-142d0-30$530.00
Unit # 70 05/09/2026 - 05/15/2026Crosby HeightsWL-Unit-1080(no description)Late Fee—2026-05-151d0-30$24.00
#128 - 05/09 - 05/16/26Willis LakesWL-Unit-1039(no description)Rent -Weekly (Non Lake View) $275—2026-05-151d0-30$162.14
#176 - 05/09/26 - 05/16/26Willis LakesWL-Unit-1051(no description)Rent -Weekly (Non Lake View) $275—2026-05-151d0-30$275.00
#129 - 05/02/26 - 05/16/26Willis LakesWL-Unit-1023(no description)Rent -Weekly (Non Lake View) $275—2026-05-151d0-30$530.00
$12,167.28
TOTAL$12,167.28
analytics-01 / gr-pipeline · back to landing