Archive for the ‘Great Plains’ Category
Drill downs in the Security Setup windows
This article explains a very simple feature which may times goes unnoticed in Microsoft Dynamics GP 10 and 2010. We have many windows where we define the security related information. They are listed below. Security Task Security Roles User Security Alternate Modified Forms & Reports In the windows listed above, you can drill down into [...]
August 10, 2011 · 
veeyeskay · 
2 Comments
Tags: alternate forms, alternate reports, Drill Down Capabilities, Modified Forms, Modified Reports, security window enhancements, security-roles, security-tasks, user security · Posted in: Dynamics, Great Plains, Security, System Total Views: 107
Support Debugging Tool Customization #5 – Unapplied Credit on SOP Blank Invoice
Another request that came in on the support forum was to add the posted and unapplied credits for a customer on the SOP Blank Invoice for reference purposes. I have decided to post a customization code using Support Debugging Tool to achieve the same so that it will benefit the community. Version Information Dynamics GP [...]
August 9, 2011 · veeyeskay · 2 Comments
Posted in: Customizations, Dynamics, Great Plains, Sales Order Processing, Support Debugging Tool Total Views: 68
Security Window Enhancements in Dynamics GP 2010
One of the cool enhancements (which mostly goes unnoticed) in Dynamics GP 2010 is the new checkbox which is applicable in the Security windows explained below, which allows the users to see only the options selected for the particular record (i.e.) in case of the Security Roles window, the checkbox allows us to filter and [...]
August 9, 2011 · veeyeskay · 2 Comments
Tags: display selected items, dynamics gp 2010, security window enhancements, security-roles, security-tasks, user security · Posted in: Dynamics, Great Plains, Security, System Total Views: 126
Support Debugging Tool Customization #4 – U Of M Long Description on SOP Invoice
A recent support request was to add the U Of M Long Description on the SOP Blank Invoice Report. The situation explained was that the U Of M was just an abbreviation and the client was using the U Of M long Description to capture a meaningful description in the Unit Of Measure Schedule Setup [...]
August 8, 2011 · veeyeskay · 4 Comments
Tags: component-sequence, line item sequence, runtime execute, sop blank invoice, sop number, sop type, support debugging tool, u of m, u of m long description, u of m schedule · Posted in: Customizations, Dynamics, Great Plains, Inventory, Sales Order Processing, Support Debugging Tool Total Views: 114
Support Debugging Tool Customization #3 – AA Transaction Entry Auto Focus
One of the most common requests that I have received in Analytical Accounting is if the focus can be automatically set on the Transaction Dimension Code field instead of the Alias field. When the Analytical Account Transaction Entry window opens, the focus is automatically set to the Alias field and in most cases the users [...]
August 7, 2011 · veeyeskay · 2 Comments
Tags: aa transaction entry, alias, Analytical Accounting, support debugging tool, transaction dimension code · Posted in: Customizations, Dynamics, Great Plains, Support Debugging Tool Total Views: 100
Support Debugging Tool Customization #2 – Notes Disabler Enhancements
As a follow-up to the Notes Enabler Enhancements article which I had posted yesterday, I was contacted by a community user on how to deploy it since it was a customization on Dexterity and he did not have technical expertise to import Dexterity code and compile chunk files. So I have decided to post an [...]
August 6, 2011 · veeyeskay · 3 Comments
Tags: Customization Code, Notes Disabler, Record Notes, support debugging tool, Window Notes · Posted in: Customizations, Dynamics, Great Plains, Support Debugging Tool Total Views: 160
Notes Disabler Enhancements
As a follow-up to the article Support Debugging Tool Customization #1 – Notes Disabler, where I had given a sample code to restrict editing of the notes if there are notes present, there was a request on the forums that the users want the facility to add notes, but cannot change the existing notes. So [...]
August 5, 2011 · veeyeskay · 6 Comments
Tags: Notes Disabler · Posted in: Customizations, Dynamics, Great Plains Total Views: 89
SQL View for Daily Payment Summary
Hi all Based on a request from the community, I have decided to post a script for identifying all the payments made on a specific date from a checkbook and the details of what was voided for the specific date. This query helps a great deal in reconciling the funds that were used for processing [...]
August 5, 2011 · veeyeskay · 2 Comments
Tags: check amount, payment reconciliation, payment summary, voided amount · Posted in: Accounts Payables, Dynamics, Great Plains, SQL Server, SQL Server 2005 Total Views: 137
Post Through GL for Computer Checks – with Analytical Accounting
When you have Analytical Accounting module installed and configured in a GP company, the Post Through GL for Computer Checks gets automatically disabled in the specific company (even if it was turned on). If we try to activate the same manually (with Analytical Accounting activated), we get the following error message and the system prevents [...]
August 4, 2011 · veeyeskay · No Comments
Tags: analytical accounting activation, computer checks, post through general ledger files, post through gl, Posting Setup · Posted in: Analytical Accounting, Dynamics, Great Plains, SQL Server, SQL Server 2005, SQL Server 2008 Total Views: 131
Calculating Quantity on Hand in Inventory
Recently, I was assisting a community member on the forum, who was trying to reconcile the Quantity on Hand in the Item Inquiry window. Ideally, the simplest check to validate the Quantity on Hand for a particular item would be to get the transaction details from the Inventory Transaction Amounts History (IV30300) table, manipulate the [...]
August 4, 2011 · veeyeskay · One Comment
Tags: inventory reconcile, inventory transaction history, quantity on hand · Posted in: Dynamics, Great Plains, Inventory Total Views: 184