When invoices don’t show up in Provider Portal payment schedules, it’s usually because the Service Order header and detail lines have mismatched end dates. This often happens when canceled service periods incorrectly change the header’s end date.
Symptoms
Invoices missing from Provider Portal.
Service Order header shows an end date beyond actual service periods.
Manual payment entry is possible but not recommended (risk of duplicate payments).
Cause
Older versions of the Provider Portal interface use the stored procedure p_abacus_service_orders with incorrect logic:
max(case when s.cancelled_on is not null then s.adj_start_date else coalesce(s.end_date, @c_future) end) date_to
This logic uses the canceled end date instead of the actual end date, causing discrepancies.
Fix
Updated logic in version 23.1.1:
max(case when s.cancelled_on is not null then @c_past else coalesce(s.end_date, @c_future) end) date_to
This ensures the correct end date alignment.
Resolution Steps:
Upgrade Provider Portal to version 23.1.1 or later (latest is 25.2).
If you require further assistance please raise a new case.