Archive | Bank Rec SQL code RSS feed for this section

SQL view for bank deposits and receipts in Dynamics GP

October 6, 2011 by Victoria Yudin 11 Comments

About a year ago I published a view for a Checkbook Register and have received some follow up requests asking for a way to show the receipt details. Primarily this request seems to come from the need to see the difference in dates between the receipts and the deposits for tracking down possible bank reconciliation issues. I didn’t want to […]

Continue reading →
Bank Rec SQL code, Dynamics GP, GP Reports code, GP SQL scripts
, , ,

SQL view for Dynamics GP Checkbook Register

October 14, 2010 by Victoria Yudin 30 Comments

The view below will return all Checkbook transactions for Dynamics GP. It does not show details for the deposits because I wanted to keep this to one line per transaction, as it appears on the Checkbook Register in GP. To add deposit detail to you report, you can join table CM20300 on CM20200.CMTrxNum = CM20300.depositnumber. You […]

Continue reading →
Bank Rec SQL code, Dynamics GP, GP Reports code, GP SQL scripts
, , ,