Tag Archives: Bank Reconciliation
piggy bank

SQL view for bank deposits and receipts in Dynamics GP

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
piggy bank

SQL view for Dynamics GP Checkbook Register

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

What’s with all these dates?

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 Bank Rec table information

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

Follow

Get every new post delivered to your Inbox.

Join 1,357 other followers