Report corrections by subaccount for a previously invoiced billing period
Large organizations often re-allocate prior-period corrections down to individual projects, subscriptions, or resource groups. This allows each team to see the historical adjustments that affect its spend.
- Source
- FOCUS MCP snapshot
- FOCUS editions
- v1.0, v1.1, v1.2
- Queries
- 1
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
- Source
- FOCUS use-case SQL
- Status
- Not in v1.0 sample
- Results
- Not run
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
The sample contains no ChargeClass = 'Correction' rows (ChargeClass is null throughout), so corrections to previously invoiced billing periods cannot be reported by subaccount.
Original FOCUS SQL
SELECT ProviderName, BillingAccountId, ServiceCategory, SubAccountId, SubAccountName, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? AND ChargeClass = 'Correction' GROUP BY ProviderName, BillingAccountId, SubAccountId, SubAccountName, ServiceCategory
Columns used
Column names from the source use case.