The following query produces a list of charge entries for which no sort code was selected during data entry. Be sure to modify the date range to the period that you want to examine.
SELECT
lastname, firstname, id, jnum, trandate, provcode, srvcode, amount, adduser
FROM
sos.rv_charges
WHERE
sortcode IS NULL
AND trandate BETWEEN '2013-01-01' AND '2013-03-31'
ORDER BY
lastname,firstname,id,trandate
Credits are a bit more complicated. If a creditsplit has been applied, and no sort code has been specified for the entire credit entry, some SOS reports will trace back to the charge being paid and report the amount of the creditsplit with the linked charge’s sort code. The following query ignores the linked charge and reports based on the absence of a specified sort code on the credit itself.
SELECT
pt.lastname, pt.firstname, pt.id, jou.jnum, jou.trandate, cre.credtype, jou.amount, jou.adduser
FROM
sos.journal jou
JOIN sos.jcredits cre
JOIN sos.patients pt ON jou.ptnum = pt.ptnum
WHERE
sortcode IS NULL
AND trandate BETWEEN '2013-01-01' AND '2013-03-31'
ORDER BY
lastname,firstname,id,trandate
