Home » DEVELOPMENT » Dexterity
Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 400 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Dynamics CPM
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: Dexterity
Links Sort by: Hits | References | Alphabetical
"desSPRkmhBBCreh" makes me Smile!
http://www.jivtesh.com/2008/10/makes-me-smile.html
I just read an incredible piece of history from David's Blog - "What is Column desSPRkmhBBCreh?", I am still smiling thinking about the ingenuity and cheekiness of the developers.
Appar…
Posted by
Accessing Form Menu from Global Scripts - Patrick Roth
This is very good article on How to Access Form Menu from Global Scripts, from Patrick Roth, on Developing for Dynamics GP blog.
I have done exactly the same…
http://www.vaidy-dyngp.com/2008/12/accessing-form-menu-from-global-scripts.html
This is very good article on How to Access Form Menu from Global Scripts, from Patrick Roth, on Developing for Dynamics GP blog.
I have done exactly the same…
Posted by
Adding AutoComplete Items with Dexterity
http://blogs.msdn.com/developingfordynamicsgp/archive/2009/05/01/adding-autocomplete-items-with-dexterity.aspx
In this case, the customer didn't want to use the lookup window to select an existing item number, they wanted it to be in the autocomplete list. The problem is that in order for it to get into the autocomplete list, you have to select or type it at least one time. They wanted all of the items in the autocomplete list…
Adding AutoComplete with Dexterity
http://msdynamicsgp.blogspot.com/2009/05/adding-autocomplete-with-dexterity.html
Dave Dusek provides information on how to populate auto complete entries for a field using…
Posted by
All about the Dexterity OLE Container
http://blogs.msdn.com/developingfordynamicsgp/archive/2008/11/29/all-about-the-dexterity-ole-container.aspx
All about the Dexterity OLE Container
http://dynamicsgpblogster.blogspot.com/2008/11/all-about-dexterity-ole-container.html
Posted by
Recommended byhttp://blogs.msdn.com/developingfordynamicsgp/archive/2008/11/29/all-about-the-dexterity-ole-container.aspx
http://dynamicsgpblogster.blogspot.com/2009/10/more-on-ole-attachments-and-record.html
http://dynamicsgpland.blogspot.com/2010/08/from-blog-archives-dynamics-gp-notes.html
http://dynamicsgpblogster.blogspot.com/2010/08/all-about-dexterity-ole-container.html
http://dynamicsgpblogster.blogspot.com/2013/02/ole-notes-and-microsoft-dynamics-gp.html
http://dynamicsgpblogster.blogspot.com/2009/10/more-on-ole-attachments-and-record.html
http://dynamicsgpland.blogspot.com/2010/08/from-blog-archives-dynamics-gp-notes.html
http://dynamicsgpblogster.blogspot.com/2010/08/all-about-dexterity-ole-container.html
http://dynamicsgpblogster.blogspot.com/2013/02/ole-notes-and-microsoft-dynamics-gp.html
Altering a Table From Dex
I got an interesting query from a guy on how to alter a table without using any SQL statements from within Dexterity.
As per the Dexterity Guide, a table cannot be altered from within Dexterity, that means only thru' Dex coding. If you’re converting tables stored in a SQL database, you must use pass-through SQL to perform the conversion.
Having said that, we can do it from Dexterity but calling a SQL Stored Procedure which will contain the necessary SQL Statements for that table alteration.
1. Make the necessary table changes on Dex Dictionary.
2. Write a SQL Stored Procedure like below (The SQL SP is written on SQL Server 2005 DB and uses SQL 2005 syntaxes):
/* Drop the SP if it exists */
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Custom_Tables_Alteration]') AND type in (N'P', N'PC'))
DRO…
http://www.vaidy-dyngp.com/2009/01/altering-table.html
I got an interesting query from a guy on how to alter a table without using any SQL statements from within Dexterity.
As per the Dexterity Guide, a table cannot be altered from within Dexterity, that means only thru' Dex coding. If you’re converting tables stored in a SQL database, you must use pass-through SQL to perform the conversion.
Having said that, we can do it from Dexterity but calling a SQL Stored Procedure which will contain the necessary SQL Statements for that table alteration.
1. Make the necessary table changes on Dex Dictionary.
2. Write a SQL Stored Procedure like below (The SQL SP is written on SQL Server 2005 DB and uses SQL 2005 syntaxes):
/* Drop the SP if it exists */
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Custom_Tables_Alteration]') AND type in (N'P', N'PC'))
DRO…
Posted by
Any Font in the Dex Script Editor
http://msdynamicsgp.blogspot.com/2009/07/any-font-in-dex-script-editor.html
David Musgrave brings us an undocumented feature (the good kind, not a bug euphemism) on…
Any Font in the Dexterity Script Editor
http://blogs.msdn.com/developingfordynamicsgp/archive/2009/07/06/any-font-in-the-dexterity-script-editor.aspx
Auto-Complete for Dexterity Coding?!?!
http://mohdaoud.blogspot.com/2010/08/auto-complete-for-dexterity-coding.html
Last year, David posted an article that shocked all Dexterity developers, he created a screenshot that shows dexterity codes inside Visual Studio .Net! Developers using dexterity was very much excited to work on that, but unfortunately it was April fool’s day and David couldn’t live without posting such an article!
How…
Posted by
BlackBox - The First Dexterity Game
http://blogs.msdn.com/developingfordynamicsgp/archive/2008/07/24/blackbox-the-first-dexterity-game.aspx
The concept of the game is to find the location of a number of atoms hidden in a 8 by 8 grid. Your only method of looking for the atoms is to "fire" beams into the grid from the edges of the grid…
Recommended byhttp://www.jivtesh.com/2008/07/dynamics-gp-is.html
Building a COM Interop Assembly to use with Microsoft Dexterity
http://dynamicsgpblogster.blogspot.com/2010/01/building-com-interop-assembly-to-use.html
Calling SQL Server stored procedures from Microsoft Dexterity
http://dynamicsgpblogster.blogspot.com/2009/01/calling-sql-server-stored-procedures.html
Can I customise a 3rd party form with Dexterity?
http://blogs.msdn.com/developingfordynamicsgp/archive/2008/11/10/can-i-customise-a-3rd-party-form-with-dexterity.aspx
Carefully Place Variables Assignment in Dex
http://www.vaidy-dyngp.com/2010/07/carefully-place-variables-assignment-in.html
This post is right after a coding correction done in one of my customizations.
There is a form which needs to be opened from both SOP Entry & SOP Inquiry. Based on the source, I had to either lock or unlock certain fields, exactly like how SOP Entry & SOP Inquiry windows work.
I created a GLOBAL field called "SOPSource" and created two Startup trigger scripts, namely SOP_Entry_Open_Addl and SOP_Inquiry_Open_Addl on SOP_Entry and SOP_Inquiry respectively. Inside each script, I wrote a piece of code like below:
op…
There is a form which needs to be opened from both SOP Entry & SOP Inquiry. Based on the source, I had to either lock or unlock certain fields, exactly like how SOP Entry & SOP Inquiry windows work.
I created a GLOBAL field called "SOPSource" and created two Startup trigger scripts, namely SOP_Entry_Open_Addl and SOP_Inquiry_Open_Addl on SOP_Entry and SOP_Inquiry respectively. Inside each script, I wrote a piece of code like below:
op…
Posted by
Carefully Place Variables Assignment in Dex
http://msdynamicsgp.blogspot.com/2010/07/carefully-place-variables-assignment-in.html
Vaidy looks a goof he made assigning variables in Dynamics GP. Check out his post Carefully…
Changing Dictionary Context when using Passthrough Dexterity sanScript For Dynamics GP Part 2
http://msdynamicsgp.blogspot.com/2010/07/changing-dictionary-context-when-using_14.html
Changing Dictionary Context when using Passthrough Dexterity sanScript Part 1
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2010/07/12/changing-dictionary-context-when-using-passthrough-dexterity-sanscript-part-1.aspx
Posted by
Recommended byhttp://www.vaidy-dyngp.com/2010/07/changing-dictionary-context-when-using.html
http://msdynamicsgp.blogspot.com/2010/07/changing-dictionary-context-when-using.html
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/08/31/21-reasons-why-every-workstation-should-have-the-support-debugging-tool-installed.aspx
http://msdynamicsgp.blogspot.com/2010/07/changing-dictionary-context-when-using.html
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/08/31/21-reasons-why-every-workstation-should-have-the-support-debugging-tool-installed.aspx
Changing Dictionary Context when using Passthrough Dexterity sanScript Part 1
http://msdynamicsgp.blogspot.com/2010/07/changing-dictionary-context-when-using.html
David Musgrave is starting a new series designed to help developers understand Dexterity…
Changing Dictionary Context when using Passthrough Dexterity sanScript Part 2
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2010/07/14/changing-dictionary-context-when-using-passthrough-dexterity-sanscript-part-2.aspx
Posted by
Latest links
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Attachment Reminder feature in Outlook 2013
- Taking Your Financial Reports to the Next Level with Management Reporter – Quarterly Tax Form (7 of 8)
- GP 2013: Why are my SmartLists not formatted when exported to Excel?
- Using Sparklines & Data Bars to Visualize Data in SQL Server Reporting Services Reports
- More Funny Microsoft Videos
- Technical Tips for Management Reporter 2012 with Data Mart | Dynamics GP Insights
- Taking Your Financial Reports to the Next Level with Management Reporter – Statement of Cash Flows (6 of 8) – Dynamics Corporate Performance Management – Site Home – MSDN Blogs
- Book Review: Instant Creating Data Models with PowerPivot How-to
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.