Author Archive
SQL Script for AP-GL Reconciliation
Hi all It has been some time since I have posted something useful on my blog. This was because I was busy writing up and testing the reconciliation script that I had developed to reconcile payables and receivables with the general ledger. In this article, I have posted a script to reconcile payables with general [...]
January 17, 2012 · 
veeyeskay · 
2 Comments
Tags: ap to gl, ap to gl reconcile, General Ledger, payables, Payables Reconciliation, reconcile, Reconciliation · Posted in: Accounts Payables, Dynamics, General Ledger, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 369
Windows Desktop Screen Layout Issue
Today, I have decided to post an article on a recent issue which I assisted one of my friends, who had the desktop layout showing upside down. The issue generally happens when you press the CTRL + ALT and any of the keyboard arrow keys. I decided to explain about this windows functionality in this [...]
January 8, 2012 · veeyeskay · One Comment
Tags: desktop, screen tilt, screen view, vista, windows · Posted in: Windows Total Views: 112
Support Debugging Tool–Build 16 Available Now!
Hi all The all awaited Build 16 of the Support Debugging Tool is available now…and of course with loads and loads of new features and splendid enhancements. Some of the key additions to SDT is listed below. Macro Recording Functionality SQL Profile Tracing Functionality Trigger Administration Functionality Automation Functionality for Microsoft Support Usage These are [...]
January 6, 2012 · veeyeskay · One Comment
Tags: automation, build 16, David Musgrave, macro recording, sql profile trace, support debugging tool, trigger administration, triggers · Posted in: Dynamics, Great Plains, Support Debugging Tool Total Views: 130
Seasons Greetings
Hi all Wishing the entire community a Merry Christmas and a very Happy and Prosperous New Year 2012. Hope to post a lot more interesting articles in the following year… More coming soon! Read the rest of this entry
December 24, 2011 · veeyeskay · One Comment
Tags: Happy New Year, merry-christmas, Season's Greetings · Posted in: Around The Globe, Miscellaneous Total Views: 138
Posting Interruptions in Accounts Payable – Check Runs
Recently, I was responding to a forum discussion where the issue mentioned was as shown below. “Occasionally, one of the subsystems that we integrate invoices from will send over an invoice with an incorrect date (11/20/1911 instead of 11/20/2011). These invoices post just fine. However, when we process a check run that includes an invoice [...]
November 24, 2011 · veeyeskay · 3 Comments
Tags: batch recovery, check batches, computer checks, connect, Document Date, edit list, fiscal-period, interruption, Invoices, Microsoft Connect, posting interruption, verify tool · Posted in: Accounts Payables, Dynamics, Great Plains Total Views: 208
Price Level Defaulting in SOP Entry
Recently, I was handling a support case, where the user raised an issue in the way the Price Level was defaulting in the Sales Transaction Entry window line. The issue is explained below. “I have a client whose standard pricing doesn’t seem to be working as expected, or at least as I thought it should. [...]
November 20, 2011 · veeyeskay · 3 Comments
Tags: default, default price level, item price list, Line Item, price level, price list, receivables, sales invoice, sales quote, sales transaction entry, sales-order, sop line item, standard pricing · Posted in: Dynamics, Great Plains, Inventory, Sales Order Processing Total Views: 116
Receivables Inquiry Window – YTD Sales Amount Logic
A client of ours, sent out an email today saying that the YTD Sales Amount that they see on the Receivables Yearly Summary Inquiry window does not match with the Receivables Transactions smartlist’s Sales Amount pulled for the specific customer for the specific year. On analyzing the issue, I noticed that they have only pulled [...]
November 18, 2011 · veeyeskay · 3 Comments
Tags: receivables summary, receivables transaction, Smartlist · Posted in: Accounts Receivables, Dynamics, Great Plains Total Views: 160
Support Debugging Tool Customization #10 – Credit Limit Check Skip in Receivables Transaction Entry (using SQL Execute in SDT)
Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/a3237a4f-fa4c-4603-8048-94cc0b2af467 where the requirement was as below. “Is there anything in Accounts Receivable that will allow a certain type of document (whatever that may be) bypass the Credit Limit Check? My client has a customer with a Credit Limit of $5000. They are additionally seeking a [...]
November 4, 2011 · veeyeskay · 5 Comments
Tags: credit, credit limit bypass, credit limit check, credit-limit, customer, customer-number, debit memos, document-type, no credit, receivables, sql execute, unlimited credit · Posted in: Accounts Receivables, Customizations, Dynamics, Great Plains, Support Debugging Tool Total Views: 87
Support Debugging Tool Customization #9 – Credit Limit Check Skip in Receivables Transaction Entry (using Native Dexterity Save Logic)
Recently there was a support request in the forum, http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/a3237a4f-fa4c-4603-8048-94cc0b2af467 where the requirement was as below. “Is there anything in Accounts Receivable that will allow a certain type of document (whatever that may be) bypass the Credit Limit Check? My client has a customer with a Credit Limit of $5000. They are additionally seeking Read [...]
November 3, 2011 · veeyeskay · 8 Comments
Tags: credit, credit limit bypass, credit limit check, credit-limit, customer, customer-number, debit memos, document-type, no credit, receivables, unlimited credit · Posted in: Customizations, Dynamics, Great Plains, Support Debugging Tool Total Views: 100
Smartlist Builder Example – Sub Query Restriction Prototype
Hi all Recently, there was a discussion in the forum, where there was a request to provide a restriction on a custom smartlist, which does the same as the SQL query below. SELECT * FROM dbo.PM30600 WHERE VCHRNMBR IN ( SELECT VCHRNMBR FROM dbo.PM30600 WHERE DSTINDX IN ( 167, 256 ) ) AND dbo.PM30600.DOCTYPE = [...]
November 1, 2011 · veeyeskay · 2 Comments
Tags: custom smartlist, is equal to one of list, pm distribution history, pm30600, restriction. filter, Smartlist, sql query, subquery restriction · Posted in: Dynamics, Great Plains, Smartlist Builder Total Views: 119