RSSCategory: Bank Reconciliation

Bank Reconciliation and Voided Checks

| 09/16/2011 | 4 Comments
Bank Reconciliation and Voided Checks

Recently, I was addressing a discussion in the forums, where a user was seeing voided checks in the Bank Reconciliation window. The user also mentioned that he never used to see voided checks appearing in the Bank Reconciliation window, but it appeared and when he was selecting the check, it gave him an error message […]

Continue Reading

SQL Script for Checkbook Balance

| 11/10/2010 | 3 Comments
SQL Script for Checkbook Balance

Hi all This time, we have a script to generate checkbook balances in Dynamics GP. Also, take a look at the checkbook register query posted by Victoria Yudin, here. SELECT Z.CHECKBOOKID, Z.GPACCOUNTNO, Z.DOCUMENTNO, Z.DOCTYPE, Z.DOCTYPENAME, Z.POSTINGDATE, Z.DOCUMENTAMOUNT FROM ( SELECT A.CHEKBKID AS CHECKBOOKID, RTRIM(D.ACTNUMST) AS GPACCOUNTNO, A.CMTrxNum AS DOCUMENTNO, C.DOCABREV AS DOCTYPE, C.DOCTYNAM AS DOCTYPENAME, […]

Continue Reading