Archive for the ‘Great Plains’ Category
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
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
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
Support Debugging Tool Customization #8 – Displaying Long Item Descriptions on SOP Blank Invoice
This article is based on a recent support request on the SOP Blank Invoice Report form. The Item Description on the report was just 60 characters and the actual item description was about 100 characters. This resulted in the item description getting truncated. I have written this article using the article titled “How to display [...]
October 31, 2011 · veeyeskay · 3 Comments
Tags: component-sequence, field split, item description, line item sequence, long descrption, rw_TableLineString, sop blank invoice, sop number, sop type · Posted in: Customizations, Dynamics, Great Plains, Support Debugging Tool Total Views: 148
Support Debugging Tool Customization #7 – Receiving Unit Cost Threshold Validation
Based on a recent requests on the community, where the requirement was to validate that the unit cost entered in the Receiving Transaction Entry window is not more (or) less than a specified threshold of the Unit Cost entered in the respective PO line. I have used Support Debugging Tool to handle this requirement. I [...]
October 8, 2011 · veeyeskay · 3 Comments
Tags: enter match invoice, enter/match invoice, extended cost, purchase invoice, purchase-order, receiving item detail entry, Receiving Transaction Entry, threshold, unit cost · Posted in: Customizations, Dynamics, Great Plains, Support Debugging Tool Total Views: 118