Revision [464]
Last edited on 2011-07-22 16:30:31 by adminAdditions:
======Payments by Place of Service and Year======
SELECT
year(c.trandate) as YEAR,
defcode as POS,
sum(crsplamt) as "TOTAL PAID"
FROM
jcrsplits a
join jcredits b
join journal c
join rv_charges d on a.chgsplnum=d.chgsplnum
join poscodes e on d.poscodenum=e.poscodenum
WHERE
b.credtype <> 'Adjustment'
GROUP BY
year,pos
ORDER BY
year,pos
SELECT
year(c.trandate) as YEAR,
defcode as POS,
sum(crsplamt) as "TOTAL PAID"
FROM
jcrsplits a
join jcredits b
join journal c
join rv_charges d on a.chgsplnum=d.chgsplnum
join poscodes e on d.poscodenum=e.poscodenum
WHERE
b.credtype <> 'Adjustment'
GROUP BY
year,pos
ORDER BY
year,pos
Deletions:
comments here appear in italics
paste your tested query here