Report corrections by subaccount for a previously invoiced billing period
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
FOCUS Versions
v1.0
v1.1
v1.2
Context
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.
FOCUS SQL Query
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