Back-dated Charge Splits and Credit Splits

From time to time we at SOS hear from customers who are concerned that aging reports with the same aging base date, but printed on different dates, do not match. The differences in these reports is often because users enter additional charges and/or apply credits, but back date the charge-splits or credit applied dates. The two simple queries below provide you with a way of identifying these entries. In both of these examples, the base date is Dec 31, 2013. Replace that date with your own aging date.

Charge split dates…

SELECT
  *
FROM
  sos.rv_charges a
WHERE
  a.chgspldate <= '2013-12-31'
  AND a.postdate > '2013-12-31'

Credit split applied dates…

SELECT
  *
FROM
  sos.rv_creditsplits a
WHERE
  a.dateapplied <= '2013-12-31'
  AND a.postdate > '2013-12-31'