Tag Archives: Bank Reconciliation

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
, , ,

What’s with all these dates?

September 8, 2009 by Victoria Yudin 21 Comments

There are many different dates stored in Dynamics GP. This is typically a good thing, my philosophy is that it is always better to have more data than you need and not the other way around. However, it can get confusing rather quickly since a lot of the labels for the dates sound very similar. I will attempt […]

Continue reading →
Dynamics GP
, , , , , ,

Dynamics GP Bank Rec table information

January 16, 2009 by Victoria Yudin 4 Comments

A new page is now available with table information for the Bank Reconciliation module.  I have reorganized all the pages a little so they are now alphabetized on the sidebar to the right and hopefully easier to find.  All of the available pages as well as other resources for GP Reports are listed on my GP […]

Continue reading →
Dynamics GP
, ,