SQL view for unposted checks in Dynamics GP

I have been asked more than a few times for a script that shows uposted checks and their apply detail. This can be helpful to replace the Check Batch Edit List report, which is universally hated by all GP users I have spoken to. Sorry about the strange colors showing up in the code below. […]