======Adjustments by Type and by Client for a Period======

Back to [[QueryDirectory Query Directory]]

// 
I want a detailed or summary report of adjustments for a particular date range, grouped by type and then by client.
//
The detailed query would be:

%%(sql)
SELECT 
	adjcode, fullnameid, trandate, payorname, amount
FROM 
	rv_credits 
WHERE 
	credtype = 'Adjustment' 
	AND trandate BETWEEN '2000-01-01' AND '2008-07-31' 
ORDER BY 
	adjcode, fullnameid, trandate 
%%

and the summary query would be:

%%(sql)
SELECT 
	adjcode, fullnameid, payorname, SUM(amount) 
FROM 
	rv_credits 
WHERE 
	credtype = 'Adjustment' 
	AND trandate BETWEEN '2000-01-01' AND '2008-07-31' 
GROUP BY 
	adjcode, fullnameid, payorname 
ORDER BY 
	adjcode, fullnameid, payorname
%%

----
CategoryQueries