RachelW
4Penny.net
Points: 7753

4/25/2025 7:13:05 AM

Direct Deposit Advice report

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

I recently wrote a direct deposit report, designed to copy the one from GP. This is obviously sensitive data so I removed the numbers; but you can see the format. In order to copy the GP format I used sub reports (not my favorite), the queries below power each of the sub reports. 

 

4Penny.net
Version: All
Section: Dynamics GP,SQL Scripts,Crystal Reports,SSRS
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3